Author |
Message |
PaulyWally
Newbie
Joined: 16 Aug 2013
Location: United States
Online Status: Offline
Posts: 12
|
Topic: Summary Page in Report Header? Posted: 07 Apr 2014 at 5:44am |
I'm wondering if anyone knows a way to put a summary page in the report header. (It doesn't even have to technically be in the 'Report Header'. I would just like it to be located first on report printout.) I've tried a few things, with no luck so far.
I have a basic tabular report with 1 grouping. The fields used in the report are "FirstName", "LastName", "PhoneNumber", and "Department". The grouping is on "Department". So the details of the report printout look something like this:
Human Resources:
John Candy 555-123-4567
Charlie Chaplin 555-123-4567
Chevy Chase 555-123-4567
George Clooney 555-123-4567
Information Systems:
Albert Brooks 555-123-4567
Carl Elwes 555-123-4567
Development:
Judi Dench 555-123-4567
Al Pacino 555-123-4567
Paul Newman 555-123-4567
What I would like to do, is include a summary on the first page(s) that would look something like this:
Human Resources Total Employees: 4
Information Systems Total Employees: 2
Development Total Employees: 3
The catch is, it needs to handle the data dynamically. There is no telling the names of the Departments (or number of employees) until report runtime.
Any thoughts? TIA!
|
IP Logged |
|
praveeng
Senior Member
Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
|
Posted: 07 Apr 2014 at 6:32am |
Hi, To achieve your requirement, You have to use Sub report and place it in Report header. Create a formula as below and place it in Group Header Count({Emp_name},Department) and suppress the Details and Group footer section. --Praveen G
|
Praveen Guntuka,
praveen_guntuka@yahoo.com
|
IP Logged |
|
PaulyWally
Newbie
Joined: 16 Aug 2013
Location: United States
Online Status: Offline
Posts: 12
|
Posted: 07 Apr 2014 at 8:48am |
Originally posted by praveeng
Hi, To achieve your requirement, You have to use Sub report and place it in Report header. Create a formula as below and place it in Group Header Count({Emp_name},Department) and suppress the Details and Group footer section. --Praveen G
The trouble I am having with this, is getting the full set of records into the subreport. I am sure I can do this by re-querying the database within the subreport, but I would rather not.
Is it possible to pass a full set of records from the main report to the subreport?
|
IP Logged |
|
kevlray
Admin Group
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
|
Posted: 07 Apr 2014 at 12:09pm |
No, the idea is to query or re-query a database. I have had to put a summarized header in a report. The sub-report route was the only way to achieve it.
|
IP Logged |
|
praveeng
Senior Member
Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
|
Posted: 08 Apr 2014 at 2:17am |
Yes.. As suggested by Kevlray... Sub report is the only way to achieve your requirement. --Praveen G
|
Praveen Guntuka,
praveen_guntuka@yahoo.com
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 08 Apr 2014 at 4:03am |
I believe you can use a crosstab in the report header to display the data as you want and you do not need a sub report
|
IP Logged |
|
kevlray
Admin Group
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
|
Posted: 08 Apr 2014 at 4:28am |
I did not think of a crosstab (don't get to use them much).
|
IP Logged |
|
lockwelle
Moderator
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
|
Posted: 08 Apr 2014 at 4:55am |
DBlank always comes up with the cross-tab option...I remember them in group footers, didn't think about it in the group header.
I also do not use cross-tabs very often.
|
IP Logged |
|
|