Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Tips and Tricks
Message Icon Topic: Layout of grouped data Post Reply Post New Topic
Author Message
bluelake
Newbie
Newbie
Avatar

Joined: 08 Jul 2010
Online Status: Offline
Posts: 24
Quote bluelake Replybullet Topic: Layout of grouped data
    Posted: 16 Jul 2010 at 8:43am
I have a report with the data grouped into 7 groups.  How can I order the fields differently from the way they are grouped?  For example they are grouped like this:
        1
          2
            3
              4
                5
                  6
                    7
 
But I want to order them on the page like this:
           1
             2
               3
                 7
                   4
                     5
                       6
 
IP IP Logged
bluelake
Newbie
Newbie
Avatar

Joined: 08 Jul 2010
Online Status: Offline
Posts: 24
Quote bluelake Replybullet Posted: 16 Jul 2010 at 9:04am
I think I should have put this in the technical questions section.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 16 Jul 2010 at 11:08am

Do you mean you have 7 group levels or 1 group level with 7 different items?

IP IP Logged
bluelake
Newbie
Newbie
Avatar

Joined: 08 Jul 2010
Online Status: Offline
Posts: 24
Quote bluelake Replybullet Posted: 19 Jul 2010 at 10:47am

I have 7 groups.  What I want to do is keep a field in its group, but move the section on the page.

IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 20 Jul 2010 at 2:53am
you can drag Group7 under Group3 or wherever you want from Design mode.
 
 
hope it help.
 
Emir W
IP IP Logged
bluelake
Newbie
Newbie
Avatar

Joined: 08 Jul 2010
Online Status: Offline
Posts: 24
Quote bluelake Replybullet Posted: 20 Jul 2010 at 7:38am
I don't want to move the whole group, just one section.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 20 Jul 2010 at 8:57am

Sorry but I am still not sure what you mean by 'I have 7 groups'.

If you only have 1 group with 7 different items in it
(like grouping on 'table.continent') you can manually alter the sort from asc or desc by using a sort formula or you can alter it to use the 'in a specified order' which you enter manually.
 
If you have 7 grouped levels (like group 1 on planet, group2 on contnent, group3 on country, group4 on county, group 5 on city, etc.) you cannot flip '7' above '4' without altering what data would appear the lower groupings of 4, 5, 6.
 
Can you give a more specific real example of what youa re trying to do?


Edited by DBlank - 20 Jul 2010 at 9:03am
IP IP Logged
bluelake
Newbie
Newbie
Avatar

Joined: 08 Jul 2010
Online Status: Offline
Posts: 24
Quote bluelake Replybullet Posted: 20 Jul 2010 at 9:18am
OK, I'll try to give you a clear example.  For the sake of simplicity, I'll only use 3 groups in my example.  Imagine I am grouping a pile of blocks.  For G1, I will group them by size, small and large.  For G2, I will further group them by color.  For G3, I would group them by shape.
 
The layout would look something like this:
G1a Large blocks
G1b Small blocks
G2a Large green blocks
G2b Large red blocks
G2c Small green blocks
G2d Small red blocks
G3a Large square green blocks
G3b Large rectangular green blocks
G3c Large square red blocks
G3d Large rectangular red blocks
G3e Small square green blocks
G3f Small rectangular green blocks
G3g Small square red blocks
G3h Small rectangular red blocks
 
Each of these are in a different section in the report.  I want to keep the items grouped like they are (by size, color, shape) but move the field in section G3d to the position just below G2b. If I just drag it there, I lose the 3rd level of grouping.
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 20 Jul 2010 at 9:28am

As you have found there is no easy way to do this

Possibly using a sub-report that you can place in a group2 header b.
The sub report and or groupheader2b can conditionally be suppressed in the section expert.
Or you can 'alter' your data via a formula field(s) to force a differnt type of grouping.
any of this helping?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 20 Jul 2010 at 9:29am
if this is static group names I think I would go for the sub report process
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.