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; } } }

Pull Columns based on Filter

royaditya

All, Need a help i designing the report. We have a table with 20 columns in it. 20th column is PRODUCT_TYPE which has PRODUCT A , PRODUCT B, PRODUCT C and it is a report parameter. 
 
When I select PROGRAM A , it should pull COLUMN 1 to COLUMN 8. 
When I select PROGRAM B, it should pull COLUMN 9 to COLUMN 15.
When I select PROGRAM C, it should pull COLUMN 16 to COLUMN 20.
 
How do I design the report. I did a crosstab but 20 columns do not fit in it.
 
ANY HELP IS HIGHLY APPRECIATED. 
 
Thanks
 
Andy

Find more posts tagged with

Comments

micajblock

One simple option would be to have 3 data sets and 3 tables. Based on the parameter you drop the tables in the beforeFactory of the report. If the table is dropped the data set will not be executed. Simple example here - <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/1069-simple-example-of-dropping-a-tablechart/'>http://developer.actuate.com/community/forum/index.php?/files/file/1069-simple-example-of-dropping-a-tablechart/</a>

royaditya

Thanks Mica. Appreciate your help. One more question. So there would be one report right? its a crosstab one and having so many columns do not fit in one page.

micajblock

Yes, one report. I am not clear on what your required output is. Can you be more specific?