.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

displaying image in report

Posted By:      Posted Date: September 26, 2010    Points: 0   Category :Sql Server
Hello Guys, I am trying to display image on a report. The image field is stored as a binary data in the database. I am using webservice to access the database and return datasets through which data on the report can be accessed. I saw that the xml returns binarystring value from the database. but when i try to display the image it does not show me anything except blank page. I checked the value of the binary data and it does not proceed with ox and tried appending 0x value but no luck. Guys please help me.

View Complete Post

More Related Resource Links

Displaying Image stored in rtf format in access database displaying it on crystal report

Hello, I'm working on a C# project combined with "Crystal Reports 10". When a user inserts something in a "TextField" in my C#-Program, it's saved  as RTF-code (Bolt,Pictures,Underlined,....) to a database.. So if they  reopen it in my "C#"-program they're able to see what they've entered  including their pictures .... But when I created a "Crystal Report"-file and combined it with the same  database used in my "C#"-program, it only show the formatted text and not  the pictures or images... Is there a way to show the "Picture" or "Image" they've inserted in RTF-code  ??? When I copy the code from the database in a simple Text-File and rename  it too "Test.rtf", it wil open correctly in word (with picture and  everything else)... So I hope there is a way to get the picture, Cz it's rather important  they've got a picture of the product they wanna print ...

Image not displaying in SSRS Report from moss 2007 list


Hi, I am generating SSRS report for one of sharepoint list, In this list one filed is picture type for KPI Indicators. After generating report i added picture field by using the below procedure:



Then it is displaying an image holder with RED CROSS image in it.

I tried a lot of things but not able to rectify this as Images for my report is mendatory.


Cannot Display Image in Report


 I have a report using an image control that needs to display an image inside subfolder "Images\InstitutionLogos\".

On properties of image control i have the following properties set:

MIMEType= "image/png"

Source      = Database

Value        ="\Images\InstitutionLogos\" +Fields!InstitutionID.Value+".png"

Inside subfolder "Images\InstitutionLogos\" each image is named with a number which represents Fields!InstitutionID.,(ex, 1.png, 2.png, 10.png)

However, when i run the report the image just displays an X, what am i missing?

Displaying a Parameter Value in the report footer that corresponds with the parameterized data on ea

I've got a report that has only one parameter, it determines the department (or departments) to base the report on, the parameter is set to allow for multiple values. The report returns only on page per department, so the report could be anywhere from one to a hundred pages, one page per department. I've included a text box in the report footer that displays the report name and the parameter value, the expression looks like this: =Globals!ReportName & " For Department " & Parameters!Dept.Value(0)    I know that in this example the zero inside of the parenthesis of the parameter value is what is returning the actual value when the report is rendered, and I understand that the zero is value in the array of parameter values. What I'm looking to do is adapt this expression so that the parameter value rendered on each page corresponds with the data (departement) displayed on the specific page. So using the example of the data, if the user selected three departments in the parameter drop down, then each page that displayed the different department’s information would also display that departments name in the page footer text box. I'm thinking that each time a page is rendered that there is a group or global variable that can be called to provide this dynamically but I can't seem to find the information. Appreciate any help, Dan

Displaying a System.Drawing.Bitmap in a WPF Image control

How would I convert a System.Drawing.Btimap into a comparable WPF image control so I can display in on my WPF window? Thanks

displaying parameters through expressions at the top of the report

Hi,   We developed around 70 ssrs reports for our new application.Its like,all the report names are menrioned in the left hand side and if we click it,.Net calls the SSRS reports and shows in the Right hand side.    At the top of Each and every report,we dispaly all the parameters using expressions. Now, the issue is, in the parameter if they select a single value, then it should display and if they select more than one, it should display like 'More Parameters are selected'. can you helpme how to do that?

ModalPopupExtender not displaying image

Hi guys,I have a modal popup extender with an asp:image control,  and 2 buttons.I have tried to load the image from a file on the local project folder which I have dynamically created through serverside code, but it will not display the image however I tried.here are the codes of the modalpopupextender and the hidden popup panel:            <asp:ModalPopupExtender ID="ModalPopupExtender1" runat="server"                 TargetControlID="lbtn_HiddenLinkButton" BackgroundCssClass="ModalBackground"                 DropShadow="true" OkControlID="btn_DoneCropping"                 CancelControlID="btn_CancelCropping" PopupControlID="pnl_Cropper">            </asp:ModalPopupExtender>            <asp:Panel ID="pnl_Cropper" runat="server" CssClass="ModalPopup" style="display:none">              &

Graphs stop displaying in Report Viewer Control after upgrade to SSRS 2008 R2

We are seeing an issue where certain graphs and guages are not being displayed within a report rendered in the report viewer control after we upgraded from SSRS 2008 to SSRS 2008R2.  You can see the graphs and guages render and then disappear from the screen when two other graphs are rendered.  When I export the report to Excel or PDF then all of the graphs and guages are rendered properly. There are a total of 3 graphs and 2 guages on the report - when it completes the rendering process, you can only see two of the graphs displayed in the report viewer control - as I said before, you can see all 3 graphs and 2 guages when exporting to Excel or PDF.  Using Internet Explorer v8.  This problem manifest itself right after the upgrade. Has anyone seen a similar issue? 

