Show or hide tablix based on parameter

Question

The scenario is that there should be a dropdown parameter to select table name and when the user clicks on View report, he should see the data from that particular table.

Both the tables have different columns.

I tried creating different datasets for both tables and created two tablix and bound them to their respective datasets and put a condition for show/hide tablix based on expression.

But still I get error that the column(from other table) does not exist when a select a table.

I am new to SSRS, any help would be highly appreciated.

Strawberryshrub Strawberryshrub · Accepted Answer · 2018-10-15T08:30:03

Add a parameter to your report (TablixChosePara). With your different options:

=1  'Tablix1
=2  'Tablix2

Then add two tablixes to your report with two different columns or datasets. Then go to tablix properties and write the following expresson under 'Show or hide tablix based on expression'

=IIF(Parameters!TablixChosePara.Value = 1, True, False)

And fot the second tablix l:

=IIF(Parameters!TablixChosePara.Value = 2, True, False)

Show or hide tablix based on parameter

1 Answers