Hide Column using selected Parameter(filter)

[Yogi]

I want to hide table column according to the selected parameter(filter). How I can implement this using ​Telerik ​Report Designer 

[Stef]

Hi Yogi,

You can apply a filter for the data visualized by a column group. For more details check my post in hide a table column.

Regards,
Stef
Telerik

[Yogi]

 I went through your link "hide a table column". But Can you please elaborate step by step how to implement this. I have a columns like Retailer, Product ID, Product Description, Delivery Date. I built ColumnInfo parameter which is holding column names with its ID. If user select Retailer and product description in the filter then I only want to show Retailer and Product Description. Currently I dont have any grouping on these columns. Please any help will be appreciated.

[Stef]

Hello Yogi,

Based on your description, there is a multivalue report parameter which determines which columns to be visible. Multivalue parameters are evaluated as arrays of objects, thus you can build a filter expression checking if the name of the column is IN (like the IN operator) the selected parameters values.

The attached video and TRDX file illustrate the suggestion. The report (TRDX file) can be previewed with the Standalone Report Designer of Telerik Reporting Q2 2015 SP1 v9.1.15.731.

Regards,
Stef
Telerik