We have company logo stored as an "embedded image" in the rdl file. When the
report is deployed to the production server, the logo is not displayed in
the Report Manager.
What all steps are required to deploy reports with embedded images?
pls. help.
ThanksHi newmem,
I have had the same problem. I have found out that my IE 6.0 causes the
error in my case. After switching the IE options "check for newer version of
stored html pages" from "automatically" to "every visit to the page"
everything works fine...
your way: IE -> Internet Options > Settings
I identified the IE because every output format displays the company logo
correctly (PDF...) and only the default and html format was wrong...
Regards
Wolfgang Himmelsbach
"newmem" wrote:
> We have company logo stored as an "embedded image" in the rdl file. When the
> report is deployed to the production server, the logo is not displayed in
> the Report Manager.
> What all steps are required to deploy reports with embedded images?
> pls. help.
> Thanks
>
>sql
Showing posts with label deployed. Show all posts
Showing posts with label deployed. Show all posts
Thursday, March 29, 2012
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
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
Thursday, March 22, 2012
Email subscription Issue
We have deployed SSRS 2005 on internet using Forms authentication. every thing works just fine except the email subscription;
when a user who is part of browser role (manage individual subscription) clicks on new subscription his To field is grayed out (unable to modify) and account showing in it is the service account we use to run reporting service.
we need to give users permission to specity To, CC, BCC fields without letting them see other subscriptions.
can you help us configuring this?
Hi Aneel-You need to go into the rsreportserver.config file located in the ReportServer folder and look for the "<SendEmailToUserAlias>" node. If it is "False", change it to "True" and you'll be able to enter e-mail addresses to send to. You will only get the "To" field, not "Cc" or "Bcc" fields.
Note you may have to restart IIS.
Regards,
Scott
Subscribe to:
Posts (Atom)