Symptom
How to control values in the list of values for a parameter based on the user in Crystal Reports.
Environment
Crystal Reports 2008.
Resolution
This can be done in one of the below two ways using dynamic parameters:
- Security on the database server, where the values the user can see from the field, used for the dynamic parameter LOV are restricted by user.
- Using BOE with a managed LOV that is based on a Business View with row Level security based on user.
Keywords
Crystal,SSO,LOV. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
Product
Crystal Reports 2008 V1