Show the data based on user login using field level security

To show or obfuscate data based on the user login in Bold Reports^®, pass the user ID to a hidden parameter and use an expression on the column that checks the user role. Follow these steps.

1. Create a dataset by getting the user id from the database.

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

3. Based on the user role, obfuscate the data by using an expression for the column.

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

Preview of Admin user: Preview of Guest user:

See also

• Get the user from database and pass the user as parameter for filtering the data
• Report parameters in the JavaScript Report Viewer