Image in the Header Area
I have a problem regarding to Header Area of My Report,I have place an Image in the Header Area of my Report and my report comprises of almost 10 pages.The problem is that, the image is print only on the First page, not on the whole report.How can i settle this issue,so that the image comes on all the pages ?Thanx....
October 23rd, 2009 9:26am

Hi, Normally this should work i am also using this type of reports and my reports are running fine can u give little bit detail about how u r assigning the image etc..
Free Windows Admin Tool Kit Click here and download it now
October 23rd, 2009 10:08am

The image is placed in my database, and it works fine onthe first page of report,but whenever it goes to 2nd page and so on, it doesn'tshow theimage, and cross sign is displayed at the image place,which indicataes the absence of image.
October 23rd, 2009 12:40pm

Hi Enigma85,I assume you have implemented the report with SQL Server Reporting Services 2008. If I have misunderstood, please do not hesitate to let me know.Based on my testing, with SQL Server Reporting Services SP1, the report will be printed with image in each page.So, I would suggest you to update the SQL Server Reporting Services 2008 to Service Pack 1 to solve the issue.SQL Server Reporting Services 2008 is available on:http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19SP1 is fine, however, apply the latest hotfix is suggested:Cumulative Update #4 for SQL Server 2008 SP1 Please feel free to ask, if you have any more questions.Thanks,Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
October 26th, 2009 12:10pm

No, I have implemented my report in SQL Server Reporting Services 2005 and still i unable to resolve this issue.
October 27th, 2009 6:45am

Hi Enigma85,For SQL Server Reporting Services 2005, fields are not allowed to use in Header.Could you please elaborate a bit more about your design layout? that will help us to solve the issue.Thanks,Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
October 27th, 2009 6:50am

For RS 2005, please refer to the following blog posting: http://blogs.msdn.com/bwelcker/archive/2007/06/19/marquee-moon-field-references-in-page-headers-and-footers.aspx, specifically I'd recommend the hidden parameter approach.HTH,RobertRobert Bruckner http://blogs.msdn.com/robertbruckner This posting is provided "AS IS" with no warranties, and confers no rights.
October 27th, 2009 8:39am

I have placed image in my Database and in Image Properties, i assign this method in value field of imagei.e =Convert.FromBase64String(Field!Photo.Value)As mention above, the image works fine on the First page of report andon remaining pages it shows a cross sign at image region.
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2009 7:51am

Did you give the Image Sourceas Database?
October 28th, 2009 8:01am

Yes of course, source is my database, and the main thing is that the image is working fine on first page,so it implies that it's not an issue of source.
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2009 8:10am

Hi, I have tried another method now, as SQL Server Reporting Services 2005 doesn’t allow using fields in header area, so I am using reportitems method now. I place the fields in the body area of report and in the header area I am using reportitems method. The actual scenario is exactly like this. In the body area, I place a text box and write this expression: =Convert.ToBase64String(First(Fields!CompanyLogo.Value, "Logo")) And in header area, I place an image control from the toolbox, and in its properties, I write this expression In the VALUE parameter. =Convert.ToBase64String(First(Fields!CompanyLogo.Value, "Logo")) Here Source is my database. Unfortunately, the result is again same, image is print only on the first page of report, I am unable to understand that what is the problem with these two methods? If it successfully loads image on the first page, then why not on others pages. Does anyone have a solution?
January 1st, 2010 2:23pm

ReportItems method only works when that I is present on the page. In your case the item is found on the first page of the report where you have hidden it. On subsequent pages this item is NOT present and thus the item isn't displayed in the header.
Free Windows Admin Tool Kit Click here and download it now
February 14th, 2011 3:39pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics