News Feed
Jobs Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Brian Swan's Blog:
Rendering SQL Server Reports as Excel Documents with PHP
September 27, 2010 @ 10:15:51

Brian Swan has a new post to his blog that looks at a method for pulling back the reports from a SQL Server instance in something a bit more readable/useful - an Excel document.

One of the most common questions [from his previous post] has been "How do I render a report as an Excel document?" I've been telling folks that this is easy with the SSRS SDK for PHP (and it is easy), but when I sat down to do it, I ran into a problem. So, in this post, I'll show you how to render a SSRS report as an Excel document and how to avoid the one problem that caused me headaches.

This post's a short one with a code snippet (and download) showing how to connect to the server and create a "RenderAsEXCEL" object and request the report information with that in the rendering function. Then it's just as simple as pushing that information out to a file as a ".xls". The included download will also let you pull down the report as HTML or as a PDF.

0 comments voice your opinion now!
sqlserver report excel format pdf html


blog comments powered by Disqus

Similar Posts

Eirik Hoem's Blog: Populate PDF templates with PHP / FPDF / FPDI

Antony Dovgal's Blog: locating bottlenecks in PHP code with Pinba

Brian Swan's Blog: Reflecting on PHP-Microsoft Interoperability

Lukas Smith's Blog: back Is your chosen PHP framework on the PHP primary tester mailinglist?

Chris Shiflett's Blog: Allowing HTML and Preventing XSS


Community Events











Don't see your event here?
Let us know!


code release unittest overview symfony2 opinion install introduction threedevsandamaybe podcast security language facebook framework hhvm composer package hack component application

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework