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

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

What data tyoe is the field?

mlmcc

How are you publishing the reports?

Gary

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,

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.

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

mlmcc

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}

What data type is your field?

mlmcc

my dynamic parameter field is of string type.  Thanks for asking mlmcc.

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?

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

I unjoined the tables and I got the following errror message

"Prompting failed with the following errror message:"

Error Source:  Error code: 0x80070057