Page Break on Crosstab

[bloggerman]

Is it possible to page break in a crosstab

[kalyanapu]

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

[wendoze]

Thank you! Finally clear instructions that I was able to follow! - cheers  ;D