Am new to SQL Reporting and need to add a parametrer to a .rdl which allows only the valid users to see the reports and not see everyone else in that report. The report dumps all the data for all the users but we want the logged in user to see only his/her report. We have the folder structure as follows
"Agents" with Content Browser permissions to the Staff group from the domain
I want to be able to put a report in it and then include the needed parameters for filtering based on login. I am using BI Studio for doing this. Some of the other reports that the DBA did had the following settings under parameters:
Data Type: String
Has Default: Checked (in box)
Prompt user: grayed out
How do I incorporate this in future reports? TIA.