Friday, March 23, 2012

making a report

how can i create a report for my database? how can i create bar graphs, etc.? im using msde and sql express. pls help. thanks.

MSDE and SQL Express are both free, and neither comes with any reporting tools, AFAIK. SQL Server may, I'm not sure, but the most likely way I would go about doing this is to write a program which reads the database, and then creates a graph from the data. There are free and commercial graphing tools about, but basic graphs are pretty easy to draw in code.

|||What you want is reporting services, but this only comes with the licensed sql server (2000 and 2005) versions which you have to pay for. However, you can create an ODBC link to a sql server database in excel, and produce the required reports there for free!

HTHsql

No comments:

Post a Comment