What is a good method of writing reports using PHP and SQL Server? Is there a third party vendor that supports SQL Server?
2
-
How about web based report generation?Nick Berardi– Nick Berardi2008-11-27 16:23:43 +00:00Commented Nov 27, 2008 at 16:23
-
See the post below for some options for this.ConcernedOfTunbridgeWells– ConcernedOfTunbridgeWells2008-11-28 13:52:27 +00:00Commented Nov 28, 2008 at 13:52
Add a comment
|
2 Answers
SQL Server comes 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 drive it off a URL referred from anywhere. You can also embed hyperlinks back out to your application in the reports.
Most if not all third party reporting tools support SQL Server. Anything with an ODBC facility can be made to query off it. If you need to run the web server supporting the reports on something other than windows, you could look at one of the open-source systems such as Pentaho, BIRT or Jasper Reports.
answered Nov 27, 2008 at 16:07
ConcernedOfTunbridgeWells
67.2k15 gold badges149 silver badges199 bronze badges
Comments
Check this one out: http://sourceforge.net/projects/phpreportgen/
You'll have to use SVN to get the code, but it works really well and can operate with virtually any data source.
