Solved

Why does my dynamic parameter run so slow and then end up with nothing after it checks against the database?

Posted on 2007-03-29
13
265 Views
Last Modified: 2010-08-05
Why is my dynamic parameter report running soooo slow and then after it is done reading the database, nothing populates the page.  What gives?
0
Comment
Question by:VBBRett
  • 5
  • 4
  • 2
  • +2
13 Comments
 
LVL 17

Expert Comment

by:MIKE
ID: 18820871
Are you sure you are using the correct FIELD in your parameter?

What are you using in the record SELECTION FORMULA? Is your parameter there?

Like this:  

{Yourtable.field} = {?YourParameter}

Mike V
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 18821050
What data tyoe is the field?

mlmcc
0
 
LVL 13

Expert Comment

by:crgary_tx
ID: 18821056
How are you publishing the reports?

Gary
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
LVL 17

Expert Comment

by:MIKE
ID: 18821109
If you are using an enterprise edition...then you may need to have it scheduled to REFRESH instead of refreshing on demand..

Are you using Crystal Reports XI Server or Business Objects XI???

Also,
0
 

Author Comment

by:VBBRett
ID: 18821409
I am using Crystal Reports XI report developing tool.  Nothing more.  I was able to make the dynamic parameter by adding another command.  But unfortunately, it doesn't seem to filter like I wanted it to.  Is this because the tables have to be matched up with each other or have joins?  I took the joins out in the Database Command Expert.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 18821422
The tables need to be joined but you can have a separate command for the parameters that isn't joined to the others

mlmcc
0
 

Author Comment

by:VBBRett
ID: 18821477
Yeah, I have something setup something like this I think when i do the formula

Are you sure you are using the correct FIELD in your parameter?

What are you using in the record SELECTION FORMULA? Is your parameter there?

Like this:  

{Yourtable.field} = {?YourParameter}

0
 
LVL 100

Expert Comment

by:mlmcc
ID: 18822977
What data type is your field?

mlmcc
0
 

Author Comment

by:VBBRett
ID: 18823244
my dynamic parameter field is of string type.  Thanks for asking mlmcc.
0
 

Author Comment

by:VBBRett
ID: 18823853
Now it's crashing that I have them joined.  I have the two command tables joined and when I try to run it for new parameter prompts, it just crashes.  I don't understand what I am doing wrong?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 18823904
Is one of the tables just for the parameter prompt?  If so don't join it.

Can the strings be lengthy?  If so, then it may be taking quite a while to build the list.

mlmcc
0
 

Author Comment

by:VBBRett
ID: 18824166
I unjoined the tables and I got the following errror message

"Prompting failed with the following errror message:"

Error Source:  Error code: 0x80070057
0
 
LVL 26

Accepted Solution

by:
Kurt Reinhardt earned 500 total points
ID: 18824310
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question