Print Page | Close Window

Layout of grouped data

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10556
Printed Date: 02 May 2025 at 12:38am


Topic: Layout of grouped data
Posted By: bluelake
Subject: Layout of grouped data
Date 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
 


Replies:
Posted By: bluelake
Date Posted: 16 Jul 2010 at 9:04am
I think I should have put this in the technical questions section.

Posted By: DBlank
Date Posted: 16 Jul 2010 at 11:08am

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

Posted By: bluelake
Date 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.

Posted By: Emir_W
Date 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

Posted By: bluelake
Date Posted: 20 Jul 2010 at 7:38am
I don't want to move the whole group, just one section.

Posted By: DBlank
Date 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?

Posted By: bluelake
Date 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.
 

Posted By: DBlank
Date 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?

Posted By: DBlank
Date Posted: 20 Jul 2010 at 9:29am
if this is static group names I think I would go for the sub report process


Print Page | Close Window