Get the user from database and pass the user as parameter for filtering the data from database

To filter report data by user in Bold Reports^®, create a dataset that gets the user ID from the database, pass that ID as a parameter value, and filter a second dataset by the parameter. Follow these steps.

1. Create a dataset that gets the user id from the database.

2. Pass the user id field value from the dataset to the parameter available value.

3. Create a new dataset that filters the data based on the parameter.

See also

• Show the data based on user login using field level security
• Report parameters in the JavaScript Report Viewer