User-1228906271 posted
I have a reporting services report with several parameters. Including one parameter that holds user names I also have a aspx page that allows users to login in. The login.aspx uses an sql database with users and passwords. Once the user logs in I need them
to be able to view the report and ensure they only see their information. To view the report I have a reportviewer control. What is the best way to ensure the reportviewer only shows the logged in user information. I need to ensure the existing parameters
in the report also still work
Since there is a parameter hold user name, I think you can make use of this parameter in T-SQL to only return the records belong to every special user. Then every user can only see his information.
Thanks,
challen Fu
Marked as answer byAnonymousThursday, October 7, 2021 12:00 AM
