GDene
asked on
In the URL to open a report. How do I pick up current userID to pass as parameter
I have created a link to a SQL report and passing a parameter that is hard coded.
The URL is working and the parameter is being passed successfully.
rs:Command=Render&username
Instead of hard coding the username I want the userID to be picked up automatically.
Then the link will work for any of my users.
The URL is working and the parameter is being passed successfully.
rs:Command=Render&username
Instead of hard coding the username I want the userID to be picked up automatically.
Then the link will work for any of my users.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hope you are passing it as a value in the text box instead of an Expression value, try passing it as an Expression value..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Initiating auto close as we haven't heard back from Author and the solution was suggested..
ASKER
User!UserID
I have tried putting it into [User!UserID]
but again it just puts that in as text into the parameter text box