Tuesday, March 27, 2012

Embedded image

A report has embedded images in it. They display fine in ReportDesigner.
However, they do not display after being deployed to the ReportServer when
viewed in ReportManager. They do display if the report is exported to pdf
format. However, the requirement is simply to display the report in
Sharepoint using a URL in the page viewer webpart. Does the image file need
to also be installed on the report server box, uploaded to ReportManager
...?I believe that If the image is embedded in the report than it is stored
as binary data in the ReportServer database.
Is the image showing up as a red x?
have you right-clicked on the image and looked at the properties?
What is the url of the imbedded image?|||The image is showing up as a box (there is not a red x). When I right-click
on the image the properties show the url as -
ReportServer?%2fDashboard+-+MTD&rs%3aFormat=HTML4.0&rs%3aImageID=8a9c568f-8086-4138-a852-fc08d0111215.
So even though the image is 'embedded' we're thinking that it is also stored
in the database. Would that happen when the report is deployed to the
reportserver or when the rdl is uploaded?
Thanks for the help.
"patrick_brisbine" wrote:
> I believe that If the image is embedded in the report than it is stored
> as binary data in the ReportServer database.
> Is the image showing up as a red x?
> have you right-clicked on the image and looked at the properties?
> What is the url of the imbedded image?
>|||if you run the below query against the reportserver database it should
return one record, the last part of the url is the image id in the
database: 8a9c568f-8086-4138-a852-fc08d0111215.
select * from chunkdata
where chunkname = '8a9c568f-8086-4138-a852-fc08d0111215'
If you are having problems, delete the report from the server, delete
the image from the report (report > embedded images > delete), and then
re-add the image. this will insert a new "image" record in the
database and might (or might not) fix your problem.
hope this help!|||The query did return a record.
I tried deleting the image and readding it. The record in the database also
deleted and readded. Still no luck. When I try to run the url statement for
the image, the following error occurs:
The stream cannot be found. The stream identifier that is provided to an
operation cannot be located in the report server database. (rsStreamNotFound)
Get Online Help
Is there something on the server that needs to be set? The report runs fine
on another server.
Thanks
----
"patrick_brisbine" wrote:
> if you run the below query against the reportserver database it should
> return one record, the last part of the url is the image id in the
> database: 8a9c568f-8086-4138-a852-fc08d0111215.
> select * from chunkdata
> where chunkname = '8a9c568f-8086-4138-a852-fc08d0111215'
>
> If you are having problems, delete the report from the server, delete
> the image from the report (report > embedded images > delete), and then
> re-add the image. this will insert a new "image" record in the
> database and might (or might not) fix your problem.
>
> hope this help!
>|||Could this have anything to do with the fact that both SharePoint and
ReportingServices are on the same server (Windows 2003)'
"PD" wrote:
> A report has embedded images in it. They display fine in ReportDesigner.
> However, they do not display after being deployed to the ReportServer when
> viewed in ReportManager. They do display if the report is exported to pdf
> format. However, the requirement is simply to display the report in
> Sharepoint using a URL in the page viewer webpart. Does the image file need
> to also be installed on the report server box, uploaded to ReportManager
> ...?|||Can you view the image on its own in Internet Explorer (right click image
file in Windows Explorer, Open With... > Internet Explorer)? If not, then it
may have something to do with the colour palette settings used in the image
itself.
We had exactly the same problem with an image appearing OK in the designer &
when exported to PDF/Excel, but not appearing in Report Manager. We got one
of our design guys here to fix the image so it was using the RGB colour
palette (don't know the technical process for it, I'm a DBA here), tried with
the new copy of the image, and hey presto! It worked.
Hope this helps.
Jadranka.
"PD" wrote:
> Could this have anything to do with the fact that both SharePoint and
> ReportingServices are on the same server (Windows 2003)'
>
> "PD" wrote:
> > A report has embedded images in it. They display fine in ReportDesigner.
> > However, they do not display after being deployed to the ReportServer when
> > viewed in ReportManager. They do display if the report is exported to pdf
> > format. However, the requirement is simply to display the report in
> > Sharepoint using a URL in the page viewer webpart. Does the image file need
> > to also be installed on the report server box, uploaded to ReportManager
> > ...?|||Hi PD
Did you have success in this problem
I'm with the exact SAMEproblem here. I already tried everything, an
nothing seems to work ...
If so, contact me ... rodrigo[at]pointsystems.com.br ..
Regards|||I FOUND THE SOLUTION
My server name contains a underscore "_" in it. It may cause sessio
problems
I found out that images on Reporting services rely o
session and cookies
In the Report Server Database, there is a table calle
ConfigurationInfo. I changed the value of UseSessionCookies t
False
Voilá! ;-
Regards

No comments:

Post a Comment