Is it possible to page break in a crosstab
yes,we can.
Steps:
Create the following report using Go Sales (analysis):
1) Create a nested Crosstab report.
2) In Sales (analysis) / Product / Product add Product Line, Product Type and Product as rows, in Sales (analysis) / Time dimension / Time Dimension add Year as column and finally add Quantity as measures
3) Go to Page Explorer and select Report Pages.
4) Add a Page Set.
5 Set the Page Set Query property to the crosstab query.
6) Open the Page Set Grouping & Sorting property.
7) Add the grouped Query item (here Product Line) to the Grouping folder in the left pane and click OK.
8) Back in Report Pages, drag the original page (default Page1) to the Detail Pages folder.
9) Go to Page Explorer and select Page1
10) Select Product Line column and click on Section icon to create a Product Line section
11) Run the report and you will see the page break done on each Product Line.
-
Srinivas kalyanapu
Thank you! Finally clear instructions that I was able to follow! - cheers ;D