Displaying the Images returned by RenderStream Method of Sql Server Reporting Services.(By Malik Asif Joyia.)

Introduction

I am Malik Asif Joyia. Working as software engineer in Palmchip corporation Pakistan.

this Article will help to you solve a problem which you face when you render your report in a web page in html format. you will not face this problem for the other types like PDF, EXCEL etc. because that include images or charts in their stream.

Details

I am working on a project that is a web based application that uses render and RenderStream Methods of Sql server reporting services.

When you use the Render() method of Sql server reporting service that return u the stream of the report. If you have images in your report and you are getting the stream of type HTML. Then returned stream will not contain the images in it. It will contain streamId’s for all the object like charts, images etc.

Then after calling the render method you need to call the RenderStream() method to get all the objects.

As I got started on it, I had some problems getting the rendered images to appear in the report. It turns out that these resources are output without any file extension, so IE wasn't sure how to handle them.

The fix this problem you have to configure your Web Server.

• In Internet Information Services Manager, navigate to the directory where external resources are rendered (the ASP.NET Machine account <machinename>\ASPNET will need to have write permissions to this directory in order to successfully create resources)

• Open the Properties page for of your web application , and select the HTTP Headers tab

• Click 'MIME Types'

• Click 'New Type'

• In 'Associated Extension', enter '*' (no quotes)

• In 'Content Type (MIME)', enter 'image/png' (no quotes)

I am working on a project that is a web based application that uses render and RenderStream Methods of Sql server reporting services.

When you use the Render() method of Sql server reporting service that return u the stream of the report. If you have images in your report and you are getting the stream of type HTML. Then returned stream will not contain the images in it. It will contain streamId’s for all the object like charts, images etc.

Then after calling the render method you need to call the RenderStream() method to get all the objects.

As I got started on it, I had some problems getting the rendered images to appear in the report. It turns out that these resources are output without any file extension, so IE wasn't sure how to handle them.

The fix this problem you have to configure your Web Server.

• In Internet Information Services Manager, navigate to the directory where external resources are rendered (the ASP.NET Machine account <machinename>\ASPNET will need to have write permissions to this directory in order to successfully create resources)

• Open the Properties page for of your web application , and select the HTTP Headers tab

• Click 'MIME Types'

• Click 'New Type'

• In 'Associated Extension', enter '*' (no quotes)

• In 'Content Type (MIME)', enter 'image/png' (no quotes)

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here