2. PHPRunner General questions
  3. Error in Sum using group by clause
This topic is locked

Error in Sum using group by clause

 		2/18/2011 01:15:02
PHPRunner General questions
A
 adnankmk author

I have build an application. I have used this query.
SELECT

SUM([Actual_08-09]) AS [S(Actual_08-09)]

FROM dbo.Budget

GROUP BY TMA_ID
i want to show the sum of values using group by clause. but when i open the report in the browser it shows an error shown below.
ADODB.Stream.error'800a0bba'

File could not be opened.

/Project1/include/aspfunctions.asp/line 251
Sergey Kornilov admin 2/18/2011

Error message looks like there is some other issue rather than group by.
I would suggest to post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.