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

Why is my dynamic parameter report running soooo slow and then after it is done reading the database, nothing populates the page.  What gives?
VBBRettAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Kurt ReinhardtConnect With a Mentor Sr. Business Intelligence Consultant/ArchitectCommented:
0
 
MIKESoftware Solutions ConsultantCommented:
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
 
mlmccCommented:
What data tyoe is the field?

mlmcc
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
crgary_txCommented:
How are you publishing the reports?

Gary
0
 
MIKESoftware Solutions ConsultantCommented:
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
 
VBBRettAuthor Commented:
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
 
mlmccCommented:
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
 
VBBRettAuthor Commented:
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
 
mlmccCommented:
What data type is your field?

mlmcc
0
 
VBBRettAuthor Commented:
my dynamic parameter field is of string type.  Thanks for asking mlmcc.
0
 
VBBRettAuthor Commented:
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
 
mlmccCommented:
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
 
VBBRettAuthor Commented:
I unjoined the tables and I got the following errror message

"Prompting failed with the following errror message:"

Error Source:  Error code: 0x80070057
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.