Data Segregation / Security

[PositiveParrot]

We are still relatively new to this product and have built some Crystal Reports based on a company hierarchy.

Are there any facilities to segregate the data so that e.g. some users can see only data from their part of the hierarchy?

Or do we have to build separate databases / reports for each part of the company we need to segregate?

We are on version 7.0.2. but are due to upgrade to version 10 soon.

Any help would be much appreciated.

PP

 

[pgtek]

Hi
if you have a dabase and a table that contains the user and his hierarchy then it's easy.

Just import this table and in your format section on the report suppres x2 tab just insert your filter there
ex:

if
{UserName} = "Jeo" and {hierarchy} = "Boss" then false

so Joe will see that section else the other will not

cheers



pgtek

 

[PositiveParrot]

pgtek,

Thanks for the reply. How does Crystal Reports know who's viewing the report? Does it take the username on log in and store it somewhere where it can be referenced?

Regards,

PP