Multiple Groups

[JKW777]

Having trouble creating multiple groups and subtotals in v8.5. Need to do the following:

Account Description Amount

External Sales
12345 Product 1 $500
12346 Product 2 $200
TOTAL External $700

Internal Sales
23456 Product 1 $300
23457 Product 2 $200
TOTAL Internal $500

TOTAL SALES
12345 & 23456 Product 1 $800
12346 & 23457 Product 2 $400
TOTAL Int & Ext $1200

I can use the group expert to aggregate the accounts (by description or acct number),but when I try to create the 3rd group (TOTAL SALES)it doesn't seem to work (because I'm using the same accounts again??). Also, why is it that when I use the group expert and create what appear to be separate groups (external vs. internal sales, as above), they are both listed under Group Header/Footer #1? I need different totals to appear under separate footers. Do I need a formula to create this type of summarization?

This looks simple but my Crystal experience is limited. Thanks for any help!

 

[IdoMillet]

You can achieve the summary at the end of the report by using Running Totals or conditional totals or a subreport or simply insert a CrossTab by Product.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

We probably need to know more about your fields, but if you want to distinguish external from internal sales, I'm guessing you have a field like {table.salestype}. You would group on that to create Group 1. Then external sales would appear as the first group instance with its own group header and footer, and internal sales would appear as the second group instance.

To get the totals for both combined, you would use the report footer, and you could use a crosstab as Ido suggested, or, if your report doesn't include duplicates, you could insert sums on your detail fields and choose "Insert summary fields for all groups" and "Insert grand total." If you have duplicate fields, you might need to use running totals.

Groups are nested within each other, so that if you next inserted a group (2) on account and then a group (3) on description, your report would show all group 3 instances nested within each group 2 instance, and with all group 2 instances nested within each group 1 instance.

-LB

 

[melW]

I encountered similar problem before. What I did was to create a formula to select Product 1 rec. and get its amount, then I create a total on this formular, to ensure that all revenue (amount) is comming form Product 1 record for Total Sales of Product 1.