Report - hide table based on value of another table

[Kristin]

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

[Todor]

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