Can you Group Results Already in a Group Footer?

[jsh8286]

I have created a crystal report and grouped it accordingly. The results of this grouping appear as follows in GF#3 on the resulting report:

ITEM DESCRIPTION ITEM QTY SOLD

ANA SILT GREY 10 05B00001 10
ANA SILT GREY 11 05B00002 1
ANA SILT GREY 12 05B00003 5
ANA SILT GREY 13 05B00004 25
ASTRID III WHITE 10 05B10001 15
ASTRID III WHITE 11 05B10002 11
ASTRID III WHITE 12 05B10003 12
ASTRID III WHITE 13 05B10004 3

Bearing in mind that each of the results listed above have already been subtotaled at the detail level to produce these
results in the Group #3 footer section. We want to go a step further. We now with the information above want to subtotal
the items on a change of the item description first 10 characters for example. Therefore to look something like this:


ITEM DESCRIPTION ITEM QTY SOLD

ANA SILT GREY 10 05B00001 10
ANA SILT GREY 11 05B00002 1
ANA SILT GREY 12 05B00003 5
ANA SILT GREY 13 05B00004 25

SUB TOTAL BY STYLE 41

ASTRID III WHITE 10 05B10001 15
ASTRID III WHITE 11 05B10002 11
ASTRID III WHITE 12 05B10003 12
ASTRID III WHITE 13 05B10004 3

SUB TOTAL BY STYLE 41

Not sure how to do this based on the fact that the original layout shown has already been subtotalled. Hence, can you subtotal a subtotal for lack of a better word.

Thanks in advance for any information posted.

 

[lbass]

It looks to me like you should be inserting another group on:

left({table.description},10)

And then make that your group 3, with your current group #3 becoming group #4. You might be able to just insert a summary at the new group #3 level--hard to tell, because you haven't shown samples of the detail level data or identified the type of summary currently used for your original group #3 summary.

-LB

 

[IdoMillet]

Create a formula returning the first 10 characters of the item description. Then, simply Insert a CrossTab (at the desired group or report section level) that uses that formula to subtotal the desired values.

- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com