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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to calculate expression out of expression. 0
ADP reports using SQL views unavailable to users 7
Future of ADP - new article 12
Upsizing to SQL Server, I lost my forms 1
SQL Function not returning same value over ADP 1
adp report not accepting standard function. 4
Alternatives to ADP? 8
problem with combo box 1

Top