Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: grouping Post Reply Post New Topic
Author Message
sandy
Groupie
Groupie


Joined: 10 Jan 2007
Location: United States
Online Status: Offline
Posts: 45
Quote sandy Replybullet Topic: grouping
    Posted: 27 Aug 2007 at 8:47am
I have a report that has 1 group header
when the group header is = to 1 I display the details
when the group header is > 1 I do not want the details but I want to be able to sum one of the fields and display that along with the descr
 
Ex:
GROUP header = 1
   .25   helping Sue with contacts      wo 97832
   .15   talked with John                     wo 97844
 
Group header = 6319
    (when the group order is > 1 this means that several wo's make up the project and I only want the total of the hrs spent on the project and the project desc)
    2.00   software updates                  gp 6319
    1.50   Server Cks                             gp 6320
 
I need help trying to figure out how to do the above or maybe the case is the report design is not correct to begin with.    Any suggestions??  Thanks in advance!!
 
 
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 27 Aug 2007 at 10:36am

To better understand what is the difference between a workorder number and a group header number? In your example one has GroupHeader 1 with workorder numbers, but the second has a GroupHeader 6319 with multiple groups underneath.  What makes group 6320 a part of the GroupHeader 6319?

Knowing this we might be in a better position to help.
 
Regards,
 
John W.
IP IP Logged
sandy
Groupie
Groupie


Joined: 10 Jan 2007
Location: United States
Online Status: Offline
Posts: 45
Quote sandy Replybullet Posted: 27 Aug 2007 at 10:43am
Actually, it prints like this
 
GP 6319
     hrs        desc
GP 6310
     hrs        desc
 
I want the report to be like this when it is done:
 
 hrs           desc                  wo#/GP#
xxx           xxxx                  70661 (this is a wo)
xxx           xxxx                  70662 (this is a wo)
xxx           xxxx                  6319   (this is a group project)
xxx           xxxx                  6320   (this is a group project
 
Behind each group project there are several work orders.  I don't want to show each Work order separately but instead want to total their hrs and show the group number they all have in common.
 
Hope that helps in explaining it.
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 28 Aug 2007 at 6:38pm
I have been thinking about your problem. If I understand correctly you want single work orders treated differently than a group of work orders. I will assume that when there is a group of work orders there is a group id field or something similar.  The basis for the assumption is there has to be a way to know multiple work orders belong to a group.  Then the question becomes when is a work order assigned to a group. Understanding that logic is needed to understand how to make a group.
 
It would be simple enough to create a count on that group id field so it would return the group order number if count is >1 or return the work order number if the count =1
 
You would then need to look to the design and there are several ways to approach the layout. What you end up with is what will meet your needs.
 
I think the key will be to use for example a GrpHdr1a and GrpHdr1b, then working out correct suppression issues.
 
Regards,
 
John W.
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.031 seconds.