Page Break: Report Page1(containing List, Cross tab & Chart)

having list, cross tab, chart reports on single page and when we run the report, need to show list,cross tab, chart on different pages (each page).

----First Create 3 Queries: ListQuery,CrosstabQuery,Repeater Query

ListQuery: ProductLine,ProductType,Qty,DataItem1 (Expression: ‘A’)

CrosstabQuery: ProductLine,ProductType,Qty,DataItem1 (Expression: ‘B’)

Repeater/chart Query: ProductLine,ProductType,Qty ,DataItem1 (Expression: ‘C’)

----Again create Queries: AQuery, BQuery, CQuery

AQuery: DataItem1 (Expression: ‘A’)

BQuery: DataItem1 (Expression: ‘B’)

CQuery: DataItem1 (Expression: ‘C’)

-----Now Union (AQuery, BQuery, CQuery) with Query Operation properties=select projection List Property as Manual; Now rename Union Query as ABCQuery

----Now Select Entire Page1- Set Query - ABCQuery

----Now Add  Page Set then add Page1 Under Detail Pages;Set  Query – ABCQuery;Grouping & Sorting place Data Item1 into Groups

----Select the List –Properties: Master Detail Relationships (DataItem1 to DataItem1); column Titles (At Start of first details on page); Remove No Data Contents

----Select the Crosstab –Properties: Master Detail Relationships (DataItem1 to DataItem1); Remove No Data Contents

----Select the Repeater –Properties: Master Detail Relationships (DataItem1 to DataItem1); Properties – check the DataItem1 finally Add chart into Repeater  container.

Or

Chart : Properties: Master Detail Relationships (DataItem1 to DataItem1)