Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 SSRS Passing User!Language into SP

Author  Topic 

FloatableCat
Starting Member

1 Post

Posted - 2010-11-18 : 12:12:42
Im attempting to convert an access database and reports etc to SQL reporting services reports, and having some trouble. I have made a stored procedure that will return the correct language text back from a table based on the current language the client pc is running.

I need to pass the User!Location global variable from SSRS into the SP, but im unsure how to do this.

I am trying to create a dataset that will be populated by this procedure, but for some reason I cant make it take the variables I need.

I think I'm probably doing something wrong here as my current experience with SSRS is about 2 days worth, but I cant see what.

Any help would be greatly apreciated.

Thanks
   

- Advertisement -