Embedded
Schedule Free Demo
Try it Free
Search results
Suggest a FeaturePDF

Show the data based on user login using field level security

Find the following steps to show and obfuscate data based on the user.

  1. Create a dataset by getting the user id from the database as shown in the following image.

User id filtering

  1. Pass the default value for the user id parameter by referring to the following image and set the parameter visibility as hidden.

User id parameter

  1. Based on the user role, obfuscate the data by using the expression for the column as shown in the following image.

User id expression

  1. Preview the report with admin and guest user login to see the difference like the following images.

Preview of Admin user: User id admin Preview of Guest user: User id guest