Report Parameter to have Dynamic Filter Column names

[Balaji]

Hi,

How can I pass Column names via Report Parameters to Filter the records in a table?

The report has 5 columns. I need to filter the table based on a Column. This column needs to be passed to the report dynamically from a screen.

I can pass the filter value via the Report parameter and successfully filter a Column. But my requirement is the Column (Field) that will be used is not known prior and needs to be passed into the report via Report Parameter. The column names are dynamic.

I am using Expression in Filters, but am not able to make this happen.

Please advice.

Thanks,
Balaji. V

[Neli]

Hi Balaji,

You may set the ConditionalFormatting property to set the visibility of a specific column based on a report parameter. I am afraid that you cannot use the Filtering property of the table to remove columns. 

If you need to create the tables dynamically, I would recommend checking the following resources:

- How to Create a Dynamic Table/Crosstab/List item (contains a sample report)

- How to add multiple tables dynamically based on the data source (contains a sample report)

- How to modify table with preset styles and width dynamically