nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Conditional Column Selecion

Siva Sandeep

Hi All,
 
 
Let me put in the scenario first and post the question after. I have this one main report which contains hyperlinks to other sub-reports. When clicked on the hyperlink, the sub-report is made to open up in excel format (using drill-through option).
 
The sub-report contains 46 columns. Now my question. Is there any way the user can first select the columns to be loaded? Suppose out of the 46 columns, the user wants only 12 columns. So when he clicks on the hyperlink, the user should be prompted to choose from the 46 fields.
 
The way I could think of is to open up the sub-report as a separate report and using the "Export data" option to select the fields. Is there any other way to implement this?
 
 
Thanks in advance

Find more posts tagged with

Comments

kclark

You could use a parameter for this. Create an integer parameter for the user to enter how many columns. Then using some script you could hide which columns need to be hidden. When they enter how many columns they want do you want them to tell you which columns are to be hidden or just start hiding from the first column forward?

Siva Sandeep

<blockquote class="ipsBlockquote" data-author="kclark" data-cid="130643" data-time="1410288618">
<div>
You could use a parameter for this. Create an integer parameter for the user to enter how many columns. Then using some script you could hide which columns need to be hidden. When they enter how many columns they want do you want them to tell you which columns are to be hidden or just start hiding from the first column forward?
</div>
</blockquote>
Hi Clark,
 
I was thinking something like the "Export Data" option in birt report tool viewer. When we click on "Export Data", there's a pop-up which lists all the columns available and then we manually select the columns which we need to be displayed/exported alone.

kclark

I'll write up an example for you, I think I'm going to use jQuery for this. I'll get the column names from the dataset and have an alert dialog with checkboxes to select what columns to be displayed.