Displaying only allowed Department Codes

building reports crystal reports
1

Hi,

I am attempting to build a crystal report with some level of security. At the moment, my report has several dynamic parameters which are populated directly off my SQL database. Specifically, one of the these parameters is the department code. At the moment, when running the report, all possible department codes are displayed and available for running the report.

I would like to limit the department codes that a user has access to. Specifically, when running this report in InfoView, I would like this crystal report, based on the logged in user name, only to display those department codes which the logged in user has the rights to. I currently have a SQL table with the user names and department codes that user name has access to.

I have been trying this a few ways and cannot seem to make it work. Any and all suggestions would be greatly appreciated.

Thanks,
Dave

davecorbino :us: (BOB member since 2008-07-22)

2

www.apos.com has a product called view time security that can do this.

tbrady (BOB member since 2007-09-25)