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

Passing multi value parameter to subreport Expand / Collapse
Author
Message
Posted Thursday, October 10, 2013 6:38 PM
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
Hi Experts,

I have a parent and child report and i pass a multi value parameter to the child report from parent. Parameters in both reports are multivalued. It works. But only if all the parameter values exists in the child report parameter. But here both report gets parameter from two different databases so they don't have same values.
For Example :- Child report parameter may have values like : 1,2,3
while parent report parameter has values like : 1,2,3,4
So what happens is, when i pass these values from parent to child, as '4' is not present in child report nothing gets selected in child and the report doesn't run. On the other hand if i select only 1,2,3 and leave 4 out then it runs perfectly.


BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
Post #1503838
Posted Friday, October 11, 2013 7:03 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:35 AM
Points: 2,819, Visits: 2,563
I think you need to filter the values you are passing to the subreport to make sure you are not passing any invalid values.
Post #1503991
Posted Friday, October 11, 2013 5:30 PM
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
Daniel Bowlin (10/11/2013)
I think you need to filter the values you are passing to the subreport to make sure you are not passing any invalid values.


How can i do that ?
Any help is much appreciated. it's urgent

Thanks,
Amar


BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
Post #1504170
Posted Friday, October 11, 2013 5:47 PM
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
Solved that by MultiLookUp ssrs function. Thanks

BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
Post #1504173
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse