report - SQL Server Forums

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

SQL Server 2000 Forums

SQL Server Development (2000)

report

Author

Topic

sent_sara
Constraint Violating Yak Guru

377 Posts

Posted - 2006-12-01 : 05:11:40

Hi fyi,

Month Petrol Bike expense Personal Medical Others
January 121 11 587 120
February 1500 1500 121 587 120
March - - 121 1500 120
April - - 121 1500 548
May - - 121 1500 548
June 1500 548
July 480 548 11 1500 548
August 480 11 1500 89
September 480 11 121 57
October 480 0 480 121 89
November 480 140 480 121 89
December 540 480 587 89

for each and every month iam creating table expense012006,expense022006 and so on.. and maintaining all the head of expenses for that month.just iwant to the data to be printed in report finally mentioned above.

what my wish is can i create one table(temp table) in which it contains all the mentioned data and finally printing thr report from vb6.0 or any other solution???????

Application using:vb6.0,
Database:sqlserver2000,
Report:crystal report 8.0.

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-12-01 : 05:18:31

Creating tables for each month seems to be bad choice of design. You can use Cross-tab queries to solve your problem. It will be lot simpler to maintain and faster too. Search here for Cross-tab queries.

Harsh Athalye
India.
"Nothing is Impossible"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources