Creating Page of Summaries

[wilekoyote76]

How would one go about creating a page of summaries from all Groups? Basically I'm looking at taking a calculated value for each group within the footer of the group and I want to create a summary page that has the group name and the calculated value from within the footer of that grouping.

 

[lbass]

What are you grouping on? What is the calculation?

-LB

 

[Madawc]

You can probably get the same result using a Crosstab. You find crosstabs under Insert and they can use the same groupings as the main report, or something else when that is useful.

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 makes difference because higher versions allow formula fields as well as data items.


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

 

[wilekoyote76]

CR11r2
I am grouping by this field. {CONTACT2.UclmADJ}

Formula's being used that need to be summarized by adjuster:

License_commission=
if {CONTACT2.UINSCO} = "Company" then {@Adjuster_Fee_Calc}*1
else if {CONTACT2.UCLMADJ} = "15"
or {CONTACT2.UCLMADJ} = "1" then {@Adjuster_Fee_Calc}*1
else if {CONTACT2.UCLMADJ} = "L010-5" or {CONTACT2.UCLMADJ} = "L010" or
{CONTACT2.UCLMADJ} = "LE10-1" or {CONTACT2.UCLMADJ} = "LE10-3"
or {CONTACT2.UCLMADJ} = "07" or {CONTACT2.UCLMADJ} = "16"
or {CONTACT2.UCLMADJ} = "14"
then
{@Adjuster_Fee_Calc}*.7
else {@Adjuster_Fee_Calc}*.8



File_total_commission=({@Licensee_Commission}+{CONTACT2.UPOSTENV}+{CONTACT2.UPHONEAMT}+{CONTACT2.UPHOTOS}+{CONTACT2.UMILEAGE})



Adjuster_fee_calc=if {CONTACT2.UROAMTINV} > 0 then
{CONTACT2.UROAMTINV}
else if {CONTACT2.URIAMTINV} > 0 then
{CONTACT2.URIAMTINV}
else if {CONTACT2.UINTINVAMT} > 0 then
{CONTACT2.URIAMTINV}
Else
{CONTACT2.UADJFEE}-{CONTACT2.UPOSTENV}-{CONTACT2.UPHONEAMT}-{CONTACT2.UPHOTOS};

 

[lbass]

A crosstab looks like the best idea. Add a row on your adjuster field, and then add the desired summaries. Place the crosstab in the report footer.

-LB