Dynamic Parameter

[Former Member]

Hello All,

I have a Crystal 11.5 report where I am using a Dynamic Parameter, pointing to a View in SQL. When this report is run in the Client's environment, even after doing "Verify Database" he received an error (I can't remember exactly the error, but something like "Cannot Create Dynamic Prompt"). We can recreate the parameter, pointing to the View, but thiis report is using around 20 subreports, and this parameter is passed to them, so if we do it that way, it requires us to change all the subreports.

Is there something else I need to send the client for the Dynamic Parameter? Is is stored separately or something? I thought it was stored in the .rpt file, but then why would the client receive this error?

Any help would be appreciated.

[former_member11696]

Thank you for posting your solution

[Former Member]

Sounds like a database permission error. Does he have access to the view?

[Former Member]

Thank-you for replying Albert. I did check permissions.

I actually figured out a way around this - all I did was do a Set Database Location and point the table the dropdown was using to the same table in the new database. This fixed the issue.

[Former Member]

Looks like "Verify Database" doesn't verify the db for everything in the report ...hmmmmmmm

hmmmmmmmmmm...