Parameter data set passing to another data set

[Phil]

Here is my scenario:

 I have a report with multiple parameters, 2 of which are not working properly.  One of these parameters is called 'ParentOrg' and will return a list of all organizations.  The other is called 'Org' which takes the parameter value from 'ParentOrg' and makes sure that the same value is not included in the drop down list.

ParentOrg = (1,2,3,4,5,6)   and Org = (1,2,3,4,5,6)

But, when the report renders and I have chosen ParentOrg = 3, the Org drop down should only show/allow Org = (1,2,4,5,6).

The report will render with default values, but when I try to change the ParentOrg, the report crashes.

Can someone point me in the right direction?

 Thanks,

Phillip

[Nasko]

Hello Phillip,

There are various options to set up cascading parameters. Two of them are described in detail in the following help articles:

• How to: Cascading Parameters with applied filtering on Report level
• How to: Cascading Parameters with applied filtering on data source level

Please review the provided how-to articles and compare the approaches to your parameters configuration. In order to give you suggestions related to your particular scenario, we will need to review how the parameters are configured in your report definition.

Regards,
Nasko
Telerik

[Phil]

Thanks Nasko.

Just to be sure:

Both Parameters use their own stored procedure.  Anytime that the 'ParentOrg' is changed, I want the procedure behind the 'Org' parameter to re-run (taking the new 'ParentOrg' value) and refresh the drop down list under the 'Org' parameter in report.

Is your suggestion still good for this?

Thanks,

Phillip

[Phil]

I actually just figured this out but filtering through my stored procedure.  

[Phil]

I actually just figured this out by filtering through my stored procedure.