Proper formula to total multiple tables

[Pandal]

i have a sewer main inspection
It shows 9 numeric observations ,each observation has its own table
I need to add all 9 tables together and show the total only within the report
anyone know the formula, I tried {1} + {2} etc to 9 and it shows all totals beside each other 201432106 it doesnt total them
thanks for any help

 

[synapsevampire]

Try posting technical information:

Crystal version
Database/connectivity used
Example data
Expected output

Generally combining tables is done using a UNION ALL SQL statement, but that's dependent upon knowing something about the environemnt.

-k

 

[IdoMillet]

After you join your tables (probably on something like Sewer_ID you should be able to simply creates a formula that adds the 9 numeric fields.

You can then sum that formula to any level of grouping or to the grand total.

hth,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Pandal]

Crystal 8.0 oracle database
I tried doing a sum of the fields but I get an error saying a number field is needed here
Is there a way to make these fields numeric , if that is the problem

 

[Pandal]

sum ({INSMHI.HYCVRS} + {INSMHI.HYFRAMES} + {INSMHI.HYRINGSS} + {INSMHI.HYCONES} + {INSMHI.HYWALLS} + {INSMHI.HYBENCHS} +
{INSMHI.HYCHNLS} + {INSMHI.HYBASES} )

This is where I get the error saying a numeric field is needed