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