Dynamically add images to SQL Server 2005 Reports – ASP.Net Web Project

It is very exciting to know that people are widely using SQL Server 2005 Reporting Services. I am always happy to answer their questions. A couple of days back a gentleman requested for some help on the project that I have posted on this blog – How to dynamically display the Images in SQL Server 2005 Reporting Services Reports ?

He wants to know how we can achieve the same functionality in ASP.Net 2.0 web project so today being a weekend I could squeeze out some time and I could develop a small sample web project. To find the report project and the windows project please refer my earlier post.

This is a sample to demonstrate how to do add the images to the Reports Dynamically and it is not the production ready code so please test it well before release.

 

Email received

Subject: "How to dynamically display the Images in SQL Server 2005 Reporting Services Reports ? "

Date: Wed, 25 Jul 2007 18:39:01 +0530

Hi Ravi,

 “How to dynamically display the Images in SQL Server 2005 Reporting Services Reports ? “

 I read this article and looked the code …….It’s working fine in Windows Project….

But in web ASP.Net 2.0 , it is not working. There are some different properties of Report viewer control in windows

like Clear(), Reset(), Refresh….. which are not available in web report viewer control.

Even I instantiated report viewer control, it doesn’t bind image to report see the code

 

C# CODE Not Included here…

 

“VisaDummy is the name of the report which is used to show image and it has only one dataset as dsImage…….

 I have tried too many times for that but it doesn’t work…….

 Pls Suggest me any solution for Web

 Waiting for Reply………..

<Name>

 

Link to download

DynamicImage.zip