How to Hide Data Columns Based on Report Selection

Hi,

I have a requirement where from the main menu a user can select "Summary" or "Detail". Detail has 2 more columns. The rest of the columns in those 2 reports are identical. I thought of using one query to retrieve all the data and then "Hide" the columns accordingly.

Example : Hide 'c6', 'c7' depending on what report is chosen

Summary Report

c1 c2 c3 c4 c5

Detail Report

c1 c2 c3 c4 c5 c6 c7

Your Help is much appreciated.

Thanks
Nurani Sivakumar

608-441-4408

Find more posts tagged with

Comments

mwilliams

Hi Nurani,

One was of doing it would be to set up a report parameter that had a different value based on whether the user chose the detail report or the summary report. Then you select the columns that you want hidden when summary is selected and choose to hide the element in the visibility section of the property editor. Then you would just use the expression builder to check the parameter value to decide whether to hide the columns or not.