Crystal 9 - Limit Acess to Report with Parameter Password

[TheLibrary]

How can I install a parameter to prompt a user to type in a "password" in order to run the report?

Is there an easier way?

 

[Turkbear]

Hi, I suppose you could but can't the data source handle that aspect?
If it needs a username/password to access it, then let CR prompt for it..
Otherwise you could ( though I wouldn't) use a parameter and use a record selection formula like

(If {?parameter} = 'Correct' then
True
else
1 = 0)

This will return no Records if the parameter is not correct..( Not secure since it can be seen by anyone who can access the report with CR )
It will, however, read all the records in the data source regardless.

 

[synapsevampire]

Things like the version of Crystal, how reports are being run are crucial to this.

You can even have a PW on the database which prevents data access.

Your post gives no details, hence the potential solutions are many.

Try providing technical information:

Crystal version
Database used
What occurs if they do not know the password

-k