embedding flash image in SSRS report 2008

HI ALL, I have image "Shockwave Flash Object" and i want to upload it into SSRS report ,but when i select the report into ADD Image it shows it will not support the format,suggest how to upload the same image into the SSRSreport 2008   Regards Amit

image from sql(data type is image ) to crystal report

hi all,in sql i am storing picture information in an image field.in vs2005crystal report  i added this image field.but image is not showing.pls help me to show this image in a crystal report

problems displaying image in GridView

That's right, it's me again! For the third or fourth time around I'm trying to make this work... I want to display images in a Gridview, but I'm stuck at getting the images to display. The GridView shows only the image ID:s.My images are saved in the database as <Binary Data>. I'm using an aspx page as Image Handler that receives the binary data of the image from the database and writes it to a response stream (at least that's what the tutorial says I'm doing), and the I use an Image Control in Template field on GridView to call the handler. I've been following this tutorial, and also Mudassar Khans prevoius tutorials combined with other tutorials:http://www.aspsnippets.com/Articles/Display-images-from-SQL-Server-Database-in-ASP.Net-GridView-control.aspxThankful for help!Here's my code,Imagehandler: protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["ID"] != null) { string sql = "SELECT ImgData, ImgContType from" + " BildProd where id=@id"; String strConnString = System.Configuration.ConfigurationManager .ConnectionStrings["DBPejganConnectionString1"].ConnectionString; SqlCommand cmd = new SqlCommand(sql); cmd.Parameters.Add("@id", SqlDbType.Int).Value

How to show the image in crystal report 9 in asp.net 2.0

Hi, I'm using crystal report 9 in asp.net 2.0 web site. i couldn't display the image in report. is anyone having idea about this? i put the image using Insert Picture. in my web config , i put following codes,<httpHandlers> <add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/> </httpHandlers> <appSettings> <add key="CrystalImageCleaner-AutoStart" value="true" /> <add key="CrystalImageCleaner-Sleep" value="60000" /> <add key="CrystalImageCleaner-Age" value="120000" /> </appSettings> Thanks S.Shangar

question regarding displaying parameter value on the report header section



i have a tabular report which has 3 parameters.@begin date ,@enddate and @employeeid.the default value for the @employeeid parameter is "All" .the report works fine even if i don't enter any value for  the parameter @employeeid .

my question is:

i need to display the parameter value for the @employeeid in report header which is easy @parameter!employeeid.value

but I need to display "All" for @employeeid parameter in the report header even i don't enter any value for @employeeid 

i tried to do it by using the code below it is not giving me an error but it is not displaying "All" when i don't enter any value for the @employeeid parameter.


any help in this is greatly appreciated.



Facing issue in displaying the Matrix Report .


Iam using Matrix dataregion to display data.

I will be getting Columns dynamically and Matrix Control will be expanding horizontally.

I need the Columns to get below after reaching certain limit.

Lets say,If the matrix report contains 4 dynamic columns,after expanding to 2 dynamic columns,my report should display in the nextpage or below with 3rd,4th column .

How can I acheive this.

Suppose in case of page break,how can i acheive this.

let me know if it is possible


Me.image1.ImageUrl not displaying image when published


 Hi Everyone,

I have a image control (image1) on a .aspx page and I'm trying to pass in a file system path (not a url) on my Page Load event:

Dim strPictureExists As String = \\rhino\groups\College Photo ID\ & strSID & ".jpg"

Dim strNoPhoto As String = "~/images/nophoto.jpg"

        If File.Exists(strPicture

Programmatically displaying an image in Gridview


Hi Guys,

I need your help!

I have a list of image names stored in a database, along with the id of the property they are associated with. I'd like to be able to display all of the images in a gridview and then allow the user to select the required image.

The problem I'm having is that the gridview is not displaying. I'm pretty sure it's something basic that I've missed, but can't for the life of me see what it is!

Any help would be greatly appreciated!


My gridview code in my aspx page:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">

My code behind (propId is the property id):

        query = "SELECT id, filepath "
                + "FROM images "
                + "WHERE id = ?id";

        MySql.Data.MySqlClient.MySqlCommand command = new MySql.Data.MySqlClient.MySqlCommand();
        command.CommandText = query;
        command.Connection = MyConn;
        command.Parameters.AddWithValue("?id", propId);

        MySql.Data.MySqlClient.MySqlDataAdapter da = new MySql.Data.MySqlClient.MySqlDataAdapter();
        da.SelectCommand = command;
        DataSet ds = new DataSe

Pictures from SSRS report not displaying in Sharepoint



I am using the Page Viewer Web Part to display a Reporting Services report in SharePoint. It was working fine until I tried caching the report in Report Manager. Now, when running the report in SharePoint, the Dundas Charts and Map that are in the report aren't displaying. It's just the typical red x instead of the pic. If I right click and do Show Picture it works, but that won't work for end users obviously. I do have a regular SSRS table at the top of the report, and that displays fine every time.

Does anyone know what is causing this? I'm thinking it must have something to do with caching the report and/or Dundas, because again, everything was fine until I set it to cache.

Thanks for your help.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend