Group Footers Problem

[socaldougb]

Is it possible to have a list of Group Footers show below a list of Group Headers on the same page, but that are driven by the same Grouping-level? As I've tried to design it, each footer always appears directly after the header that it refers to. I would like to see 2 separate sections. A per unit section below the full value header, is my example. See below:

Group Header
Salaries and Wages $10,000
Benefits $1,000
Supplies $1,500
Other Expenses $300

Group Footer
Salaries and Wages/Unit $520
Benefits/Unit $52
Supplies/Unit $78
Other Exp/Unit $15


Any assistance is much appreciated!

 

[Madawc]

You seem to be assuming that group totals have to appear in group footers. This is true for running totals and totals based on variables. It is not true for summary totals: the use of Crystal's automated totals is outlined at FAQ767-6524.

You can also use Crosstabs, which group the data differently from the report group. Worth learning what they can do even if you don't need them just now.

PS. It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options. In this case, it probably makes no difference.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[socaldougb]

Hi Madawc,
Thanks for the response. As a side note, I'm using Crystal 11. I'm still a little uncertain as to the solution to my problem. The Group Header I have setup is already a Summary of detailed account-level data. I'm having more of an issue with the layout than anything. I would like to show two separate sections both functions of the Grouping-level. However, when I insert the Summary as the Header, and the calculated per Unit as the Footer they always appear in pairs for each value in the group. See below:

Current Layout
Salaries and Wages $10,000 (Group Header)
Salaries and Wages/Unit $520 (Group Footer)

Benefits $1,000 (Group Header)
Benefits/Unit $52 (Group Footer)

Desired Layout
Salaries and Wages $10,000 (Group Header)
Benefits $1,000 (Group Header)

Salaries and Wages/Unit $520 (Group Footer)
Benefits/Unit $52 (Group Footer)

Thanks again for any insight you can provide!

 

[lbass]

Please show the content of the formula used for the per unit calculations.

I think you could add a crosstab in the report footer, and then just show the group headers.

-LB

 

[socaldougb]

Thanks for your help LB. Below is the per unit formula. Let me know if a crosstab would work.

if {?APDActMo}=0 then 0 else
Sum ({@Amount1mo}, {AccountCategory.AccountCategory})/{?APDActMo}

 

[lbass]

Please show the content of the nested formula.

Also explain the parameter--is "unit" then some number of months? Or?

-LB

 

[socaldougb]

Below is the nested formula (@AmountMo). The report design has 2 sections - current period and YTD. The user inputs the units for both sections. Thus the Mo designation.


if ({GeneralLedgerDataSet.DataSet}={?Dataset1} and {AccountType.AccountTypeCode}="S" and {AccountCategory.Rank}>3)
then 0 else
if ({GeneralLedgerDataSet.DataSet}={?Dataset1} and {AccountType.AccountTypeCode}="M" and {AccountCategory.Rank}>3)
then 0 else
if {GeneralLedgerDataSet.DataSet}={?Dataset1} and {MonthView.FiscalMonthNumber}=maximum({?TimePeriod}) then {GeneralLedger.Amount}
else 0

 

[lbass]

Try inserting a crosstab in the report footer that uses account category as the row field and sum of {@PerUnitFormula} as the
summary field. You will have to verify that it is returning the correct amount.

-LB