If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to create page break on crosstab

Started by ERJ_BGFI, 12 Mar 2007 05:05:15 AM

Previous topic - Next topic

ERJ_BGFI

Hello,
I explain to you my issue in Report Studio (C8 82).
I want to make a crosstab report with :
-   countries for columns;
-   product line for rows;
-   quantity for measure;
In the prompt page, I permit to choose the countries so the columns of the report.
I want only 4 countries (so 4 columns) by page for readability of the report.
In order to apply this strategy, I proceed to the following steps :
-   I create the column ââ,¬Å"PageIDââ,¬Â by counting distinct countries in my query ââ,¬Å"Queryââ,¬Â ;
-   I create a page set based on ââ,¬Å"Queryââ,¬Â with grouping on ââ,¬Å"PageIDââ,¬Â

But after numerous tries, I couldnââ,¬â,,¢t find the right way.

Thank you by advance for your answers.

Eric