How to calculate the totals by avoiding record selection formula..

[dev777]

Group I - MarketType (values: Low, Large, Risk)
Group II - Order Type (values: Casualty, Control, Property)

Formulaes:
Total Accounts=Count{CTL.Accountnumber}
GWP=SUM{CTL.GWP}

Record Selection Formulae:
I have two parameters Req Type and Work order type so the record selection formula is

(
{?Req}={CTL.Req} and
{?WO}={CTL.WO}
)

I can calculate totals as --> Count({CTL.Accountnumber},{CTL.MarketType} and Sum({CTL.GWP},{CTL.MarketType})
But this is the totals of the records selected using record selection formula by default as crystal reports filters the records based on record selection formula.

But the requirement here is to Calculate the totals not specific to req type and work order type.




My Report looks like this..

Market Type Order TYpe # accnts GWP

Low Casualty 500 1000
Control 300 900
Property 700 2000

Total--------------> ??? ???

Large Casualty 400 500
Control 200 2000
Property 100 1000

Total--------------> ??? ???

Risk Casualty 900 5000
Control 800 600
Property 500 2000

Total--------------> ??? ???

 

[lbass]

If you use this in the GROUP selection area:
(
{?Req}={CTL.Req} and
{?WO}={CTL.WO}
)

...only those records will be displayed, but your formulas shown earlier would reflect all records, since all records are still IN the report, just not selected for display.

-LB