Displaying the Images Returned by the RenderStream Method of SQL Server Reporting Services

I am working on a project that is a Web-based application that uses the render and RenderStream methods of SQL Server reporting services.

When you use the Render() method of SQL Server reporting service, it returns to you the stream of the report. If you have images in your report and you are getting the stream of type HTML, the returned stream will not contain the images in it. It will contain streamIdb's for all the objects such as charts, images, and so forth. 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.

To fix this problem, you have to configure your Web server. The steps to do this follow:

  1. 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 to successfully create resources).
  2. Open the Properties page for of your Web application and select the HTTP Headers tab.
  3. Click 'MIME Types.'
  4. 4.Click 'New Type.'
  5. In 'Associated Extension.' enter '*' (no quotes).
  6. In 'Content Type (MIME).' enter 'image/png' (no quotes).


About the Author

Malik Asif

I am Malik Asif, a Software Engineer by Profession. working at Palmchip Corporation Pakistan.

Comments

  • Rendering Reporting Services graphs in Sharepoint

    Posted by prakashpatil_1978 on 06/13/2005 07:39am

    Hi, I have developed a sharepoint site which displays Reporting Services reports. The problem here is i can view the report but not the image, somehow the image cannot be rendered. However, if i have the Sharepoint and Reporting Service installed on same machine, the graph renders well. So i think in my case im having some issue while rendering the graph from network machine. Any help will be appriciated. Thanks in advance, Prakash.

    Reply
Leave a Comment
  • Your email address will not be published. All fields are required.

Top White Papers and Webcasts

  • Java developers know that testing code changes can be a huge pain, and waiting for an application to redeploy after a code fix can take an eternity. Wouldn't it be great if you could see your code changes immediately, fine-tune, debug, explore and deploy code without waiting for ages? In this white paper, find out how that's possible with a Java plugin that drastically changes the way you develop, test and run Java applications. Discover the advantages of this plugin, and the changes you can expect to see …

  • With 81% of employees using their phones at work, companies have stopped asking: "Is corporate data leaking from personal devices?" and started asking: "How do we effectively prevent corporate data from leaking from personal devices?" The answer has not been simple. ZixOne raises the bar on BYOD security by not allowing email data to reside on the device. In addition, Zix allows employees to maintain complete control of their personal device, therefore satisfying privacy demands of valued employees and the …

Most Popular Programming Stories

More for Developers

Latest Developer Headlines

RSS Feeds