Sql Reporting Services and PHP

[jamey8420]

I am developing a web page in PHP, and I would like to provide my users access to Reporting Services reports via this page.

 

I am currently running an instance of Reporting Services 2000.

 

I cannot find any good way to link/render/display the reports directly within the PHP page, instead of providing a link to the actual web interface of Reporting Services. I know that asp.net provides a reporting services dll, which has a viewer that can be used in such instances but I'm too far down the line to switch unfortunately. I also did find an example using an iframe (

 

echo "<iframe src=".$sReportPath." height='500' width='100%' scrolling='auto' frameborder='0'></iframe>";

)

but I didnt' like the way that it really looks and the user experience is less than desirable.

 

 

Has anyone else run into a request such as this, or have any ideas about a different approach? Thanks!

 

jamey8420

[wee493]

This should work as long as its one page and not multiple.

$report = file_get_contents($sReportPath);

echo $report;

 

If it is multiple pages you could ste_replace or preg_replace all the links to a get veriable on your site so http://site-stats.com/unique-visits would link to http://yoursite.com/index.php?page=/unique-visits