How to “Display a list for each country on separate pageâ€
In a list report we have country, product line and gross profit. We want to show data (product line, gross profit) for each country on separate page.
This is Cognos 8.1 Version.
Using PAGE SET as mentioned in report studio guide I was not able to do this. The report still is showing multiple countries in single page.
Let me know the steps if anybody had done this ASAP.
Regards
How to “Display a list for each country on separate pageâ€
In a list report we have country, product line and gross profit. We want to show data (product line, gross profit) for each country on separate page.
This is Cognos 8.1 Version.
Using PAGE SET as mentioned in report studio guide I was not able to do this. The report still is showing multiple countries in single page.
Let me know the steps if anybody had done this ASAP.
Hi,
Select Country data item -> Group it -> Make it as Section header
Include Page Set into Report Pages -> Drag Page into Detail Pages
Select Page Set -> In Properties under Query Property -> Select the Query which contains Country data item
Select Grouping & Sorting Property
Drag Country from the Data items list into the Groups Folder
Select Country under Groups folder -> Select Properties -> Check Country data item
Ok and Run the report.
Hey thanks.
i miss out when " you have to drag page1 into detail page of Page set "
Now it is working
issue resolved