Limiting the number of columns in Cross tab

[srinu1253]

Hi Gurus,

Suppose I have 10 columns in a crosstab.
I need 6 columns to be displayed on the first page and remaining columns in the second page.

Can we limit the number of columns in the cross tab.

[MFGF]

Maybe in a roundabout way.  If you select your crosstab object, there is a Pagination property for the crosstab, and in here you can allow horizontal pagination.  This means that if the crosstab extends past the right margin of the page when rendering as PDF, the remaining columns will be moved to the next page.  I'm willing to bet that if you use the Size & Overflow property of the first 6 columns to force them to be wide enough to fill the page width, the remaining 4 columns will then move to the next page.  You will need to be rendering specifically as PDF for this to happen, though.

Regards,

MF.

[srinu1253]

Is there any way limiting the number of columns based on the prompt selection.

ex I need a criteria if I select 5 Prompt values I need to display only 6 columns and remaining columns in the other page.

[blom0344]

Why not split the query and generate 2 seperate report pages? First query and crosstab on the first report page based on the prompt values and the second report page and crosstab based on those values that do not meet the prompt criteria..

[nagababu]

i think you can you use rendervaribale in value prompt and list column title select then apply the bullion condition that might be helpful..

[Universe]

Is there any way limiting the number of columns based on the prompt selection.

ex I need a criteria if I select 5 Prompt values I need to display only 6 columns and remaining columns in the other page.

Did you get an answer for this? I need to do similar thing. I want to add weekly data column till the end date prompt that I added for user to select. For example, if users selects Dec 26, 2019. excel output should have weekly column for every week till the week of Dec 26.

[Universe]

Solved. I used in_range function. Now I need to tell Cognos to use Monday to Sunday as a week instead of Sunday to Saturday.