Parameter Dropdown Filling Issue

[Deepak Saboji]

Hello,

I have created a report with few parameters for filtering the report data. There is one parameter drop-down which needs to be filled as per choice made in the other parameter drop-down. For example, one drop-down is for 'Subject' and the other is for 'AreaOfSubject'. Now I want 'AreaOfSubject' to be filled as per the choice made in Subject drop-down. I am filling both the drop-downs with the business logic.

Would you please suggest the way it can be achieved?

Thanks and regards,

Deepak Saboji

[Peter]

Hi Deepak Saboji,

The ObjectDataSource Component can be used as a DataSource to populate with available data a Report Parameter. Check out How-To: Cascading Parameters with applied filtering on Report level help article it shows how to create a Cascading Parameters, just have in mind to create an ObjectDataSource instead of  SqlDataSource.

Best wishes,
Peter
the Telerik team

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 Public Issue Tracking system and vote to affect the priority of the items.

[Deepak Saboji]

Hi Peter,

Thanks for your reply. We've one more query regarding this functionality. The given solution works fine for filling 'AreaOfSubject' as per the choices made in 'Subject' dropdown by adding a filter expression to 'AreaofSubject' parameter.

Now, when we de-select all the subjects in 'Subject' dropdown (by unchecking '<select all>' checkbox), the filter gets fired for 'AreaOfSubject' but after post-back the Subject dropdown shows all the subjects selected in it, which is not desired.

Would you please guide us to achieve this behaviour?

Thanks and regards,
Deepak Saboji

[Steve]

Hi Deepak Saboji,

We were unable to reproduce the described behavior, so would appreciate if you open a support ticket and provide us with a sample that shows this behavior at hand. Once we review it we would be able to provide more info on the matter.

Kind regards,
Steve
the Telerik team

[Pratap]

Hi Deepak Saboji,

I also have the similar sort of issue while populating paramaters in dropdown.
One dropdown is dependent is another dropdown's selection.
The problem is, Im loosing the selection in child control and it always going back to the default selected item related to the selection of parent dropdown. Please help me if you got solution for this.

Thanks in advance.

Pratap.K

[Steve]

Hi Pratap,

The goal of cascading parameters is to show certain values in child parameter based on the selected value in the master parameter i.e. the behavior you describe is by design and that is why cascading parameters are also called dependent.
There are two ways to set-up cascading/depending parameters in Telerik Reporting, described in the following articles from the documentation:

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

Review them carefully, decide which is the best option for your case and follow the instructions.

All the best,
Steve
the Telerik team