1839056 - How to control values in the list of values for a parameter based on the user in Crystal Reports.

SAP Knowledge Base Article - Public

1839056 - How to control values in the list of values for a parameter based on the user in Crystal Reports.

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:

  1. 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.
  2. 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 BusinessViews Manager , How To

Product

Crystal Reports 2008 V1