February 18, 2011 at 2:55 am
Hi all,
I have SSRS 2008 and currently done a report that shows Length of Stay. X axis shows the months and y axis show the LOS.
my report parameters are the @FinYear, @FinMonth and @Site
When i fill these parameters and use as multivalue it works perfectly and is straight forward. However when i set action so that when i click on the bar chart for paticular month e.g August i have told it go to another report and show me the detail of this. The problem is that the @site parameter when passing this to another report it only selects the first value?
Any solution to this? basically my question is how do i pass a multivalue to another report?
February 22, 2011 at 9:37 am
On the action (go to report) part in SSRS, when selecting the parameters - choose expression and try:
=Split(Parameters!YourParameter.Value, ",")
This works for me for drill through reporting with MDX
gsc_dba
February 22, 2011 at 10:17 am
i just used in the actions [@FinYear] or [@FinMonth]etc and this worked for multivalue
December 4, 2012 at 10:07 am
Hi, I've done as you instructed, but when the drill through report opens, my parameter, for which I just did a split function on in the previous report, does not populate and just appears at the top waiting for the data to be selected manually. If the user then manually chooses values and runs the report, it runs fine but won't autofill from the previous drill through.
I have the parameter set up as a multi-value, binded in the query with the join function.
Help....
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply