Passing Multi Value Parameters Through URL
Hi I am struggling with how to pass multi value parameters from one report to another using an action on a text box. I scanned through the previous posts I could find, but none of them appeared to cater for what I need (unless I am just not understanding them correctly). Report 1 is run using parameters that the front end user supplies (for example, Parameter 1 is one of a, b, c or d). The results the user gets in this report are displayed in charts. If the user wants to see a spreadsheet style breakdown of the information contained, I want them to be able to click on a text box which has a hyperlinked textbox that then runs another report containing the figures. Obviously when passing parameters, the equals sign in the string means that the value being passed has to be equal to a single value but I want to be able to pass a, b, and d or a, b and c, etc... Could anyone give me an example of how the url would look for a situation like this? I have read in places about using join and split statements but I think this is not directly in the url. How do I make the url handle more than one value for a single parameter? Thanks Matt
June 19th, 2012 9:18am

Ok, I found a solution! Here it is for anyone struggling with the same problem: ="http://servername/reportserver?/ReportFolder/ReportName&rs:Command=Render&ParameterName=" & JOIN(Parameters!ParameterName.Value, "&ParameterName=")
Free Windows Admin Tool Kit Click here and download it now
June 19th, 2012 11:48am

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

Other recent topics Other recent topics