Hi, I am painfully new to SSRS and have an assignment to create a report that will render based on the userID; I have the report built and the stored procedure that brings in all of the necessary data, etc. I added a text box to my report that pulls the USERID as an expression from the Global Variables.
But, what do I do with it? How will the report identify the user.. I'm assuming I need to add @UserID param to my stored procedure, but I am quite lost.. (mind not completely here this morning, if you know what I mean...)
I'm using SQL Server 2005 - the report will ultimately render in MOSS 2007..