Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Complex grouping by field Post Reply Post New Topic
Author Message
jfrageme02
Newbie
Newbie
Avatar

Joined: 24 Aug 2012
Location: Honduras
Online Status: Offline
Posts: 2
Quote jfrageme02 Replybullet Topic: Complex grouping by field
     Posted: 24 Aug 2012 at 10:08am
Hi everyone,

This it’s my first post on this forum and need some help with a report that I´ve been working like a month...

This it’s the problem:

I have this report,
                    
Col 0     col 1     Analist             Timestamp                    Analist group
Grupo col 1001
Desc 1     1001     Analist 1     06/08/2012 02:29:11p.m.     1
Desc 2     1001     Analist 2     06/08/2012 02:29:11p.m.     2
Desc 3     1001     Analist 3     06/08/2012 02:29:11p.m.     2
Desc 4     1001     Analist 4     06/08/2012 02:29:11p.m.     3
Desc 1     1001     Analist 1     06/08/2012 02:29:11p.m.     4
Desc 2     1001     Analist 2     06/08/2012 02:29:11p.m.     2
Desc 3     1001     Analist 3     06/08/2012 02:29:11p.m.     2
Desc 4     1001     Analist 4     06/08/2012 02:29:11p.m.     4

Grupo col 1002
Desc 1     1002     Analist 1     06/08/2012 02:29:11p.m.     1
Desc 2     1002     Analist 2     06/08/2012 02:29:11p.m.     2
Desc 3     1002     Analist 3     06/08/2012 02:29:11p.m.     4
Desc 4     1002     Analist 4     06/08/2012 02:29:11p.m.     4
Desc 1     1001     Analist 1     06/08/2012 02:29:11p.m.     1
Desc 2     1001     Analist 2     06/08/2012 02:29:11p.m.     2
Desc 3     1001     Analist 3     06/08/2012 02:29:11p.m.     4
Desc 4     1001     Analist 4     06/08/2012 02:29:11p.m.     4


And I want to group by the column Analist group with the option that can be repeated and listed in the order that their appear in the list

Col 0     col 1     Analist             Timestamp                    Analist group
Grupo col 1001
Grupo Analist group 1
Desc 1     1001     Analist 1     06/08/2012 02:29:11p.m.     1
Grupo Analist group 2
Desc 2     1001     Analist 2     06/08/2012 02:29:11p.m.     2
Desc 3     1001     Analist 3     06/08/2012 02:29:11p.m.     2
Grupo Analist group 3
Desc 4     1001     Analist 4     06/08/2012 02:29:11p.m.     3
Grupo Analist group 4
Desc 1     1001     Analist 1     06/08/2012 02:29:11p.m.     4
Grupo Analist group 2
Desc 2     1001     Analist 2     06/08/2012 02:29:11p.m.     2
Desc 3     1001     Analist 3     06/08/2012 02:29:11p.m.     2
Grupo Analist group 4
Desc 4     1001     Analist 4     06/08/2012 02:29:11p.m.     4

Grupo col 1002
Grupo Analist group 1
Desc 1     1002     Analist 1     06/08/2012 02:29:11p.m.     1
Grupo Analist group 2
Desc 2     1002     Analist 2     06/08/2012 02:29:11p.m.     2
Grupo Analist group 4
Desc 3     1002     Analist 3     06/08/2012 02:29:11p.m.     4
Desc 4     1002     Analist 4     06/08/2012 02:29:11p.m.     4
Grupo Analist group 1
Desc 1     1001     Analist 1     06/08/2012 02:29:11p.m.     1
Grupo Analist group 2
Desc 2     1001     Analist 2     06/08/2012 02:29:11p.m.     2
Grupo Analist group 4
Desc 3     1001     Analist 3     06/08/2012 02:29:11p.m.     4
Desc 4     1001     Analist 4     06/08/2012 02:29:11p.m.     4


There is a column that goes in the final that is the time spent in every task, this fields its return it from the DB so that no a problem. I need to summarize for every group to know how much this group take in every steps.

I’ll be appreciating the help.

Thanks
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 24 Aug 2012 at 11:33am

based on the data you have shown I do not see a way to group on it. You can mimic a group by inserting a detail a that is conditionally suppressed using the next() or previous() functions
IP IP Logged
DaBoujibo
Newbie
Newbie


Joined: 21 Feb 2012
Online Status: Offline
Posts: 28
Quote DaBoujibo Replybullet Posted: 24 Aug 2012 at 12:12pm

