I've placed a logo I'd like on my reports at the path
http://<servername>/reports/images/logo.gif
I've also performed the instructions as per the article "Configuring an
Account for Unattended Report Process" in the RS BOL. I've also re-started
IIS, several times yet I still cannot get the logo to show when I view the
report via the Report Manager.
Any suggestions on what to try next appreciated?It now appears to have corrected itself, may have been a caching issue as I
deleted the report and then re-deployed it.
"Mark Parter" wrote:
> I've placed a logo I'd like on my reports at the path
> http://<servername>/reports/images/logo.gif
> I've also performed the instructions as per the article "Configuring an
> Account for Unattended Report Process" in the RS BOL. I've also re-started
> IIS, several times yet I still cannot get the logo to show when I view the
> report via the Report Manager.
> Any suggestions on what to try next appreciated?|||The machine name where the reports manager is installed doesn't have an
underscore in it's name does it?
"Mark Parter" wrote:
> I've placed a logo I'd like on my reports at the path
> http://<servername>/reports/images/logo.gif
> I've also performed the instructions as per the article "Configuring an
> Account for Unattended Report Process" in the RS BOL. I've also re-started
> IIS, several times yet I still cannot get the logo to show when I view the
> report via the Report Manager.
> Any suggestions on what to try next appreciated?|||Nope.
"Dan Fell" wrote:
> The machine name where the reports manager is installed doesn't have an
> underscore in it's name does it?
> "Mark Parter" wrote:
> > I've placed a logo I'd like on my reports at the path
> > http://<servername>/reports/images/logo.gif
> >
> > I've also performed the instructions as per the article "Configuring an
> > Account for Unattended Report Process" in the RS BOL. I've also re-started
> > IIS, several times yet I still cannot get the logo to show when I view the
> > report via the Report Manager.
> >
> > Any suggestions on what to try next appreciated?|||did you find the problem?
"Mark Parter" wrote:
> Nope.
> "Dan Fell" wrote:
> >
> > The machine name where the reports manager is installed doesn't have an
> > underscore in it's name does it?
> >
> > "Mark Parter" wrote:
> >
> > > I've placed a logo I'd like on my reports at the path
> > > http://<servername>/reports/images/logo.gif
> > >
> > > I've also performed the instructions as per the article "Configuring an
> > > Account for Unattended Report Process" in the RS BOL. I've also re-started
> > > IIS, several times yet I still cannot get the logo to show when I view the
> > > report via the Report Manager.
> > >
> > > Any suggestions on what to try next appreciated?
Showing posts with label placed. Show all posts
Showing posts with label placed. Show all posts
Monday, March 26, 2012
External Image Problem
I've placed a logo I'd like on my reports at the path
http://<servername>/reports/images/logo.gif
I've also performed the instructions as per the article "Configuring an
Account for Unattended Report Process" in the RS BOL. I've also re-started
IIS, several times yet I still cannot get the logo to show when I view the
report via the Report Manager.
If I login to the machine using the account used in the article above, I can
access the URL no problem via IE.
Any suggestions on what to try next appreciated?If the image is on the same server as the report, try using folder path
instead of URL, e.g. "/images/logo.gif".
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> I've placed a logo I'd like on my reports at the path
> http://<servername>/reports/images/logo.gif
> I've also performed the instructions as per the article "Configuring an
> Account for Unattended Report Process" in the RS BOL. I've also re-started
> IIS, several times yet I still cannot get the logo to show when I view the
> report via the Report Manager.
> If I login to the machine using the account used in the article above, I
> can
> access the URL no problem via IE.
> Any suggestions on what to try next appreciated?
>|||Thanks for replying.
Unfortunately, that didn't work either. Any other ideas?
"Fang Wang (MSFT)" wrote:
> If the image is on the same server as the report, try using folder path
> instead of URL, e.g. "/images/logo.gif".
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> > I've placed a logo I'd like on my reports at the path
> > http://<servername>/reports/images/logo.gif
> >
> > I've also performed the instructions as per the article "Configuring an
> > Account for Unattended Report Process" in the RS BOL. I've also re-started
> > IIS, several times yet I still cannot get the logo to show when I view the
> > report via the Report Manager.
> >
> > If I login to the machine using the account used in the article above, I
> > can
> > access the URL no problem via IE.
> >
> > Any suggestions on what to try next appreciated?
> >
>
>|||Fang meant that you would upload the image as resource directly on the
report server (e.g. through uploading it in report manager) and then
reference the image via a relative path inside the report server. Did you do
this?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
news:69199668-9820-46BA-BCEE-C83708A11C89@.microsoft.com...
> Thanks for replying.
> Unfortunately, that didn't work either. Any other ideas?
> "Fang Wang (MSFT)" wrote:
> > If the image is on the same server as the report, try using folder path
> > instead of URL, e.g. "/images/logo.gif".
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> > news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> > > I've placed a logo I'd like on my reports at the path
> > > http://<servername>/reports/images/logo.gif
> > >
> > > I've also performed the instructions as per the article "Configuring
an
> > > Account for Unattended Report Process" in the RS BOL. I've also
re-started
> > > IIS, several times yet I still cannot get the logo to show when I view
the
> > > report via the Report Manager.
> > >
> > > If I login to the machine using the account used in the article above,
I
> > > can
> > > access the URL no problem via IE.
> > >
> > > Any suggestions on what to try next appreciated?
> > >
> >
> >
> >|||I'm a little confused as to what the relative path is for an image uploaded
via Report Manager. The image itself is in the database so it doesn't follow
the directory hierarchy define in the Report Manager - right? So, if I
upload test.gif to the /MyFolder directory in Report Manager, how would I
access it and what image type (Embedded, Project, Database or Web) would I
select in the Report Designer?
"Robert Bruckner [MSFT]" wrote:
> Fang meant that you would upload the image as resource directly on the
> report server (e.g. through uploading it in report manager) and then
> reference the image via a relative path inside the report server. Did you do
> this?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> news:69199668-9820-46BA-BCEE-C83708A11C89@.microsoft.com...
> > Thanks for replying.
> >
> > Unfortunately, that didn't work either. Any other ideas?
> >
> > "Fang Wang (MSFT)" wrote:
> >
> > > If the image is on the same server as the report, try using folder path
> > > instead of URL, e.g. "/images/logo.gif".
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> > > news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> > > > I've placed a logo I'd like on my reports at the path
> > > > http://<servername>/reports/images/logo.gif
> > > >
> > > > I've also performed the instructions as per the article "Configuring
> an
> > > > Account for Unattended Report Process" in the RS BOL. I've also
> re-started
> > > > IIS, several times yet I still cannot get the logo to show when I view
> the
> > > > report via the Report Manager.
> > > >
> > > > If I login to the machine using the account used in the article above,
> I
> > > > can
> > > > access the URL no problem via IE.
> > > >
> > > > Any suggestions on what to try next appreciated?
> > > >
> > >
> > >
> > >
>
>|||/MyFolder/test.gif would be the correct image path.
If you upload the image through report manager on a report server, then you
won't see it when you just preview a report in report designer. Only after
the report is deployed on the server!
Instead of independently uploading the image resources through report
manager, you may consider looking into so-called "Project Images" which are
contained in the report project and get automatically deployed to a report
server when deploying the entire report project from report designer. See:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_0rz9.asp
You would add the images as project images in the report project and then
reference them as e.g. test.gif in the report without the need to specify a
path. This is because the project images will get deployed in the same
folder as the reports.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kraig Hiersche" <KraigHiersche@.discussions.microsoft.com> wrote in message
news:C8B3451B-639C-4974-B088-1E061481583F@.microsoft.com...
> I'm a little confused as to what the relative path is for an image
uploaded
> via Report Manager. The image itself is in the database so it doesn't
follow
> the directory hierarchy define in the Report Manager - right? So, if I
> upload test.gif to the /MyFolder directory in Report Manager, how would I
> access it and what image type (Embedded, Project, Database or Web) would I
> select in the Report Designer?
> "Robert Bruckner [MSFT]" wrote:
> > Fang meant that you would upload the image as resource directly on the
> > report server (e.g. through uploading it in report manager) and then
> > reference the image via a relative path inside the report server. Did
you do
> > this?
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> > news:69199668-9820-46BA-BCEE-C83708A11C89@.microsoft.com...
> > > Thanks for replying.
> > >
> > > Unfortunately, that didn't work either. Any other ideas?
> > >
> > > "Fang Wang (MSFT)" wrote:
> > >
> > > > If the image is on the same server as the report, try using folder
path
> > > > instead of URL, e.g. "/images/logo.gif".
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in
message
> > > > news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> > > > > I've placed a logo I'd like on my reports at the path
> > > > > http://<servername>/reports/images/logo.gif
> > > > >
> > > > > I've also performed the instructions as per the article
"Configuring
> > an
> > > > > Account for Unattended Report Process" in the RS BOL. I've also
> > re-started
> > > > > IIS, several times yet I still cannot get the logo to show when I
view
> > the
> > > > > report via the Report Manager.
> > > > >
> > > > > If I login to the machine using the account used in the article
above,
> > I
> > > > > can
> > > > > access the URL no problem via IE.
> > > > >
> > > > > Any suggestions on what to try next appreciated?
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||Thanks. I see that you could also reference this image via a browser by
http://<server>/Reportserver?%2fMyFolder%2ftest.gif. But, is there a way to
get the IMG tag generated in the HTML to use this form rather than always
returning a stream ID?
I have existing images in a web environment that I just want to reference in
the image tags. I can't write to our web servers (for security reasons) and
I can't have report parameters visible via "View Source" in the browser (I am
using secure web services to avoid this). The default image tags generated
break our security and privacy policies (report parameters are visible that
have our internal IDs) and if I set streamroot, I still have to deal with
generating an image with the stream ID (which I can't anywhere). Any help
would be much appreciated.
"Robert Bruckner [MSFT]" wrote:
> /MyFolder/test.gif would be the correct image path.
> If you upload the image through report manager on a report server, then you
> won't see it when you just preview a report in report designer. Only after
> the report is deployed on the server!
> Instead of independently uploading the image resources through report
> manager, you may consider looking into so-called "Project Images" which are
> contained in the report project and get automatically deployed to a report
> server when deploying the entire report project from report designer. See:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_0rz9.asp
> You would add the images as project images in the report project and then
> reference them as e.g. test.gif in the report without the need to specify a
> path. This is because the project images will get deployed in the same
> folder as the reports.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Kraig Hiersche" <KraigHiersche@.discussions.microsoft.com> wrote in message
> news:C8B3451B-639C-4974-B088-1E061481583F@.microsoft.com...
> > I'm a little confused as to what the relative path is for an image
> uploaded
> > via Report Manager. The image itself is in the database so it doesn't
> follow
> > the directory hierarchy define in the Report Manager - right? So, if I
> > upload test.gif to the /MyFolder directory in Report Manager, how would I
> > access it and what image type (Embedded, Project, Database or Web) would I
> > select in the Report Designer?
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> > > Fang meant that you would upload the image as resource directly on the
> > > report server (e.g. through uploading it in report manager) and then
> > > reference the image via a relative path inside the report server. Did
> you do
> > > this?
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> > > news:69199668-9820-46BA-BCEE-C83708A11C89@.microsoft.com...
> > > > Thanks for replying.
> > > >
> > > > Unfortunately, that didn't work either. Any other ideas?
> > > >
> > > > "Fang Wang (MSFT)" wrote:
> > > >
> > > > > If the image is on the same server as the report, try using folder
> path
> > > > > instead of URL, e.g. "/images/logo.gif".
> > > > >
> > > > > --
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > > >
> > > > > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in
> message
> > > > > news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> > > > > > I've placed a logo I'd like on my reports at the path
> > > > > > http://<servername>/reports/images/logo.gif
> > > > > >
> > > > > > I've also performed the instructions as per the article
> "Configuring
> > > an
> > > > > > Account for Unattended Report Process" in the RS BOL. I've also
> > > re-started
> > > > > > IIS, several times yet I still cannot get the logo to show when I
> view
> > > the
> > > > > > report via the Report Manager.
> > > > > >
> > > > > > If I login to the machine using the account used in the article
> above,
> > > I
> > > > > > can
> > > > > > access the URL no problem via IE.
> > > > > >
> > > > > > Any suggestions on what to try next appreciated?
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
http://<servername>/reports/images/logo.gif
I've also performed the instructions as per the article "Configuring an
Account for Unattended Report Process" in the RS BOL. I've also re-started
IIS, several times yet I still cannot get the logo to show when I view the
report via the Report Manager.
If I login to the machine using the account used in the article above, I can
access the URL no problem via IE.
Any suggestions on what to try next appreciated?If the image is on the same server as the report, try using folder path
instead of URL, e.g. "/images/logo.gif".
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> I've placed a logo I'd like on my reports at the path
> http://<servername>/reports/images/logo.gif
> I've also performed the instructions as per the article "Configuring an
> Account for Unattended Report Process" in the RS BOL. I've also re-started
> IIS, several times yet I still cannot get the logo to show when I view the
> report via the Report Manager.
> If I login to the machine using the account used in the article above, I
> can
> access the URL no problem via IE.
> Any suggestions on what to try next appreciated?
>|||Thanks for replying.
Unfortunately, that didn't work either. Any other ideas?
"Fang Wang (MSFT)" wrote:
> If the image is on the same server as the report, try using folder path
> instead of URL, e.g. "/images/logo.gif".
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> > I've placed a logo I'd like on my reports at the path
> > http://<servername>/reports/images/logo.gif
> >
> > I've also performed the instructions as per the article "Configuring an
> > Account for Unattended Report Process" in the RS BOL. I've also re-started
> > IIS, several times yet I still cannot get the logo to show when I view the
> > report via the Report Manager.
> >
> > If I login to the machine using the account used in the article above, I
> > can
> > access the URL no problem via IE.
> >
> > Any suggestions on what to try next appreciated?
> >
>
>|||Fang meant that you would upload the image as resource directly on the
report server (e.g. through uploading it in report manager) and then
reference the image via a relative path inside the report server. Did you do
this?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
news:69199668-9820-46BA-BCEE-C83708A11C89@.microsoft.com...
> Thanks for replying.
> Unfortunately, that didn't work either. Any other ideas?
> "Fang Wang (MSFT)" wrote:
> > If the image is on the same server as the report, try using folder path
> > instead of URL, e.g. "/images/logo.gif".
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> > news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> > > I've placed a logo I'd like on my reports at the path
> > > http://<servername>/reports/images/logo.gif
> > >
> > > I've also performed the instructions as per the article "Configuring
an
> > > Account for Unattended Report Process" in the RS BOL. I've also
re-started
> > > IIS, several times yet I still cannot get the logo to show when I view
the
> > > report via the Report Manager.
> > >
> > > If I login to the machine using the account used in the article above,
I
> > > can
> > > access the URL no problem via IE.
> > >
> > > Any suggestions on what to try next appreciated?
> > >
> >
> >
> >|||I'm a little confused as to what the relative path is for an image uploaded
via Report Manager. The image itself is in the database so it doesn't follow
the directory hierarchy define in the Report Manager - right? So, if I
upload test.gif to the /MyFolder directory in Report Manager, how would I
access it and what image type (Embedded, Project, Database or Web) would I
select in the Report Designer?
"Robert Bruckner [MSFT]" wrote:
> Fang meant that you would upload the image as resource directly on the
> report server (e.g. through uploading it in report manager) and then
> reference the image via a relative path inside the report server. Did you do
> this?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> news:69199668-9820-46BA-BCEE-C83708A11C89@.microsoft.com...
> > Thanks for replying.
> >
> > Unfortunately, that didn't work either. Any other ideas?
> >
> > "Fang Wang (MSFT)" wrote:
> >
> > > If the image is on the same server as the report, try using folder path
> > > instead of URL, e.g. "/images/logo.gif".
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> > > news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> > > > I've placed a logo I'd like on my reports at the path
> > > > http://<servername>/reports/images/logo.gif
> > > >
> > > > I've also performed the instructions as per the article "Configuring
> an
> > > > Account for Unattended Report Process" in the RS BOL. I've also
> re-started
> > > > IIS, several times yet I still cannot get the logo to show when I view
> the
> > > > report via the Report Manager.
> > > >
> > > > If I login to the machine using the account used in the article above,
> I
> > > > can
> > > > access the URL no problem via IE.
> > > >
> > > > Any suggestions on what to try next appreciated?
> > > >
> > >
> > >
> > >
>
>|||/MyFolder/test.gif would be the correct image path.
If you upload the image through report manager on a report server, then you
won't see it when you just preview a report in report designer. Only after
the report is deployed on the server!
Instead of independently uploading the image resources through report
manager, you may consider looking into so-called "Project Images" which are
contained in the report project and get automatically deployed to a report
server when deploying the entire report project from report designer. See:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_0rz9.asp
You would add the images as project images in the report project and then
reference them as e.g. test.gif in the report without the need to specify a
path. This is because the project images will get deployed in the same
folder as the reports.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kraig Hiersche" <KraigHiersche@.discussions.microsoft.com> wrote in message
news:C8B3451B-639C-4974-B088-1E061481583F@.microsoft.com...
> I'm a little confused as to what the relative path is for an image
uploaded
> via Report Manager. The image itself is in the database so it doesn't
follow
> the directory hierarchy define in the Report Manager - right? So, if I
> upload test.gif to the /MyFolder directory in Report Manager, how would I
> access it and what image type (Embedded, Project, Database or Web) would I
> select in the Report Designer?
> "Robert Bruckner [MSFT]" wrote:
> > Fang meant that you would upload the image as resource directly on the
> > report server (e.g. through uploading it in report manager) and then
> > reference the image via a relative path inside the report server. Did
you do
> > this?
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> > news:69199668-9820-46BA-BCEE-C83708A11C89@.microsoft.com...
> > > Thanks for replying.
> > >
> > > Unfortunately, that didn't work either. Any other ideas?
> > >
> > > "Fang Wang (MSFT)" wrote:
> > >
> > > > If the image is on the same server as the report, try using folder
path
> > > > instead of URL, e.g. "/images/logo.gif".
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in
message
> > > > news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> > > > > I've placed a logo I'd like on my reports at the path
> > > > > http://<servername>/reports/images/logo.gif
> > > > >
> > > > > I've also performed the instructions as per the article
"Configuring
> > an
> > > > > Account for Unattended Report Process" in the RS BOL. I've also
> > re-started
> > > > > IIS, several times yet I still cannot get the logo to show when I
view
> > the
> > > > > report via the Report Manager.
> > > > >
> > > > > If I login to the machine using the account used in the article
above,
> > I
> > > > > can
> > > > > access the URL no problem via IE.
> > > > >
> > > > > Any suggestions on what to try next appreciated?
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||Thanks. I see that you could also reference this image via a browser by
http://<server>/Reportserver?%2fMyFolder%2ftest.gif. But, is there a way to
get the IMG tag generated in the HTML to use this form rather than always
returning a stream ID?
I have existing images in a web environment that I just want to reference in
the image tags. I can't write to our web servers (for security reasons) and
I can't have report parameters visible via "View Source" in the browser (I am
using secure web services to avoid this). The default image tags generated
break our security and privacy policies (report parameters are visible that
have our internal IDs) and if I set streamroot, I still have to deal with
generating an image with the stream ID (which I can't anywhere). Any help
would be much appreciated.
"Robert Bruckner [MSFT]" wrote:
> /MyFolder/test.gif would be the correct image path.
> If you upload the image through report manager on a report server, then you
> won't see it when you just preview a report in report designer. Only after
> the report is deployed on the server!
> Instead of independently uploading the image resources through report
> manager, you may consider looking into so-called "Project Images" which are
> contained in the report project and get automatically deployed to a report
> server when deploying the entire report project from report designer. See:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_0rz9.asp
> You would add the images as project images in the report project and then
> reference them as e.g. test.gif in the report without the need to specify a
> path. This is because the project images will get deployed in the same
> folder as the reports.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Kraig Hiersche" <KraigHiersche@.discussions.microsoft.com> wrote in message
> news:C8B3451B-639C-4974-B088-1E061481583F@.microsoft.com...
> > I'm a little confused as to what the relative path is for an image
> uploaded
> > via Report Manager. The image itself is in the database so it doesn't
> follow
> > the directory hierarchy define in the Report Manager - right? So, if I
> > upload test.gif to the /MyFolder directory in Report Manager, how would I
> > access it and what image type (Embedded, Project, Database or Web) would I
> > select in the Report Designer?
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> > > Fang meant that you would upload the image as resource directly on the
> > > report server (e.g. through uploading it in report manager) and then
> > > reference the image via a relative path inside the report server. Did
> you do
> > > this?
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> > > news:69199668-9820-46BA-BCEE-C83708A11C89@.microsoft.com...
> > > > Thanks for replying.
> > > >
> > > > Unfortunately, that didn't work either. Any other ideas?
> > > >
> > > > "Fang Wang (MSFT)" wrote:
> > > >
> > > > > If the image is on the same server as the report, try using folder
> path
> > > > > instead of URL, e.g. "/images/logo.gif".
> > > > >
> > > > > --
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > > >
> > > > > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in
> message
> > > > > news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> > > > > > I've placed a logo I'd like on my reports at the path
> > > > > > http://<servername>/reports/images/logo.gif
> > > > > >
> > > > > > I've also performed the instructions as per the article
> "Configuring
> > > an
> > > > > > Account for Unattended Report Process" in the RS BOL. I've also
> > > re-started
> > > > > > IIS, several times yet I still cannot get the logo to show when I
> view
> > > the
> > > > > > report via the Report Manager.
> > > > > >
> > > > > > If I login to the machine using the account used in the article
> above,
> > > I
> > > > > > can
> > > > > > access the URL no problem via IE.
> > > > > >
> > > > > > Any suggestions on what to try next appreciated?
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
Wednesday, March 21, 2012
Extended Stored Procedure problem
Hi,
I made some extended strored procedures
and they goes well when they are placed at
c:\windows\system32 or the same derectory to
sqlservr.exe which is usualy in C:\Program Files\
Microsoft SQL Server\MSSQL\Binn.
I thought it's OK wherever they are placed
as long as I put them to the system path.
But actually they didn't work at all
when they were placed to the other path
that I had newly added as a system path.
Here is the contents of 'path' valiable:
%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\Sy stem32\Wbem;C:\WINDOWS\System32\AmiClick;C:\Progra m Files\Microsoft SQL Server\80\Tools\BINN:C:\Program Files/INC
I just added only "C:\Program Files/INC",
placed the extended stored procedures there,
then called them through a trigger.
Can Somebody tell me what was wrong?
Please help me if you have any informations about this issue.
regards,
Takanobu MaekawaKeep in mind that the forward slash causes all kinds of problems in the NT environment. I would very strongly recommend that you change it to a backslash, which is the NT default path element separator.
-PatP|||Thanks.
I've fixed it now as you said and tried again,
but the problem remains. mm..why??|||Have you enabled the path on SQL server and from where you;re calling this XP.|||Thanks for reply, but I couldn't understand what you meant ...
I just want to put the Extended SPs into the place except system32
or bin directory of SQL Server or the other system directory,
and then run them from the remote hosts.
well,So far,I wonder the problem might be that
the SQL Server uses local system account.(I don't want to change it)
I guess every thing would be OK if I can put the path which I want to add to the local system account's path...but how??
Isn't the system path shared with the local system acount's one?
I'm very confused.
Is there some one who had a problem like me and solved it?
If you know any informations about this issue,please tell me too.
regards.|||ENsure the path is set on the server not on the local client machine.|||Originally posted by Satya
ENsure the path is set on the server not on the local client machine.
Yes, I'm sure that the path is set on the server's system path, not the client's one ...|||Can you post the error generated while working with this XP.|||well, here is the result of running one of XPs
through the Query Analyzer.
----------------------
<R_DB_T_KANJA>Jn 03 17 2004 10:36AM
R_MQ_T_BEDKANJALINK Jn 17 03 2004 10:36:27:390
R_MQ_T_BEDKANJALINK I 17 03 2004 10:36:27:390
R_MQ_T_BEDKANJALINK Jn 17 03 2004 10:36:27:403
R_MQ_T_BEDKANJALINK I 17 03 2004 10:36:27:403
R_MQ_T_BEDKANJALINK Jn 17 03 2004 10:36:27:403
R_MQ_T_BEDKANJALINK I 17 03 2004 10:36:27:403
R_MQ_T_BEDKANJALINK Jn 17 03 2004 10:36:27:403
R_MQ_T_BEDKANJALINK I 17 03 2004 10:36:27:403
R_MQ_T_BEDKANJALINK Jn 17 03 2004 10:36:27:403
R_MQ_T_BEDKANJALINK I 17 03 2004 10:36:27:403
R_MQ_T_BEDKANJALINK Jn 17 03 2004 10:36:27:403
R_MQ_T_BEDKANJALINK I 17 03 2004 10:36:27:403
<R_DB_T_KANJA>I 03 17 2004 10:36AM
<R_DB_T_KANJA2>I 03 17 2004 10:36AM
R_MQ_T_KANJA<UPDATE> Jn 17 03 2004 10:36:27:967
ODBC: bZ[W 0Ax 16A 1
DLL INC_MNSQL.dll [h??AQ?? DLL 1 ?[h??BR : 126(w肳?W[??B)B
R_MQ_T_KANJA<UPDATE> @.lSeqNum=1 @.nByotoCode=21
R_MQ_T_KANJA<UPDATE> (?ID 1005)XV?B @.Old_bytSex=1 @.New_bytSex =0 (NULL -> 0)
(1 ?)
R_MQ_T_KANJA<UPDATE> I 17 03 2004 10:36:28:060
------------------------
As you see, the localization of SQL Server is set to Japanese.
Should I translate the messages into English?
'R_DB_ ...' are output of print function in triggers.
XP is called from them.
The DLL the XP is written is INC_MNSQL.dll.
The error said the DLL can not be loaded.|||Based upon the last link of your reply, I feel this KBA http://support.microsoft.com/default.aspx?scid=kb;en-us;Q151596 may be suitable to resolve.
HTH|||Can you put the XP DLL into the SQL binary directory (by default, C:\Program Files\Microsoft SQL Server\Mssql\Binn although that can be changed at installation time) and have them work correctly? Did you by any chance specify a pathname when you called sp_addextendedproc (which is a bad thing)?
-PatP|||Finally, I've solved this problem.
I don't know this is the essential solution for this problem,
but today, once I rebooted the Server machine
(it's been long time --at least 2 months since I rebooted the server machine last time),then the system path which I added began to work well !!
I made some extended strored procedures
and they goes well when they are placed at
c:\windows\system32 or the same derectory to
sqlservr.exe which is usualy in C:\Program Files\
Microsoft SQL Server\MSSQL\Binn.
I thought it's OK wherever they are placed
as long as I put them to the system path.
But actually they didn't work at all
when they were placed to the other path
that I had newly added as a system path.
Here is the contents of 'path' valiable:
%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\Sy stem32\Wbem;C:\WINDOWS\System32\AmiClick;C:\Progra m Files\Microsoft SQL Server\80\Tools\BINN:C:\Program Files/INC
I just added only "C:\Program Files/INC",
placed the extended stored procedures there,
then called them through a trigger.
Can Somebody tell me what was wrong?
Please help me if you have any informations about this issue.
regards,
Takanobu MaekawaKeep in mind that the forward slash causes all kinds of problems in the NT environment. I would very strongly recommend that you change it to a backslash, which is the NT default path element separator.
-PatP|||Thanks.
I've fixed it now as you said and tried again,
but the problem remains. mm..why??|||Have you enabled the path on SQL server and from where you;re calling this XP.|||Thanks for reply, but I couldn't understand what you meant ...
I just want to put the Extended SPs into the place except system32
or bin directory of SQL Server or the other system directory,
and then run them from the remote hosts.
well,So far,I wonder the problem might be that
the SQL Server uses local system account.(I don't want to change it)
I guess every thing would be OK if I can put the path which I want to add to the local system account's path...but how??
Isn't the system path shared with the local system acount's one?
I'm very confused.
Is there some one who had a problem like me and solved it?
If you know any informations about this issue,please tell me too.
regards.|||ENsure the path is set on the server not on the local client machine.|||Originally posted by Satya
ENsure the path is set on the server not on the local client machine.
Yes, I'm sure that the path is set on the server's system path, not the client's one ...|||Can you post the error generated while working with this XP.|||well, here is the result of running one of XPs
through the Query Analyzer.
----------------------
<R_DB_T_KANJA>Jn 03 17 2004 10:36AM
R_MQ_T_BEDKANJALINK Jn 17 03 2004 10:36:27:390
R_MQ_T_BEDKANJALINK I 17 03 2004 10:36:27:390
R_MQ_T_BEDKANJALINK Jn 17 03 2004 10:36:27:403
R_MQ_T_BEDKANJALINK I 17 03 2004 10:36:27:403
R_MQ_T_BEDKANJALINK Jn 17 03 2004 10:36:27:403
R_MQ_T_BEDKANJALINK I 17 03 2004 10:36:27:403
R_MQ_T_BEDKANJALINK Jn 17 03 2004 10:36:27:403
R_MQ_T_BEDKANJALINK I 17 03 2004 10:36:27:403
R_MQ_T_BEDKANJALINK Jn 17 03 2004 10:36:27:403
R_MQ_T_BEDKANJALINK I 17 03 2004 10:36:27:403
R_MQ_T_BEDKANJALINK Jn 17 03 2004 10:36:27:403
R_MQ_T_BEDKANJALINK I 17 03 2004 10:36:27:403
<R_DB_T_KANJA>I 03 17 2004 10:36AM
<R_DB_T_KANJA2>I 03 17 2004 10:36AM
R_MQ_T_KANJA<UPDATE> Jn 17 03 2004 10:36:27:967
ODBC: bZ[W 0Ax 16A 1
DLL INC_MNSQL.dll [h??AQ?? DLL 1 ?[h??BR : 126(w肳?W[??B)B
R_MQ_T_KANJA<UPDATE> @.lSeqNum=1 @.nByotoCode=21
R_MQ_T_KANJA<UPDATE> (?ID 1005)XV?B @.Old_bytSex=1 @.New_bytSex =0 (NULL -> 0)
(1 ?)
R_MQ_T_KANJA<UPDATE> I 17 03 2004 10:36:28:060
------------------------
As you see, the localization of SQL Server is set to Japanese.
Should I translate the messages into English?
'R_DB_ ...' are output of print function in triggers.
XP is called from them.
The DLL the XP is written is INC_MNSQL.dll.
The error said the DLL can not be loaded.|||Based upon the last link of your reply, I feel this KBA http://support.microsoft.com/default.aspx?scid=kb;en-us;Q151596 may be suitable to resolve.
HTH|||Can you put the XP DLL into the SQL binary directory (by default, C:\Program Files\Microsoft SQL Server\Mssql\Binn although that can be changed at installation time) and have them work correctly? Did you by any chance specify a pathname when you called sp_addextendedproc (which is a bad thing)?
-PatP|||Finally, I've solved this problem.
I don't know this is the essential solution for this problem,
but today, once I rebooted the Server machine
(it's been long time --at least 2 months since I rebooted the server machine last time),then the system path which I added began to work well !!
Subscribe to:
Posts (Atom)