Post reply

Windows Authentication to Login to Reports

  • March 16, 2006 at 1:09 pm

    #189729

    I want to setup a report that multiple users will run but I only want to show the data for that paticular user viewing it. With out having them login again or provide some kind of UserID could I return data based on the current windows user login?

  • March 17, 2006 at 3:53 am

    #627229

    Yes, pass the Windows LoginId (User!UserId) to the query and then have that do the row level filtering.

  • March 17, 2006 at 9:53 am

    #627392

    You could also set up @userid as a parameter for the report and capture the users userid value (User!UserId) when he/she logs in initially.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply