Initial values of one parameter based on onther parameter in SSRS
Hi, In SSRS I have two parameter named: @UserName and @MyPersonnel I want to fill @MyPersonnel based on @UserName. @MyPersonnel is a dropdown parameter, whose values come from an sql stored procedure, that has a input parameter @username. I set the value of @username via "Current User Filter Webpart" in sharepoint. But, when I run the report, @MyPersonnel is empty. Can anybody help me solving this issue?
June 21st, 2012 7:00am

Did you try the User!UserID built in property in SSRS as explained in http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/199769c2-25c1-4077-9e64-bd95a16c8535 Regards / Irshad Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH
Free Windows Admin Tool Kit Click here and download it now
June 21st, 2012 7:43am

Did you try the User!UserID built in property in SSRS as explained in http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/199769c2-25c1-4077-9e64-bd95a16c8535 Regards / Irshad Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH
June 21st, 2012 7:49am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics