It's all about the answers!

Ask a question

Automatically publishing reports to a webstie


0
1
Michael Baylis (1832719) | asked Dec 16 '08, 8:42 a.m.
Hi,
After the datawarehouse jobs are complete, would it be possible to publish a selected set of RTC reports to a website? We would like the bar chart to be made available to everyone, not just those that have a signon to our RTC server. Could we a) put a uri link on the remote page that will acquire the report jpg, b) run a client java program as a build job that will run the report and store the resulting jpg directlly in the website filesystem or c) some other clever method.

Cheers,

Michael Baylis
CICS TS System Tester
IBM Hursley

3 answers



permanent link
James Moody (3.3k24) | answered Dec 16 '08, 9:58 a.m.
JAZZ DEVELOPER
michaelbaylis wrote:
Hi,
After the datawarehouse jobs are complete, would it be possible to
publish a selected set of RTC reports to a website? We would like the
bar chart to be made available to everyone, not just those that have a
signon to our RTC server. Could we a) put a uri link on the remote
page that will acquire the report jpg, b) run a client java program
as a build job that will run the report and store the resulting jpg
directlly in the website filesystem or c) some other clever
method.

Cheers,

Michael Baylis
CICS TS System Tester
IBM Hursley


Hi Michael,

There are a few ways I could imagine doing this:

1. Programatically save the rendered report as a PDF or other supported
format, and attach those saved reports to a web site (or whatever you
want to do with it). (You can do this by calling our
IReportViewerService with the appropriate arguments).

2. Manually save the png/jpg and post it on a different web site. This
probably isn't what you're looking for.

3. I like your idea of a client java program - if you can get
authenticated with the server you should be home free to call our rest
service (or regular service) to run the report, parse the result and
strip the chart out.

4. We also have a service called IReportImageService. It's a bit of a
hack, but basically if you call this service it should return a byte
stream for a particular image *within* a given report. To see how to use
this, look at our method ReportManager.getReportImage(). (You can
actually call this client method directly if that's possible from your
setup). It already does the parsing that is mentioned in #3.

Hope this helps.

james
Jazz Reports Team Lead

permanent link
Michael Baylis (1832719) | answered Dec 20 '08, 5:23 a.m.

Hi Michael,

There are a few ways I could imagine doing this:

1. Programatically save the rendered report as a PDF or other supported
format, and attach those saved reports to a web site (or whatever you
want to do with it). (You can do this by calling our
IReportViewerService with the appropriate arguments).

2. Manually save the png/jpg and post it on a different web site. This
probably isn't what you're looking for.

3. I like your idea of a client java program - if you can get
authenticated with the server you should be home free to call our rest
service (or regular service) to run the report, parse the result and
strip the chart out.

4. We also have a service called IReportImageService. It's a bit of a
hack, but basically if you call this service it should return a byte
stream for a particular image *within* a given report. To see how to use
this, look at our method ReportManager.getReportImage(). (You can
actually call this client method directly if that's possible from your
setup). It already does the parsing that is mentioned in #3.

Hope this helps.

james
Jazz Reports Team Lead


James,
Fantastic, thank you for your suggestions.

Option 2 is out, we don't do "manual", too busy!!!!

Not sure where I would run the code for option 1.

3 looks promising, a nice simple rest service would be very handy, do we have any examples of this?

4 could also be an option. if ReportManager is available from the jazz plain client.

I'll have a play.

Cheers,

Michael

permanent link
James Moody (3.3k24) | answered Dec 22 '08, 11:08 a.m.
JAZZ DEVELOPER
michaelbaylis wrote:
jmoodywrote:

Hi Michael,

There are a few ways I could imagine doing this:

1. Programatically save the rendered report as a PDF or other
supported
format, and attach those saved reports to a web site (or whatever
you
want to do with it). (You can do this by calling our
IReportViewerService with the appropriate arguments).

2. Manually save the png/jpg and post it on a different web site.
This
probably isn't what you're looking for.

3. I like your idea of a client java program - if you can get
authenticated with the server you should be home free to call our
rest
service (or regular service) to run the report, parse the result and

strip the chart out.

4. We also have a service called IReportImageService. It's a bit of
a
hack, but basically if you call this service it should return a byte

stream for a particular image *within* a given report. To see how to
use
this, look at our method ReportManager.getReportImage(). (You can
actually call this client method directly if that's possible from
your
setup). It already does the parsing that is mentioned in #3.

Hope this helps.

james
Jazz Reports Team Lead

James,
Fantastic, thank you for your suggestions.

Option 2 is out, we don't do "manual", too busy!!!!

Not sure where I would run the code for option 1.

3 looks promising, a nice simple rest service would be very handy, do
we have any examples of this?

4 could also be an option. if ReportManager is available from the jazz
plain client.

I'll have a play.

Cheers,

Michael


I don't have a standalone example of 3, but the code is in
IReportRestService, and the method you'll want is getRenderedReport.
You'll need to pass UUIDs for the project area and report template, as
well as a list of parameters and values. urlPrefix should probably be
"../". You actually might want to use postRenderReport iunstead of
getRenderedReport - it's the same except operates through a post so
doesn't run into the arbitrary length restrictions that we see with a get.

IReportManager should be available from the jazz plain client, as far as
I know.

Hope this helps.

james

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.