GRoup BY in Report Writer

[jpb]

I am trying to print a profit and loss report using report writer....I have a table in my database which stores all the account details...name, balance type etc...

I want to display this on the report as follows...

Account Name (income) Balance
.
.
Total Income Income subtotal Total


Account Name(Expenses) Balance
.
.
Total Expenses Total Subtotal


Net PRofit Loss Total Incom-expenses


I thought I would be able o do it using a group by clause in an sql statemenet...as follows

"Select AccountName, AccountBalance,sum(AccountBAlance),AccountType from Accounts Group by Account Type

Any suggestions how I could achieve this

 

[MarkSweetland]

Whe you're using aggregate functions (sum, count,etc.. )anything not contained in an aggregate within the Select clause must be referenced in the Group by clause.

Try:

SELECT AccountName, AccountBalance,
sum(AccountBAlance),AccountType
FROM Accounts
Group by AccountType, AccountName, AccountBalance