<p>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. </p>
<p> </p>
<p>When I select PROGRAM A , it should pull COLUMN 1 to COLUMN 8. </p>
<p>When I select PROGRAM B, it should pull COLUMN 9 to COLUMN 15.</p>
<p>When I select PROGRAM C, it should pull COLUMN 16 to COLUMN 20.</p>
<p> </p>
<p>How do I design the report. I did a crosstab but 20 columns do not fit in it.</p>
<p> </p>
<p>ANY HELP IS HIGHLY APPRECIATED. </p>
<p> </p>
<p>Thanks</p>
<p> </p>
<p>Andy</p>
<p> </p>
