Wednesday, March 28, 2012

Images from a Database in Header

Hi All,
I'm trying to embed an image in a report header and so far I have had no
luck, the image comes from a DB field based on the report parameters. I have
read the info at the link http://msdn2.microsoft.com/ms159677.aspx, tried it
and still did not work.
If I create an image as specified in the aforementioned link - nothing is
displayed, if I copy that image object and paste it in the body of the report
- the image is shown.
Am I missing something? Has somebody got this to work?
Thanks for your help,
ChrisHi Chris,
Are you using SQL Server 2005 Reporting Services?
Are you adding a fixed image in the Report Header or adding data bounded
images in the Header?
If you are adding a fixed image, make sure you select Embeded Image in the
Wizard
Would you please let me know the detailed steps you are using to reproduce
this error message?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael,
Yes I'm using SQL Server 2005 Reporting Services.
I'm adding a data bound image in the Header. I'm following the steps
mentioned in the link I added to my original post. Basically the recommended
workaround is to add a hidden textbox in the body of the report and reference
that textbox in the image in the header. The image in the header doesn't give
me any errors but it doesn't display either. If using the report designer I
copy the image from the header and paste it as part of the body of the
report, the image displays.
Thanks for your help,
Chris
"Michael Cheng [MSFT]" wrote:
> Hi Chris,
> Are you using SQL Server 2005 Reporting Services?
> Are you adding a fixed image in the Report Header or adding data bounded
> images in the Header?
> If you are adding a fixed image, make sure you select Embeded Image in the
> Wizard
> Would you please let me know the detailed steps you are using to reproduce
> this error message?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Chris,
How did your image stored in database as base64 encoded? If not, I am
afraid you cannot display the image in this way. It would be appreciated if
you could provide me a sample database file (that I could use to attach
directly on my side) to reproduce it on my side.
I understand the information may be sensitive to you, my direct email
address is v-mingqc@.ONLINEmicrosoft.com (please make sure you have removed
ONLINE before you click SEND), you may send the file to me directly and I
will keep secure.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Chris,
Thanks so much for your email and sample solution in zipped file.
I have reproduced it on my side and I am looking into this, which might
take a day or two. I will keep you updated as soon as I find there is
anything useful and thanks for your understanding and patience in advance.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I am having the same exact problem. Just one more piece of information: when
the image does not display in the header, if I go to print the report and
look at a print preview, the image IS displaying. The image also displays if
I export the report to PDF format. It just won't display in the Report
Manager web page. I've tried it with BMP and JPG images; both behave the same.
Also, if I try to set the background image for a text box control in the
header, using the same mechanism, the image does not show up at all.
--
Brian G.
"Christians Izquierdo" wrote:
> Hi Michael,
> Yes I'm using SQL Server 2005 Reporting Services.
> I'm adding a data bound image in the Header. I'm following the steps
> mentioned in the link I added to my original post. Basically the recommended
> workaround is to add a hidden textbox in the body of the report and reference
> that textbox in the image in the header. The image in the header doesn't give
> me any errors but it doesn't display either. If using the report designer I
> copy the image from the header and paste it as part of the body of the
> report, the image displays.
> Thanks for your help,
> Chris
> "Michael Cheng [MSFT]" wrote:
> > Hi Chris,
> >
> > Are you using SQL Server 2005 Reporting Services?
> > Are you adding a fixed image in the Report Header or adding data bounded
> > images in the Header?
> >
> > If you are adding a fixed image, make sure you select Embeded Image in the
> > Wizard
> >
> > Would you please let me know the detailed steps you are using to reproduce
> > this error message?
> >
> > Thank you for your patience and cooperation. If you have any questions or
> > concerns, don't hesitate to let me know. We are always here to be of
> > assistance!
> >
> >
> > Sincerely yours,
> >
> > Michael Cheng
> > Microsoft Online Partner Support
> >
> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> > =====================================================> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >|||Hi Brian and Christians,
Thanks Brian for the inputs.
Yes, we have noticed it will be displayed correctly in Print Preview mode
and it will also be displayed when rendered. I believe this should be a
problem in our product and I have notify the devlopment team about this,
they will look into this.
However, if this will impact your business much, I would recommend you open
an incident with Microsoft Customer Service and Support so that a dedicated
Support Professional can assist with this case. If you need any help in
this regard, please let me know.
For a complete list of Microsoft Customer Service and Support phone
numbers, please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment