Report Parameter to have Dynamic Filter Column names

0 Answers 14 Views
Report Parameters Report Viewer - HTML5
Balaji
Top achievements
Rank 1
Veteran
Balaji asked on 04 Dec 2021, 02:10 PM | edited on 04 Dec 2021, 02:18 PM

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
Telerik team
commented on 08 Dec 2021, 03:51 PM

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

No answers yet. Maybe you can help?

Tags
Report Parameters Report Viewer - HTML5
Asked by
Balaji
Top achievements
Rank 1
Veteran
Share this question
or