Pulling RS Report into online application

I've got an online application (written in Cold Fusion) that I would like to
be able to pull in a report generated in RS. Currently, I can call the
report directly from the application using an HTTP "get", pass in the url
string with "rs:Format=PDF", save the resulting PDF file on my server, then
render that PDF file in my cold fusion application.
What I would LIKE to do is render the report in HTML format in my
application. The problem is, the report has a couple of graphs in it, and
the resulting HTML that is generated does not know where to find the graph
images.
Is there anyway to capture the resulting HTML that is generated from the
Report Server in such a way that it can be run in another online web
application (running on the same server as the RS), and yet be able to
correctly fetch the generated graphical images?
I hope this makes sense.
TIA,
BrianYour cold fusion app should be the same as viewing the report directly in
the browser itself unless I'm mistaken. Where does it think the graphic
images are? RS puts the img src to be the GUID of the image from the Report
Server. I'm just wondering where your web page thinks the image exists.
Tom
This posting is provided "AS IS" with no warranties, and confers no rights.
"G" <brian.grant@.si-intl-kc.com> wrote in message
news:OpKlO72XEHA.2344@.TK2MSFTNGP11.phx.gbl...
> I've got an online application (written in Cold Fusion) that I would like
to
> be able to pull in a report generated in RS. Currently, I can call the
> report directly from the application using an HTTP "get", pass in the url
> string with "rs:Format=PDF", save the resulting PDF file on my server,
then
> render that PDF file in my cold fusion application.
> What I would LIKE to do is render the report in HTML format in my
> application. The problem is, the report has a couple of graphs in it, and
> the resulting HTML that is generated does not know where to find the graph
> images.
> Is there anyway to capture the resulting HTML that is generated from the
> Report Server in such a way that it can be run in another online web
> application (running on the same server as the RS), and yet be able to
> correctly fetch the generated graphical images?
> I hope this makes sense.
> TIA,
> Brian
>|||Thanks for your response Tom.
Using the <CFHTTP> "get", i'm able to capture the HTML generated for the
report by the RS. Embedded in the HTML is the following <img> tag which is
trying to load the graph:
<IMG
SRC="pathToReportServer?/pathToReport&Year=2004&rs:Format=HTML3.2&rs:ImageID
=C_4_S&rs:ChartImg="/>
When my application calls the HTML page, it is unable to load this image.
This is kind of a strange situation because i'm trying to load the graphical
image that the RS generated when i initially called the report a few seconds
ago using CFHTTP. The problem is, that report was called with certain
parameters causing that particular instance of the report to be generated
with that particular instance of the graph.
What I'm trying to do here might not be possible.
Brian
"Tom Rizzo [MSFT]" <thomriz@.microsoft.com> wrote in message
news:ubA4CB4XEHA.1128@.TK2MSFTNGP10.phx.gbl...
> Your cold fusion app should be the same as viewing the report directly in
> the browser itself unless I'm mistaken. Where does it think the graphic
> images are? RS puts the img src to be the GUID of the image from the
Report
> Server. I'm just wondering where your web page thinks the image exists.
> Tom
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "G" <brian.grant@.si-intl-kc.com> wrote in message
> news:OpKlO72XEHA.2344@.TK2MSFTNGP11.phx.gbl...
> > I've got an online application (written in Cold Fusion) that I would
like
> to
> > be able to pull in a report generated in RS. Currently, I can call the
> > report directly from the application using an HTTP "get", pass in the
url
> > string with "rs:Format=PDF", save the resulting PDF file on my server,
> then
> > render that PDF file in my cold fusion application.
> >
> > What I would LIKE to do is render the report in HTML format in my
> > application. The problem is, the report has a couple of graphs in it,
and
> > the resulting HTML that is generated does not know where to find the
graph
> > images.
> >
> > Is there anyway to capture the resulting HTML that is generated from the
> > Report Server in such a way that it can be run in another online web
> > application (running on the same server as the RS), and yet be able to
> > correctly fetch the generated graphical images?
> >
> > I hope this makes sense.
> >
> > TIA,
> >
> > Brian
> >
> >
>|||I don't know that much about CF so as you say, it may not be possible since
it may be a level of indirection that CF applies to the get. One other
option that you could possibly do is create an IFRAME in your CF app that
links directly to your report via the URL.
Tom
This posting is provided "AS IS" with no warranties, and confers no rights.
"G" <brian.grant@.si-intl-kc.com> wrote in message
news:O0EWee4XEHA.2868@.TK2MSFTNGP09.phx.gbl...
> Thanks for your response Tom.
> Using the <CFHTTP> "get", i'm able to capture the HTML generated for the
> report by the RS. Embedded in the HTML is the following <img> tag which is
> trying to load the graph:
> <IMG
>
SRC="pathToReportServer?/pathToReport&Year=2004&rs:Format=HTML3.2&rs:ImageID
> =C_4_S&rs:ChartImg="/>
> When my application calls the HTML page, it is unable to load this image.
> This is kind of a strange situation because i'm trying to load the
graphical
> image that the RS generated when i initially called the report a few
seconds
> ago using CFHTTP. The problem is, that report was called with certain
> parameters causing that particular instance of the report to be generated
> with that particular instance of the graph.
> What I'm trying to do here might not be possible.
> Brian
> "Tom Rizzo [MSFT]" <thomriz@.microsoft.com> wrote in message
> news:ubA4CB4XEHA.1128@.TK2MSFTNGP10.phx.gbl...
> > Your cold fusion app should be the same as viewing the report directly
in
> > the browser itself unless I'm mistaken. Where does it think the graphic
> > images are? RS puts the img src to be the GUID of the image from the
> Report
> > Server. I'm just wondering where your web page thinks the image exists.
> >
> > Tom
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> >
> > "G" <brian.grant@.si-intl-kc.com> wrote in message
> > news:OpKlO72XEHA.2344@.TK2MSFTNGP11.phx.gbl...
> > > I've got an online application (written in Cold Fusion) that I would
> like
> > to
> > > be able to pull in a report generated in RS. Currently, I can call the
> > > report directly from the application using an HTTP "get", pass in the
> url
> > > string with "rs:Format=PDF", save the resulting PDF file on my server,
> > then
> > > render that PDF file in my cold fusion application.
> > >
> > > What I would LIKE to do is render the report in HTML format in my
> > > application. The problem is, the report has a couple of graphs in it,
> and
> > > the resulting HTML that is generated does not know where to find the
> graph
> > > images.
> > >
> > > Is there anyway to capture the resulting HTML that is generated from
the
> > > Report Server in such a way that it can be run in another online web
> > > application (running on the same server as the RS), and yet be able to
> > > correctly fetch the generated graphical images?
> > >
> > > I hope this makes sense.
> > >
> > > TIA,
> > >
> > > Brian
> > >
> > >
> >
> >
>|||Ok, i researched IFRAMES. I used the following line to pull my report into
the browser:
<IFRAME scrolling="Yes" frameborder="0" height="100%" width="100%"
NAME="Frame1" src="http://pics.10026.com/?src=pathToMyReportWithParameters" ALLOWTRANSPARENCY="true">
The browser rendered my report, even displayed the little spinning
"Generating Report". But alas, the graphs are still missing. Any ideas?
"Tom Rizzo [MSFT]" <thomriz@.microsoft.com> wrote in message
news:%23liwlz6XEHA.2816@.TK2MSFTNGP11.phx.gbl...
> I don't know that much about CF so as you say, it may not be possible
since
> it may be a level of indirection that CF applies to the get. One other
> option that you could possibly do is create an IFRAME in your CF app that
> links directly to your report via the URL.
> Tom
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "G" <brian.grant@.si-intl-kc.com> wrote in message
> news:O0EWee4XEHA.2868@.TK2MSFTNGP09.phx.gbl...
> > Thanks for your response Tom.
> >
> > Using the <CFHTTP> "get", i'm able to capture the HTML generated for the
> > report by the RS. Embedded in the HTML is the following <img> tag which
is
> > trying to load the graph:
> >
> > <IMG
> >
>
SRC="pathToReportServer?/pathToReport&Year=2004&rs:Format=HTML3.2&rs:ImageID
> > =C_4_S&rs:ChartImg="/>
> >
> > When my application calls the HTML page, it is unable to load this
image.
> > This is kind of a strange situation because i'm trying to load the
> graphical
> > image that the RS generated when i initially called the report a few
> seconds
> > ago using CFHTTP. The problem is, that report was called with certain
> > parameters causing that particular instance of the report to be
generated
> > with that particular instance of the graph.
> >
> > What I'm trying to do here might not be possible.
> >
> > Brian
> >
> > "Tom Rizzo [MSFT]" <thomriz@.microsoft.com> wrote in message
> > news:ubA4CB4XEHA.1128@.TK2MSFTNGP10.phx.gbl...
> > > Your cold fusion app should be the same as viewing the report directly
> in
> > > the browser itself unless I'm mistaken. Where does it think the
graphic
> > > images are? RS puts the img src to be the GUID of the image from the
> > Report
> > > Server. I'm just wondering where your web page thinks the image
exists.
> > >
> > > Tom
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > >
> > >
> > > "G" <brian.grant@.si-intl-kc.com> wrote in message
> > > news:OpKlO72XEHA.2344@.TK2MSFTNGP11.phx.gbl...
> > > > I've got an online application (written in Cold Fusion) that I would
> > like
> > > to
> > > > be able to pull in a report generated in RS. Currently, I can call
the
> > > > report directly from the application using an HTTP "get", pass in
the
> > url
> > > > string with "rs:Format=PDF", save the resulting PDF file on my
server,
> > > then
> > > > render that PDF file in my cold fusion application.
> > > >
> > > > What I would LIKE to do is render the report in HTML format in my
> > > > application. The problem is, the report has a couple of graphs in
it,
> > and
> > > > the resulting HTML that is generated does not know where to find the
> > graph
> > > > images.
> > > >
> > > > Is there anyway to capture the resulting HTML that is generated from
> the
> > > > Report Server in such a way that it can be run in another online web
> > > > application (running on the same server as the RS), and yet be able
to
> > > > correctly fetch the generated graphical images?
> > > >
> > > > I hope this makes sense.
> > > >
> > > > TIA,
> > > >
> > > > Brian
> > > >
> > > >
> > >
> > >
> >
> >
>|||As I said in a previous post, I too cannot get images out a HTML.
I'm using the web service to spit out the HTML which I stream out to the user.
The IMG_SRC has someting in it similar to what you report, which doesn't result in an image coming out.
Matt
"G" wrote:
> Ok, i researched IFRAMES. I used the following line to pull my report into
> the browser:
> <IFRAME scrolling="Yes" frameborder="0" height="100%" width="100%"
> NAME="Frame1" src="http://pics.10026.com/?src=pathToMyReportWithParameters" ALLOWTRANSPARENCY="true">
> The browser rendered my report, even displayed the little spinning
> "Generating Report". But alas, the graphs are still missing. Any ideas?
>
> "Tom Rizzo [MSFT]" <thomriz@.microsoft.com> wrote in message
> news:%23liwlz6XEHA.2816@.TK2MSFTNGP11.phx.gbl...
> > I don't know that much about CF so as you say, it may not be possible
> since
> > it may be a level of indirection that CF applies to the get. One other
> > option that you could possibly do is create an IFRAME in your CF app that
> > links directly to your report via the URL.
> >
> > Tom
> >
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> >
> > "G" <brian.grant@.si-intl-kc.com> wrote in message
> > news:O0EWee4XEHA.2868@.TK2MSFTNGP09.phx.gbl...
> > > Thanks for your response Tom.
> > >
> > > Using the <CFHTTP> "get", i'm able to capture the HTML generated for the
> > > report by the RS. Embedded in the HTML is the following <img> tag which
> is
> > > trying to load the graph:
> > >
> > > <IMG
> > >
> >
> src="http://pics.10026.com/?src=pathToReportServer?/pathToReport&Year=2004&rs:Format=HTML3.2&rs:ImageID
> > > =C_4_S&rs:ChartImg="/>
> > >
> > > When my application calls the HTML page, it is unable to load this
> image.
> > > This is kind of a strange situation because i'm trying to load the
> > graphical
> > > image that the RS generated when i initially called the report a few
> > seconds
> > > ago using CFHTTP. The problem is, that report was called with certain
> > > parameters causing that particular instance of the report to be
> generated
> > > with that particular instance of the graph.
> > >
> > > What I'm trying to do here might not be possible.
> > >
> > > Brian
> > >
> > > "Tom Rizzo [MSFT]" <thomriz@.microsoft.com> wrote in message
> > > news:ubA4CB4XEHA.1128@.TK2MSFTNGP10.phx.gbl...
> > > > Your cold fusion app should be the same as viewing the report directly
> > in
> > > > the browser itself unless I'm mistaken. Where does it think the
> graphic
> > > > images are? RS puts the img src to be the GUID of the image from the
> > > Report
> > > > Server. I'm just wondering where your web page thinks the image
> exists.
> > > >
> > > > Tom
> > > >
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > >
> > > >
> > > >
> > > > "G" <brian.grant@.si-intl-kc.com> wrote in message
> > > > news:OpKlO72XEHA.2344@.TK2MSFTNGP11.phx.gbl...
> > > > > I've got an online application (written in Cold Fusion) that I would
> > > like
> > > > to
> > > > > be able to pull in a report generated in RS. Currently, I can call
> the
> > > > > report directly from the application using an HTTP "get", pass in
> the
> > > url
> > > > > string with "rs:Format=PDF", save the resulting PDF file on my
> server,
> > > > then
> > > > > render that PDF file in my cold fusion application.
> > > > >
> > > > > What I would LIKE to do is render the report in HTML format in my
> > > > > application. The problem is, the report has a couple of graphs in
> it,
> > > and
> > > > > the resulting HTML that is generated does not know where to find the
> > > graph
> > > > > images.
> > > > >
> > > > > Is there anyway to capture the resulting HTML that is generated from
> > the
> > > > > Report Server in such a way that it can be run in another online web
> > > > > application (running on the same server as the RS), and yet be able
> to
> > > > > correctly fetch the generated graphical images?
> > > > >
> > > > > I hope this makes sense.
> > > > >
> > > > > TIA,
> > > > >
> > > > > Brian
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>|||Take a look at this sample from books online
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_49f6.asp
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"G" <brian.grant@.si-intl-kc.com> wrote in message
news:O0EWee4XEHA.2868@.TK2MSFTNGP09.phx.gbl...
> Thanks for your response Tom.
> Using the <CFHTTP> "get", i'm able to capture the HTML generated for the
> report by the RS. Embedded in the HTML is the following <img> tag which is
> trying to load the graph:
> <IMG
>
SRC="pathToReportServer?/pathToReport&Year=2004&rs:Format=HTML3.2&rs:ImageID
> =C_4_S&rs:ChartImg="/>
> When my application calls the HTML page, it is unable to load this image.
> This is kind of a strange situation because i'm trying to load the
graphical
> image that the RS generated when i initially called the report a few
seconds
> ago using CFHTTP. The problem is, that report was called with certain
> parameters causing that particular instance of the report to be generated
> with that particular instance of the graph.
> What I'm trying to do here might not be possible.
> Brian
> "Tom Rizzo [MSFT]" <thomriz@.microsoft.com> wrote in message
> news:ubA4CB4XEHA.1128@.TK2MSFTNGP10.phx.gbl...
> > Your cold fusion app should be the same as viewing the report directly
in
> > the browser itself unless I'm mistaken. Where does it think the graphic
> > images are? RS puts the img src to be the GUID of the image from the
> Report
> > Server. I'm just wondering where your web page thinks the image exists.
> >
> > Tom
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> >
> > "G" <brian.grant@.si-intl-kc.com> wrote in message
> > news:OpKlO72XEHA.2344@.TK2MSFTNGP11.phx.gbl...
> > > I've got an online application (written in Cold Fusion) that I would
> like
> > to
> > > be able to pull in a report generated in RS. Currently, I can call the
> > > report directly from the application using an HTTP "get", pass in the
> url
> > > string with "rs:Format=PDF", save the resulting PDF file on my server,
> > then
> > > render that PDF file in my cold fusion application.
> > >
> > > What I would LIKE to do is render the report in HTML format in my
> > > application. The problem is, the report has a couple of graphs in it,
> and
> > > the resulting HTML that is generated does not know where to find the
> graph
> > > images.
> > >
> > > Is there anyway to capture the resulting HTML that is generated from
the
> > > Report Server in such a way that it can be run in another online web
> > > application (running on the same server as the RS), and yet be able to
> > > correctly fetch the generated graphical images?
> > >
> > > I hope this makes sense.
> > >
> > > TIA,
> > >
> > > Brian
> > >
> > >
> >
> >
>|||Yes, you are responsible to managing the images. Since the end user is not
talking directly to the Report Server, the server doesn't know when the
session is no longer valid.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matt P" <MattP@.discussions.microsoft.com> wrote in message
news:32316ADD-BD93-496A-9261-D6D92C96EDC4@.microsoft.com...
> Thanks. After much fiddling with paths I managed to solve the problem.
> Things I had to do additionally/differently to the BOL online article
> were:
> - pass in the same parameters as to the Render method
> - path in a full path in the StreamRoot parameter.
> EG \\the-host-name\Collaborators\BXYZDevtMain\ManagementReports\
> The help is most unclear in this respect. To my readin git meant that
> that was where the images are being read from on the report server. No -
> its the path on the web server to where I am to have copied the images in
> the manner indicated by the BOL code. And unless it's in a format I've
> shown above it's completely ignored, and the full 'gibberish' URL put as
> the IMG SRC - with all the parameters etc.
>
> Am I responsible for deleting the image files after a certain time?
> thanks
> Matt
>
> "Tudor Trufinescu (MSFT)" wrote:
>> Take a look at this sample from books online
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_49f6.asp
>> --
>> Tudor Trufinescu
>> Dev Lead
>> Sql Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "G" <brian.grant@.si-intl-kc.com> wrote in message
>> news:O0EWee4XEHA.2868@.TK2MSFTNGP09.phx.gbl...
>> > Thanks for your response Tom.
>> >
>> > Using the <CFHTTP> "get", i'm able to capture the HTML generated for
>> > the
>> > report by the RS. Embedded in the HTML is the following <img> tag which
>> > is
>> > trying to load the graph:
>> >
>> > <IMG
>> >
>> src="http://pics.10026.com/?src=pathToReportServer?/pathToReport&Year=2004&rs:Format=HTML3.2&rs:ImageID
>> > =C_4_S&rs:ChartImg="/>
>> >
>> > When my application calls the HTML page, it is unable to load this
>> > image.
>> > This is kind of a strange situation because i'm trying to load the
>> graphical
>> > image that the RS generated when i initially called the report a few
>> seconds
>> > ago using CFHTTP. The problem is, that report was called with certain
>> > parameters causing that particular instance of the report to be
>> > generated
>> > with that particular instance of the graph.
>> >
>> > What I'm trying to do here might not be possible.
>> >
>> > Brian
>> >
>> > "Tom Rizzo [MSFT]" <thomriz@.microsoft.com> wrote in message
>> > news:ubA4CB4XEHA.1128@.TK2MSFTNGP10.phx.gbl...
>> > > Your cold fusion app should be the same as viewing the report
>> > > directly
>> in
>> > > the browser itself unless I'm mistaken. Where does it think the
>> > > graphic
>> > > images are? RS puts the img src to be the GUID of the image from the
>> > Report
>> > > Server. I'm just wondering where your web page thinks the image
>> > > exists.
>> > >
>> > > Tom
>> > >
>> > > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> > >
>> > >
>> > >
>> > > "G" <brian.grant@.si-intl-kc.com> wrote in message
>> > > news:OpKlO72XEHA.2344@.TK2MSFTNGP11.phx.gbl...
>> > > > I've got an online application (written in Cold Fusion) that I
>> > > > would
>> > like
>> > > to
>> > > > be able to pull in a report generated in RS. Currently, I can call
>> > > > the
>> > > > report directly from the application using an HTTP "get", pass in
>> > > > the
>> > url
>> > > > string with "rs:Format=PDF", save the resulting PDF file on my
>> > > > server,
>> > > then
>> > > > render that PDF file in my cold fusion application.
>> > > >
>> > > > What I would LIKE to do is render the report in HTML format in my
>> > > > application. The problem is, the report has a couple of graphs in
>> > > > it,
>> > and
>> > > > the resulting HTML that is generated does not know where to find
>> > > > the
>> > graph
>> > > > images.
>> > > >
>> > > > Is there anyway to capture the resulting HTML that is generated
>> > > > from
>> the
>> > > > Report Server in such a way that it can be run in another online
>> > > > web
>> > > > application (running on the same server as the RS), and yet be able
>> > > > to
>> > > > correctly fetch the generated graphical images?
>> > > >
>> > > > I hope this makes sense.
>> > > >
>> > > > TIA,
>> > > >
>> > > > Brian
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>>