locked
reportviewer RRS feed

  • Question

  • 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
    Saturday, August 6, 2011 7:31 PM

Answers

  • User1471008070 posted

    Hi,

    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 by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, August 9, 2011 11:03 PM