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

Report - hide table based on value of another table

1 Answer 10 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Kristin
Top achievements
Rank 1
Kristin asked on 28 Jun 2018, 01:29 PM

Hi,

I am not sure that I have designed my report the most efficient way but that is another issue, I currently have a report that displays multiple different parameters from a database each displayed in their own table with their own sqldatasource.  This all works fine but like I say, I don't think this is the most efficient way.

 

My issue is, there is a requirement for one of the parameters to only be displayed depending on the value of another parameter in another table.  How would I go about doing this?

 

Any help/pointers in the right direction would be greatly appreciated.

 

Thanks

 

Kristin

1 Answer, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 03 Jul 2018, 08:25 AM
Hello Kristin,

You can use a Report Parameter, which AvailableValues are the possible values of the field you need to filter on, and then filter the DataSource of the corresponding Table based on this parameter.

Depending on the exact scenario, you can use also Cascading Parameters with applied filtering on Report level, or Cascading Parameters with applied filtering on data source level.

Regards,
Todor
Progress 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
Tags
General Discussions
Asked by
Kristin
Top achievements
Rank 1
Answers by
Todor
Telerik team
Share this question
or