Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Summary Page in Report Header? Post Reply Post New Topic
Author Message
PaulyWally
Newbie
Newbie


Joined: 16 Aug 2013
Location: United States
Online Status: Offline
Posts: 12
Quote PaulyWally Replybullet 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 IP Logged
praveeng
Senior Member
Senior Member
Avatar

Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
Quote praveeng Replybullet 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 IP Logged
PaulyWally
Newbie
Newbie


Joined: 16 Aug 2013
Location: United States
Online Status: Offline
Posts: 12
Quote PaulyWally Replybullet 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 IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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 IP Logged
praveeng
Senior Member
Senior Member
Avatar

Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
Quote praveeng Replybullet 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 IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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 IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 08 Apr 2014 at 4:28am
I did not think of a crosstab (don't get to use them much).
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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 IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.