how to write Annual Report Quary

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

how to write Annual Report Quary

Author

Topic

SwapnaliDashrath
Starting Member

4 Posts

Posted - 2007-06-09 : 04:18:45

I want to write a report quary which will dispaly total of amount,hamali,servicetax,other,granttotal for a particular service
for a financial year

i have tried useing cross-tab but it is not working

OUT PUT OF QUARTY SHOULD LIKE

SERVICE NAME DATA 2007-APRIL 2007-MAY
PARCEL AMOUNT 2950 3000
HAMALI 200 256
SERVICE TAX 30 10
OTHER 20 60
GRANT TOT 3200 3326

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-06-09 : 04:39:03

Refer this
http://weblogs.sqlteam.com/jeffs/archive/2005/05/02/4842.aspx

Madhivanan

Failing to plan is Planning to fail