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
264 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
 
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

863 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now