Aggregate Functions

From: acabrera (acabrera_at_bca.lacity.org)
Date: 04/27/04 

Date: Tue, 27 Apr 2004 20:43:49 +0000

I am converting our BDE-based Delphi 7 applications to ADO (OleDB).
There is a report which uses aggregate functions and below is the erring
statement:  

SELECT MAX(STATUS_DT), MAX(PCT_DONE)
FROM PROJ_STATUS
WHERE PROJ_KEY(+) = :PROJ_KEY
       AND DEL_FLAG IS NULL
ORDER BY PROJ_KEY

The error message is 'Not a single-group function.' I read that OleDB
does not support aggregate functions. How can I then run the report?

Thanks.

--- posted by geoForum on http://delphi.newswhat.com

Relevant Pages

  • Re: Urgent Help required - Agregate Error
    ... report's record source. ... Simple aggregate functions like Sum ... > in the report. ... > earlier posting I've received hundreds of spam mails. ...
    (microsoft.public.access.reports)
  • Re: reports: sum and avg difficulties
    ... had to be changed to Numbers for the calculations to work on the report. ... >The aggregate functions can only ... >They are not aware of controls in the report. ... >The error message actually implies that you may already be ...
    (microsoft.public.access.reports)
  • Access Projects Help
    ... In my Access Projects Report, I cannot use any aggregate functions, sum, avg ... In the detail section of my report, in a text box called txtTime I have the ...
    (microsoft.public.access.reports)
  • Access Projects Report
    ... In my Access Projects Report, I cannot use any aggregate functions, sum, avg ... In the detail section of my report, in a text box called txtTime I have the ...
    (microsoft.public.access.reports)
  • runtime error 20532
    ... my application work on DSL and when i configure my report on DSN it works ... report but when i run the same report with OLEDB connection on LAN it works ...
    (microsoft.public.vb.crystal)