This is a migrated thread and some comments may be shown as answers.

Parameter data set passing to another data set

4 Answers 10 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Phil
Top achievements
Rank 1
Phil asked on 14 Jul 2015, 06:39 PM

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

4 Answers, 1 is accepted

Sort by
0
Nasko
Telerik team
answered on 15 Jul 2015, 07:29 AM
Hello Phillip,

There are various options to set up cascading parameters. Two of them are described in detail in the following help articles:
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Phil
Top achievements
Rank 1
answered on 15 Jul 2015, 01:49 PM

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

0
Phil
Top achievements
Rank 1
answered on 16 Jul 2015, 04:31 PM
I actually just figured this out but filtering through my stored procedure.  
0
Phil
Top achievements
Rank 1
answered on 16 Jul 2015, 04:32 PM
I actually just figured this out by filtering through my stored procedure.
Tags
General Discussions
Asked by
Phil
Top achievements
Rank 1
Answers by
Nasko
Telerik team
Phil
Top achievements
Rank 1
Share this question
or