Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Page Header - =System.Convert.FromBase64String

Status
Not open for further replies.

V2008

Programmer
Sep 11, 2008
37
US
I did use the correct way as suggested by Microsoft web site
for displaying image in Page Header
1) Created a textbox10 with
=System.Convert.ToBase64String(First(Fields!Logo.Value, "ABC")) in body and hide it

2)Then created an image in Page Header
=System.Convert.FromBase64String(ReportItems!textbox10.Value) and settings are MIME - bmp and source-Database

3) no image is displayed in page header

If I create an image with same value in body - =System.Convert.FromBase64String(ReportItems!textbox10.Value), it displays image
but in Page header - it is blank, nothing is getting displayed

What is missing?
 
Hello,
i've the same problem. But at my report the image appears, if there is only 1 page. If the report has more than 1 pages, the image doesn't appear.

Do you have allready a solution for your problem?

thanks for more information.
 
Yes, I had solution.
I did two things
1)
I created a parameter and then in Report footer display that parameter.
2)I installed Service Pack 3 of SSRS.
 
I've also tryed it with parameters. For fields which are string or integer, the solution with parameters works but how could i define a parameter for a field which is varbinary?

Thank's again for more information.

Kind regards

 
I took Varbinary as a string parameter.
 
How can i combine the solution

1) Creatin a textbox10 with
=System.Convert.ToBase64String(First(Fields!Logo.Value, "ABC")) in body and hide it

2)Then created an image in Page Header
=System.Convert.FromBase64String(ReportItems!textbox10.Value) and settings are MIME - bmp and source-Database

with using parameters?

To get the picture on page >2 i think, parameters are necessary but to display the pictures generally the solution above has to be used.

Any more ideas?
 
1) Press Alt Enter on text box->it will open up Properties screen for this text bos and select visibilty from Properties and then turn True. True means hide.
 
Sorry, I think I didn't describe my problem in the right way:

I have to display the Signature (Image) and the name (text) of the one who has signated in the footer of my report only on the last page. Both are values which come out of a dataset.

Step 1 and 2 of your first description I had allready done in my report. With this solution the image (Signature) appears correctly in the footer, if the report has only 1 page. But if the Report has more than 1 page, the image doesn't appear.
For the Name which has to be written under the signature I reached the solution with parameters. Then it works even if the report has more than 1 page.

But at my current installation of SSRS it is not possible to create a parameter and connect it with the image (field-type Varbinary). Now i installed SP3. Tomorrow i will try it again.

Perhaps you have any more ideas for me??
 
If you are using image in Report Header or footer, image should appear on each page. Install SP3 and then check.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top