Grandtotal from groupfoots

[CTImaster]

Hi all!

I have a problem with totals. I have found the same question in another forum but not the total answer. Maybe you can give it to me?

I have a report with nested goups. In third group I do a count on all records in detail section. Then I want to do a grandtotal in the botom. This is quite easy. My problem is that the third group is listing "channels of incoming information". That is Mail/Phone/Email. The grand total should also be devided like that.

Example:

Group Header1
Group Header2
Phone Total 100 [group header 3]
Mail Total 50 [group header 3]
Email Total 150 [group header 3]
Group Header 2
Phone Total 100 [group header 3]
Mail Total 50 [group header 3]
Email Total 150 [group header 3]
Report Footer
Phone Grand Total 200
Mail Grand Total 100
Email Grand Total 300


If I a have a variable which I do a add operation on in GH3 and then displayes the variable in RF. Then I get the value 600.

Any idea?

 

[Reebo99]

I'd create 3 formula fields :
{@Phone}
if {IncomingInfoField} = "Phone" then 1 else 0

{@Email}
if {IncomingInfoField} = "Email" then 1 else 0

{@Mail}
if {IncomingInfoField} = "Mail" then 1 else 0

You can then use this info to sum in the relevant headers/footers. Reebo
Scotland (Going mad in the mist!)

 

[kenhamady]

Or, you could use a cross-tab in the report footer. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com