Skip to Content
0
Former Member
Jun 09, 2009 at 11:29 AM

Issue with Grouping.

45 Views

Sorry for length of htis post.Only way to describe issue was with example.

I have a report which lists details at Store levels.

Input Data is as follows:   [ Simplified ]

Store Name Store Id   Details
Bath            0001        0001aaaa
Bath            0001        0001bbbb
Bath            0001        0001cccc
Chelsea       0678        0678aaaa
Chelsea       0678        0678bbbb
Chelsea       0678        0768ccc
Derby          0500        0500aaaa
Derby          0500        0500bbbb
Derby          0500        0500cccc
....
etc.

I grouped the Report by Store Name.  

There is no summation - or data manipulation required.

The reason for Groupng is simply to allow: 
a) To Group and Sort Report by Store Name
b) To throw page after each Store
c) To facilitate Group Tree.  

Expected result.

Bath            0001        
0001aaaa
0001bbbb
0001cccc

Throw page

Chelsea      0678  
0678aaaa
0678bbbb
0768ccc

Throw page

Derby          0500        

0500aaaa
0500bbbb
0500cccc


Throw page       etc

Actual Result:

*Bath            0001*
        
*0001aaaa*
*0001bbbb*

*Throw page*

*Bath            0001*
        
*0001cccc*
Throw page

Chelsea      0678  
0678aaaa
0678bbbb
0768ccc

Throw page

Derby          0500        
0500aaaa
0500bbbb
0500cccc

Throw page etc



So Bath [ in this example ] has two Groups.

Bath is shown twice in the Group tree. 

One Group Displays all Subdetails - Except one    
The second Group Displays only One line of sub details.

This only occurs for one store  [ out of 200 or so ]   

Initially this occured for one store. Which was arbitary [ i.e. Not nec. the first alphabetically ].
In the end I enforced the sort order in the SQL which produced the data.
This had the effect of moving the issue to the first store [ alphabetically ] but stil onlu one store.   

Obvious stuff.

I have checked the data. The value 'Bath' is derived from the same field in all cases.
[ It picks up store name from a lookup table to decode the Store number for a more meaningful display ]
So there is no possibility that this is data related.   

This issue has been driving me mad.

I eventually had to use a work-around; where I grouped by Store Number instead; 
This had the expected effect. Although the Group Tree is not as user friendly and the group is not in alphabetic order.

The users use store name & store number with equal familiarity - so they are happy for now.

But I need to know what happened here.

Edited by: Joe Coen on Jun 9, 2009 1:29 PM