Database Password/login prompt when adding dynamic parameter to raport with command as source

[Former Member]

Hi. From two weeks, i'm tryin to resolve this :

i need to create report which gets data with command (because only command can get parameter in the source).

After that i'm creating dynamic parameters to filter the results.

And everytime I add dynamic parameter the report asks for username and password for database (without dynamic parameter it does not asks)

I've tried with the newest version of Crystal Reports 2016 sp4, and the problem still exists.

What can i do to overcome this ?

Connection is Microsoft ole db For SQL Server.

[abhilash_kumar]

Hi Boleslaw,

Do you get prompted for a UserName/Pass in the CR Designer or the BI Platform?

Is the source for the dynamic prompt same as the database/source for the data on the report?

-Abhilash