Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to make total count when change of value of fields in crystal?

Status
Not open for further replies.

mitchikoy15

IS-IT--Management
May 24, 2011
7
PH
I am having problem in making total f values in my crystal report.

The sample table rows:
EmployeeCode Name Position Project
0001 Mitch Analyst WEB
0002 Ronald Programmer Windows
0003 Harold Developer WEB
0004 Bensyl Programmer WEB
0005 Jeff Designer Windows
0006 Mark Developer Windows
0007 Jon Analyst Linux

EmployeeCode - unique

Desired Output:
Page header -> EmployeeCode Name Position
(Project)WEB
0001 Mitch Analyst
0003 Harold Developer
0004 Bensyl Programmer
TOTAL 03

Windows
0002 Ronald Programmer
0005 Jeff Designer
0006 Mark Developer
TOTAL 03

Linux
0007 Jon Analyst
TOTAL 01

Report Footer ----> GRAND TOTAL 07
(The grand total will be the count of all rows. I know how to use this in running total)

Please help me with this. Thank You in Advance. =))God bless Us.

 
Group on project, and then right click on the EmployeeCode field->insert summary->count-> choose the group level and then do it a second time, choosing the grand total level.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top