Good afternoon SQL dudes
Does anyone have any experience of extracting data from IBM's UniData (http://en.wikipedia.org/wiki/UniData) (or any post-relational\ Pick\ nested relational\ multi-valued relational database) into a SQL Server?
More info here (http://www.rpbourret.com/xml/ProdsXMLEnabled.htm), here (http://www.pick-ware.co.uk/) and here (http://en.wikipedia.org/wiki/Pick_operating_system)
I don't (which is why I am asking) but I could imagine it being a right bugger. No need for detailed or technical info - I have no more info at this stage - just wondered if anyone has any similar experience.
Super duper, thank you SQL troopers :)Probably gonna show my age now :/ its been a while since i have done anything in Pick (over 10 years)
If tools dont already exist to do the export the easies way would be to write a small program in PickBasic that just displayed the data to screen, and a small app that runs on the PC that initates the Pick Program, and then just captures to output to a file (from what i remember alot of pc based terminal emulation programs already do that)
Just remember to calculate a checksum for the data, then re-calculate it from the captured files.
If its UniData then there are ODBC drivers available that will let you connect to the data directly.
Sorry cant be more helpfull, its been a while since i have used that technology, although i must admit, i loved working in that environment xD|||Thanks Mark - appreciated.
Checksum is a good idea.
Showing posts with label http. Show all posts
Showing posts with label http. Show all posts
Thursday, March 29, 2012
Tuesday, March 27, 2012
Externally Accessing localmachine to view reports
How is it possible for others to browse to my localmachine and view the reports?
They tried browsing to http://machinename/reports
and http://10.1.3.123/reports
But the message the users get is: You are not authorized to view this page.
Then In my localmachine, I changed the IIS setting for the Reports and ReportServer to allow anonymous access. Then the users were able to see the Home page of the reports but not the reports themselves to click on for viewing. Any thoughts please?
Thanks
Have you created role assignments for the remote users?
http://msdn2.microsoft.com/en-us/library/aa337491.aspx
When you enable Anonymous, everyone coming into the Report Server looks like the same user (the anonymous user), but you still need to give the anonymous user RS permissions, but then everyone has those permissions, and you probably don't want that.
Monday, March 26, 2012
External Image Problems
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?
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?
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?
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
Monday, March 12, 2012
Extended Events (XEvent) in Katmai
In this blog posting: http://blogs.msdn.com/tvoellm/archive/2007/08/02/check-out-xevent-in-sql-2008-ctp2.aspx Extended Events are mentioned. The author says that the documentation has lots of examples. I can't find them. I would be grateful to anyone who can tell me exactly where they are.
Thanks.
This needs to be posted in the Katmai forum instead of here; hang on and I'll see if I can move it.
|||Thanks for moving the post - I didn't know there were dedicated Katmai forums.
I found some of what I'm looking for in SQL Server 2008 Books Online->Database Engine->Operations->Monitoring->SQL Server Extended Events.
I would appreciate any other pointers.
Thanks again.
|||I suspect that what is in Books Online is the only content available at this point. The How-to topics in the Books Online section you reference do contain quite a few examples. If you have specific questions, I recommend posting them in the SQL Server Katmai Manageability & Tools or SQL Server Katmai Database Engine forums.
Also, I strongly encourage you to click the Feedback button on any of the extended event Books Online topics and provide comments/suggestions for those topics that need more details or examples. You may or may not get a direct response from the writer, but the writer will receive your comments in the form of a documentation bug. We rely on customer feedback to know which topics need to be improved.
Regards,
Gail
|||Check out the Books Online for the examples...
http://connect.microsoft.com/SQLServer/Downloads/DownloadDetails.aspx?DownloadID=7460
Extended Events (XEvent) in Katmai
In this blog posting: http://blogs.msdn.com/tvoellm/archive/2007/08/02/check-out-xevent-in-sql-2008-ctp2.aspx Extended Events are mentioned. The author says that the documentation has lots of examples. I can't find them. I would be grateful to anyone who can tell me exactly where they are.
Thanks.
This needs to be posted in the Katmai forum instead of here; hang on and I'll see if I can move it.
|||Thanks for moving the post - I didn't know there were dedicated Katmai forums.
I found some of what I'm looking for in SQL Server 2008 Books Online->Database Engine->Operations->Monitoring->SQL Server Extended Events.
I would appreciate any other pointers.
Thanks again.
|||I suspect that what is in Books Online is the only content available at this point. The How-to topics in the Books Online section you reference do contain quite a few examples. If you have specific questions, I recommend posting them in the SQL Server Katmai Manageability & Tools or SQL Server Katmai Database Engine forums.
Also, I strongly encourage you to click the Feedback button on any of the extended event Books Online topics and provide comments/suggestions for those topics that need more details or examples. You may or may not get a direct response from the writer, but the writer will receive your comments in the form of a documentation bug. We rely on customer feedback to know which topics need to be improved.
Regards,
Gail
|||Check out the Books Online for the examples...
http://connect.microsoft.com/SQLServer/Downloads/DownloadDetails.aspx?DownloadID=7460
Expressions still get evaluated even though the task isn't executed
Whilst investigating the problem talked about here: http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=118141
I noticed something quite strange.
I noticed something quite strange.
The symptom of whatever problem we are having (we don't know yet) is that some property expressions fail to get evaluated and cause the package to fail. ALL of these property expressions are in package-scoped eventhandlers.
Now, if I set DisableEventHandlers=TRUE on the package container the problems still occur. If I completely delete the eventhandlers the problem goes away.
So, it seems to me that even though DisableEventHandlers=TRUE, the property expressions within those eventhandlers are still evaluated.
Why is that? Its pointless to evaluate property expressions if they are not going to be used - it means the package is doing unnecassary work.
-JamieAny comments?|||Jamie! So sorry - I review every couple days and just found this. Let me see what I can find out for you.
hold tight.
Andrea|||cool. Thanks Andrea.
Sunday, February 26, 2012
Express and Reporting Services
Hi,
This thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=179557&SiteID=1 says that Express will have Reporting Services enabled such that reports can be created in Express edition. I have just downloaded Express Edition with Advanced Services but i dont appear to have any of the tools neccessary to create a report using reporting services. ( I do have VS 2005)
Also this URL http://msdn.microsoft.com/vstudio/express/ promotes Express as having Reporting Services and yet this table http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx says just the server is installed.
Can anyone please clarify if I just haven't installed or activated the required functionality to build reports using Express edition or whether there is no such capability with Express edition.
If the latter is the case does this mean that I can still run applications and reporting services reports with Express edition? In other words if I buy standard edition to develop reports, can my customers run my application (i.e reports) with Express edition or do they have to purchase standard edition as well?
Richard
Hi S-Bob
You can dowload the report designer and management studio express with the express edition toolkit:
http://www.microsoft.com/downloads/details.aspx?FamilyID=3c856b93-369f-4c6f-9357-c35384179543&DisplayLang=en
You can create reports using standard edition or the toolkit and consumers using express advanced can view them. Note that express has some limitations such as supporting local data sources only.
-JonHP
Subscribe to:
Posts (Atom)