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.
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQLPlease visit... ApplyBI