Friday, May 02, 2014

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)