Displaying subtotals in groups depending on how large the subtotal

[chiefcontroller]

Hi all,

I have a CR report which sums all the invoice amounts paid to a particular company and produces a subtotal. I suppress the detail so that I will only see the subtotal by company.

I would like to see the report in the following format:

First show all all the payments to company QX with the corresponding total, regardless of the amount, as the first line.

The second section grouping or section will be all company names and subtotals which exceed $1000

Finally the 3rd group will be all subtotals of companies which had subtotals less than $1000.

The second and third sections of the report have to have the company name in alphabetic order and should have subtotals of the subtotals.

It should look like this:

QX $25
ABC Co 1000
CDE Co 2000
JKF Co 3000
Subtotal 6025

ATB Co 200
FEC Co 100
ZED Co 50
Subtotal 350


Grand Total 6375

Remember all the above lines are already subtotals of other detail lines which have been suppressed.

Any help would be appreciated.

Thanks

 

[MrBillSC]

Subreports always slow things down, but it's the only way I know of for your report.
Group main and sub reports by company name. In the main report select formula select if the group total is > 1000.00 or name is "QX". In the subreport select if group total is < 1000.00 passing a shared subtotal.
Use the shared subtotal in calculating the grand total.

MrBill