Home Dashboard Directory Help

[SSRS] Render a report as an image by Jamie Thomson



Sign in
to vote
Type: Suggestion
ID: 737432
Opened: 4/18/2012 1:59:22 AM
Access Restriction: Public


IGNORE THIS! Apparently you can already do it https://twitter.com/#!/duncansutcliffe/status/192546883464474624 :)

Hosting a SSRS report inside an ASP.Net app is not hard but its not particularly easy either. I have an idea that I think could make it much much easier - let me explain.

Excel Services' REST API has the ability to render parts (including charts) of an Excel workbook as an image. I have talked about this capability here: http://bit.ly/zdEVnk
This makes it brain-dead simple to add an Excel chart to any web page simply using an <img> tag. The key compelling aspect of this is that the chart isn't a copy from some point-in-time - it is showing live data from the underlying workbook and if that underlying data changes simply hitting F5 in your browser refreshes the image too. That's very cool!

I would like you to bring the same capability to SSRS - give us the ability to render a entire SSRS report as an image that we can simply embed in any web page usnig the <img> tag. Sure, the report won't be interactive (e.g. you can't click on any hyperlinks or chart series') but in a lot of cases that doesn't matter - people simply want an at-a-glance visualisation of the data
Sign in to post a comment.
Posted by Microsoft on 4/18/2012 at 10:58 AM
Thanks you for filing this issue. We will consider this feature in a future release. Currently you can render the entire report as an image by using SSRS url access APIs (specify rc:Format=<appropriate format>&rc:Toolbar=false).
Posted by Michael Ciba on 4/18/2012 at 2:27 AM
The general idea of this is very good. However problems may occur when trying to generate a report which requires a large amount of parameters as there is a limit to the amount of information which can be passed via the query string.

When using SSRS and passing information via the query string I have certainly reached this limit which is either caused by the browser or the underline web server hosting SSRS.
Sign in to post a workaround.