Limit Parameters based on Log-in 1

[dky1e]

I am using CE 9 and I would like to automatically pass in parameters to a report based on the curent user's log-in. For example, if I have person 'A' logged in, I want to show data for person 'A' only. Is it possible?

Thanks.

 

[Turkbear]

Hi,
You can write a custom page using code ( csp/asp/javascript) to pre-process the query before sending it - ( either by assigning the limiting criteria to a parameter field in the report or by using the sf or gf options in the URL )..

You can also, I have been told, write a processing extension to do this so that even when run from ePortfolio
it would apply the additional criteria..

 

[dky1e]

Can I modify the csp pages used by crystal?

 

[Turkbear]

Hi,
Yes, but you probably would be better off writing your own, based on theirs...
I find it best to leave the Crystal designed ones alone ( so that ePortfolio/CCM continue to work as I expect ( there are lots of include files involved in those pages and knowing what and where to modify them is not easy)

For instance,you could create a login page that , based on the ID, sets some kind of variable that can be passed to the report - in the report use the value of that variable to determine the selection criteria...

 

[rhinok]

Processing extensions can be used to create row-level security within a report.

Check out the following link:

http://support.crystaldecisions.com/communityCS/TechnicalPapers/ce85_processing_extensions.zip.asp

The zip file also includes a wizard for creating processing extensions.

 

[dky1e]

Cool! Thanks a lot.

(I'm new to this) How do I "plug-in" my csp's to the crystal enterprise?