Hi, jfrageme02.

 
First, this is in addtion to what DBlank already posted.  I just wanted to let you know that the way you want grouping to work is not the purpose of grouping.  Grouping is inherently grouping all like items in the selected field.  However, you can use a formula to create a custom grouping field to combine multiple fields to help group on multiple "fields" at the same time rather than 1 field and then another.  I have created a sample table without grouping, then grouped with a single field, and then grouped with a custom grouping field, so you can see the result of doing so. (I used some of your data as a basis.)
 
Second, why do you need to keep the analyst group in order of their appearance?  I'm confused by that requirement.  It negates the benefit of having grouping at all.
 

TABLE WITH NO GROUPING

DESC     DEPT     ANALYST     GROUP     LOCATION
Desc1     1001           1                  1                 NE
Desc2     1001           1                  2                 SE
Desc3     1001           1                  3                 SW
Desc4     1001           1                  4                 NW
Desc5     1001           1                  1                 SW
Desc6     1001           1                  2                 SW
Desc7     1001           1                  3                 NW
Desc8     1001           1                  4                 N
Desc1     1001           2                  1                 S
Desc2     1001           2                  2                 NE
Desc3     1001           2                  3                 SE
Desc4     1001           2                  4                 SW
Desc5     1001           2                  1                 NW
Desc6     1001           2                  2                 SW
Desc7     1001           2                  3                 SW
Desc8     1001           2                  4                 NW

 
TABLE GROUPED BY "GROUP" COLUMN

DESC     DEPT     ANALYST     GROUP     LOCATION
GROUP 1
Desc1     1001           1                  1                 NE
Desc5     1001           1                  1                 SW
Desc5     1001           2                  1                 NW
Desc1     1001           2                  1                 S
GROUP 2
Desc2     1001           1                  2                 SE
Desc6     1001           1                  2                 SW
Desc2     1001           2                  2                 NE
Desc6     1001           2                  2                 SW
GROUP 3
Desc3     1001           1                  3                 SW
Desc7     1001           1                  3                 NW
Desc3     1001           2                  3                 SE
Desc7     1001           2                  3                 SW
GROUP 4
Desc4     1001           1                  4                 NW
Desc8     1001           1                  4                 N
Desc4     1001           2                  4                 SW
Desc8     1001           2                  4                 NW

 
TABLE GROUPED BY "@CustomGroup"
1. Create a custom grouping field called "@CustomGroup" using "GROUP" & "LOCATION"
2. Used the new field as my group field
3. Then used a custom group name to change the group name to be more meaningful.

DESC     DEPT     ANALYST     GROUP     LOCATION
GROUP 1 LOCATION NE
Desc1     1001           1                  1                 NE
GROUP 1 LOCATION NW
Desc5     1001           2                  1                 NW
GROUP 1 LOCATION S
Desc1     1001           2                  1                 S
GROUP 1 LOCATION SW
Desc5     1001           1                  1                 SW
GROUP 2 LOCATION NE
Desc2     1001           2                  2                 NE
GROUP 2 LOCATION SE
Desc2     1001           1                  2                 SE
GROUP 2 LOCATION SW
Desc6     1001           1                  2                 SW
Desc6     1001           2                  2                 SW
GROUP 3 LOCATION NW
Desc7     1001           1                  3                 NW
GROUP 3 LOCATION SE
Desc3     1001           2                  3                 SE
GROUP 3 LOCATION SW
Desc3     1001           1                  3                 SW
Desc7     1001           2                  3                 SW
GROUP 4  LOCATION N
Desc8     1001           1                  4                 N
GROUP 4  LOCATION NW
Desc4     1001           1                  4                 NW
Desc8     1001           2                  4                 NW
GROUP 4  LOCATION SW
Desc4     1001           2                  4                 SW



Edited by DaBoujibo - 24 Aug 2012 at 12:13pm
IP IP Logged
jfrageme02
Newbie
Newbie
Avatar

Joined: 24 Aug 2012
Location: Honduras
Online Status: Offline
Posts: 2
Quote jfrageme02 Replybullet Posted: 24 Aug 2012 at 1:02pm
Thanks for the fast reply,

Maybe with the next image you can have a more clear idea what I want to do:



Sorry for the confusion, with "appearance" I refer the way that they are printed or listed in the report.

The time elapsed is the time that took from one group (Group A), to work in that problem. If then come another group (Group B) and work in that problem then the time that took it in the problem will be listed, and if then the Group A work again in that problem the new time elapsed will be print. But the record are printed as you describe in "TABLE WITH NO GROUPING", so when a want to group by "analyst group" all records are grouped in the same group so the sequence is lost.


And last Analyst is a member of a group.

But maybe with the custom group, as you say, gives me some ideas.

Thanks,


Edited by jfrageme02 - 24 Aug 2012 at 1:08pm
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.