Problem with aggregate function in report in adp and sql database.

I

Indra

Hi There,

I have many function like sum or subsum etc in my report. its working
fine in mdb file but when i open the report in adp file its giving me
porblem say " Aggregate funciton are only allowed on output fields of
the record source", I am really looking fro help. What i have to
change in my adp file or report so that i can solve this porblem. Any
information please.



example
=(Sum(([Service]*[ElectriclineBonus]/100)+([Mechanical]*[SlicklineBonus]/100)+([Expendable]*[ConsumableBonus]/100)))*1.05

thanks for help.
Indra.
 
Top