Author Topic: Page Break: Report Page1(containing List, Cross tab & Chart)  (Read 58 times)

0 Members and 1 Guest are viewing this topic.

Offline MrSpecialist

  • Sr. Member
  • *
  • Posts: 342
  • Karma: +1/-0
  • I'm an expert!
    • View Profile
Page Break: Report Page1(containing List, Cross tab & Chart)
« on: December 14, 2016, 10:37:44 AM »
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)

Techronnati | where technology never sleeps

Page Break: Report Page1(containing List, Cross tab & Chart)
« on: December 14, 2016, 10:37:44 AM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
944 Views
Last post November 27, 2008, 02:13:40 AM
by MrSpecialist
0 Replies
69 Views
Last post April 02, 2009, 05:43:44 AM
by MrSpecialist
0 Replies
65 Views
Last post April 02, 2009, 06:31:00 AM
by CyborgRepublic
0 Replies
60 Views
Last post December 14, 2016, 10:13:40 AM
by MrSpecialist
0 Replies
54 Views
Last post December 14, 2016, 10:15:08 AM
by MrSpecialist

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.