Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Help required to change image dynamically in SSRS

Author  Topic 

ReshmaRoseVincent
Starting Member

10 Posts

Posted - 2008-09-16 : 10:01:38
Hi,

I am using SSRS (SQL Server 2005) for generating reports. Rdlc files are used as mine is a windows application. I need to cdynamically hange the logo which is an image object. I have added a parameter, 'ReportLogo' in the report and assigned the path of the logo to it through code. Then changed the Source property of the image to External and value property to an expression which is =Parameters!ReportLogo.Value. Still the image is not getting changed. I have displayed the value of the 'ReportLogo' parameter and saw that it is getting assigned correctly. Please help me. thanks in advance.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-16 : 10:05:05
Is the problem happening even after deploying to server?
Go to Top of Page

ReshmaRoseVincent
Starting Member

10 Posts

Posted - 2008-09-17 : 00:06:55
Well.. since mine is a stand alone windows application, i'm using rdlc and not rdl and hence i din have to deploy it to report server. i can directly use that report file in any of my forms like :
reportViewer1.LocalReport.ReportPath = "Report1.rdlc";
where Report1.rdlc is placed in the bin debug of the application. When i run the application, report is correctly displayed with correct data, header , footer etc. So am i missing sumthin here?? What could be the problem?? Plss help.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-17 : 00:30:06
quote:
Originally posted by ReshmaRoseVincent

Well.. since mine is a stand alone windows application, i'm using rdlc and not rdl and hence i din have to deploy it to report server. i can directly use that report file in any of my forms like :
reportViewer1.LocalReport.ReportPath = "Report1.rdlc";
where Report1.rdlc is placed in the bin debug of the application. When i run the application, report is correctly displayed with correct data, header , footer etc. So am i missing sumthin here?? What could be the problem?? Plss help.


where are your images stored then? locally?
Go to Top of Page

ReshmaRoseVincent
Starting Member

10 Posts

Posted - 2008-09-17 : 02:11:30
ya.. for trial i jus gave path of one of the pics in my documents-> my pictures.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-17 : 02:20:47
quote:
Originally posted by ReshmaRoseVincent

ya.. for trial i jus gave path of one of the pics in my documents-> my pictures.


so you pass full path from your parameter?
Go to Top of Page

ReshmaRoseVincent
Starting Member

10 Posts

Posted - 2008-09-17 : 02:32:57
Ya.. in code i passed full path as follows:

ReportParameter rptLogo = new ReportParameter("ReportLogo",
@"C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Blue hills.jpg");
reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rptLogo });

then in the value property of the image following expression is given.
=Parameters!ReportLogo.Value
Go to Top of Page

ReshmaRoseVincent
Starting Member

10 Posts

Posted - 2008-09-18 : 00:41:24
Hi Vikash.. do u have any clue to solve the problem yet?? pls help..
Go to Top of Page

ReshmaRoseVincent
Starting Member

10 Posts

Posted - 2008-09-18 : 04:39:07
Hi all. I got this issue resolved. I replaced
ReportParameter rptLogo = new ReportParameter("ReportLogo",
@"C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Blue hills.jpg");
with
ReportParameter rptLogo = new ReportParameter("ReportLogo",
@"file:C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Blue hills.jpg");

Thanks anyways.. :)
Go to Top of Page
   

- Advertisement -