passing multiple value from chart to another report

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » passing multiple value from chart to another...

passing multiple value from chart to another report

Rate Topic

Display Mode

Topic Options

Author

Message

jbon007

Posted Friday, February 18, 2011 2:55 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, December 04, 2012 11:52 AM
Points: 26, Visits: 80

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?

Post #1066230

gsc_dba

Posted Tuesday, February 22, 2011 9:37 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 6:48 AM
Points: 1,065, Visits: 1,328

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

Post #1067689

jbon007

Posted Tuesday, February 22, 2011 10:17 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, December 04, 2012 11:52 AM
Points: 26, Visits: 80

i just used in the actions [@FinYear] or [@FinMonth]etc and this worked for multivalue

Post #1067724

cleonard 54659

Posted Tuesday, December 04, 2012 10:07 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 06, 2013 2:21 PM
Points: 3, Visits: 39

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....

Post #1392600

« Prev Topic | Next Topic »

Permissions