Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Inherit Multi Value Parameter Expand / Collapse
Author
Message
Posted Friday, October 12, 2012 4:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:56 AM
Points: 178, Visits: 668

Hi geniuses!

I have 3 reports:
Report1 with 2 tablix in it (tablix1 and tablix2). These tablix are quite small, and the info can't really be analysed (unless the user uses 2 parameters)
Report2 with tablix1. And here all the data can be analysed.
Report3 with tablix2. All good here! :)

In my Report1 I've created 2 buttons, linking to Report2 and Report3.

When the user choose to see Report2 or Report3, both based on the same parameters in Report1, I want both to inherit the values from both parameters from Report1.
The multi value parameter doesn't inherit the values.

Any solution?
Thanks
Best Regards.
Post #1372019
Posted Friday, October 12, 2012 5:26 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 7, 2014 2:21 PM
Points: 132, Visits: 557
You can check this

And also this


BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
Post #1372035
Posted Friday, October 12, 2012 6:51 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:56 AM
Points: 178, Visits: 668

Doesn't work for me.
Do you have another example?
Post #1372085
Posted Monday, October 15, 2012 3:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:56 AM
Points: 178, Visits: 668
No need to do =SPLIT(JOIN..., in SSRS 2008
It can be done in the properties, in the action section. Just add the parameters.
The problem that can show up, is when any parameter is a multivalue parameter.
When you select a multi value the parameter, the expression is: Parameters!ParameterName.Value(0)
All I had to do was to remove '(0)' from the expression.

Post #1372616
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse