Post reply

Using Client Login as a Parameter

  • March 16, 2016 at 4:25 am

    #312111

    I'm using SSRS to try to build a report in 2008 R2 where I need to use the Client (PC) login ID of the person running the report as the parameter. I've tried using all the normal options of SYSTEM_USER, SUSER_NAME, ORIGINAL_Login and they work fine when run locally. However, when the report is selected from the Web Page that connects to the server it always return the Datasource login not the client. Is there a way of picking up the Client Login details when the report is run and passing them to the report as a parameter? Thanks in advance.

  • March 16, 2016 at 5:32 am

    #1865559

    only if you change the datasource to use their AD credentials, instead of the cached username/password.

    In that case, the end users most likely don't have permissions to query the data in the first place, so you have to add an AD group as a login and then as a user to the source(i say AD group to avoid adding ten individual logins for the other folks who call the same report)

    so you want to choose the first selection instead of the explicit credentials like in this image.

    "Use current Windows user, Kerberos deligation might be required"

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 16, 2016 at 6:16 am

    #1865572

    Hi thank you. I'll go down that route.

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

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