Writing reports on PHP / SQL Server
SQL Server ships with Reporting Services out of the box as of version 2005. If you are using SQL Server 2000, Reporting Services 2000 is available as a free download. Reporting Services is web-based, so you can disable the URL from anywhere. You can also embed hyperlinks into your application in reports.
Most, if not all third-party reporting tools support SQL Server. Anything related to an ODBC object can be done to query for it. If you need to run a web server that supports reporting for something other than windows, you can look at one of the open source systems like Pentaho , BIRT, or Jasper Reports .
source to share
Check it out: http://sourceforge.net/projects/phpreportgen/
You will need to use SVN to get the code, but it works very well and can work with just about any data source.
source to share