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