Skip to Content

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

Nov 15, 2017 at 04:56 PM


avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Nov 15, 2017 at 05:26 PM

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?


10 |10000 characters needed characters left characters exceeded