Show the data based on user login using field level security
Find the following steps to show and obfuscate data based on the user.
- Create a dataset by getting the user id from the database as shown in the following image.
![User id filtering](/embedded-reporting/assets/javascript-reporting/report-viewer/images/how-to/user-id-parameter/user-id-filter.png)
- 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](/embedded-reporting/assets/javascript-reporting/report-viewer/images/how-to/user-id-parameter/user-id-parameter-expression.png)
- Based on the user role, obfuscate the data by using the expression for the column as shown in the following image.
![User id expression](/embedded-reporting/assets/javascript-reporting/report-viewer/images/how-to/user-id-parameter/user-id-expression.png)
- 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:
![User id guest](/embedded-reporting/assets/javascript-reporting/report-viewer/images/how-to/user-id-parameter/user-id-guest.png)