I create report parameter vColumns(checkbox which includes all column names) for user selecting some columns. And I create "columns_all_tmp" temporary table in code to store all column names. Then I want to use dbr.hidecolumn filter columns that user doesn't choose as below.
select 'dbr.hidecolumn' union select Name from columns_all_tmp where Name not in (vColumns);
But it doesn't work and all columns are shown. Does anyone have any suggestions? Thanks a lot.