Can I give an Userattribute to a report select statement?

[williamwhite]

Hello,

We are working with a a lot of departments. The business rules say that a user can only see the information of his own department. I can setup the structure with authorisation to see only certain reports. but that means that I have to make 300 reports doing the same thing and connect every report to a group in CE. This is hell to maintain.

I want to add an attribute to an user login like department and make just one report with in the select statement teh connection to the attribute. Is this possible?

I realise that it won't be sheduled reports. (I expect that CE cannot schedule reports with a unknown variable at a certain time) but want to use it for "live" reports.


Greetings,
Willie

 

[MJRBIM]

Does your Datasource have row-level security? If so, you could make the users login to the datasource when they view, and use the DB security to limit what they can see.

Otherwise, you can enforce folder and object security to publish your 300 reports, then use a 3rd Party tool like APOS ObjectManager to manage the parameters of all of your ReportObjects.

http://www.apos.on.ca/

 

[nikhilr]

What version of CE you are using. If you are using CE8.5 or above then you can use processing extensions which can provide you the finctionality you want.
By using processing extension you don't need to write same report number of times.

 

[williamwhite]

we have ce9.0. the database has no row level security. But will check the 3rd party tool.

I'll look into the processing extension, although I do not know quit what it is.

thx for the answers

 

[rhinok]

You can find out more information on Processing Extensions here:

http://support.crystaldecisions.com/library/kbase/articles/c2011766.asp

http://support.crystaldecisions.com/library/kbase/articles/c2012488.asp

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/ce9_processing_extension.zip.asp