Logon Screen

[BurnsORegan]

I wonder if this has been done.......

I am trying to pick up the user id of the person using a report to facilitate data selction (security). I have read that Crystal does not do this! (In this modern day!)

Therefore I am trying to create a Logon Screen to pop up prior to the report running to obtain the users ID? Is this possible without the use of a Plug In?

Hopefully someone has tried before or has a possible solution.

Regards

BurnsORegan

 

[MJRBIM]

Are you trying to do this within the Crystal Reports application, or via the web-interface (ePoertfolio) of Crystal Enterprise?

 

[rhinok]

This isn't so much a Crystal Reports issue as it is a database issue. You're trying to prevent users from accessing data they aren't supposed to see. That being said, you have a number of options:[ol][li]Create a Password Parameter in Crystal Reports and conditionally suppress sections of the report, based on Password - this is basically a kluge, but it creates the pop-up window you desire[/li][li]Implement Security on the Database and only allow users to run reports against data they have rights to see[/li][li]If you're using CR10 and CE10, then you can implement Business Views, which are represent a secure semantic layer of data - you can only see what you have rights to see.[/li][li]If you're using CE8 - CE10, then you can write a Processing Extension that passes the report scheduler's ID to the database, so that only those records to which the scheduler has rights are returned. This also requires that permissions be established on the database[/li][/ol] Hope this gives you a little more insight


~Kurt