Dynamic Parameter needs credentials

[sam85]

Hi,

I have a question. I have a report and I'd like to bind a dynamic parameter as a filter. So far so good, but when the reports is printed I get the DataBase prompt to sign in with credentials. The user does not have those credentials, the ERP is passing this while printing, but apparently not for the dynamic parameter, just for the report. Is there anyway to fix this or workaround?

Glad for any answers.

Kind regards

Samuel

[DonWilliams]

You are correct...

For Crystal to display the list of values it needs to connect to the DB to populate the dialog box with the values to select from.

CR fully supports Database security, you don't want to give access to sensitive data if the user doesn't have rights to see the data.

Talk to the ERP developers for work arounds by possibly creating a User group with permissions to access that data in the DB.