Eclipse Community Forums: BIRT » Static Birt Reports

Home » Archived » BIRT » Static Birt Reports

Sun, 12 March 2006 01:40

Eclipse User

Originally posted by: vksharma44.hotmail.com

I am querying a very large Data Set 5 Million rows and the report
generation is slow. Is there any way I can generate the report every
night and deploy it as a HTML so that end users always see the HTML and do
not have to run the report query and load the server.

Re: Static Birt Reports [message #143636 is a reply to message #143247]

Mon, 13 March 2006 18:22

Eclipse User

Originally posted by: tom.tom.com

That will be good to know. Please help anyone.

Re: Static Birt Reports [message #143838 is a reply to message #143247]

Tue, 14 March 2006 17:42

Eclipse User

Originally posted by: mike.ourworld.com

Vik wrote:

> I am querying a very large Data Set 5 Million rows and the report
> generation is slow. Is there any way I can generate the report every
> night and deploy it as a HTML so that end users always see the HTML and do
> not have to run the report query and load the server.
Not sure if this is possible. Anyone.

Re: Static Birt Reports [message #143849 is a reply to message #143838]

Tue, 14 March 2006 18:33

Eclipse User

Originally posted by: ian.marlier.studentuniverse.com

A slightly different way, that should work...

(Assumes a linux server, with some kind of a static web server install, be
it apache or something else)

wget -O /path/to/apache/root/dailyReport.html
" http://birt.server/run?__report=myreport.rptdesign&myfir stparameter=paramvalue&mysecondparameter=anotherparamval ue"

There may be a way to do it within BIRT directly, but if so I don't know
what it is...

Re: Static Birt Reports [message #143968 is a reply to message #143247]

Wed, 15 March 2006 09:36

Eclipse User

Originally posted by: b.noemailspam.nothere

You can use the Engine API RunAndRender task to generate your report as
an html file and drop it into a directory of your choice.

See the BIRT Report Engine API page.
http://www.eclipse.org/birt/phoenix/deploy/reportEngineAPI.p hp

You could then use cron or similar to start the report generation each
evening.

Vik wrote:
> I am querying a very large Data Set 5 Million rows and the report
> generation is slow. Is there any way I can generate the report every
> night and deploy it as a HTML so that end users always see the HTML and
> do not have to run the report query and load the server.

Re: Static Birt Reports [message #144166 is a reply to message #143247]

Wed, 15 March 2006 13:59

Eclipse User

Vik wrote:

> I am querying a very large Data Set 5 Million rows and the report
> generation is slow. Is there any way I can generate the report every
> night and deploy it as a HTML so that end users always see the HTML and
> do not have to run the report query and load the server.

[Another message in this thread describes something similar.]

OpenSymphony's Quartz comes to mind. Set up a "job" in Quartz to
do the report generation at a convenient hour (in the middle
of the night). Set the output of the report to the expected
location in your Web app's directories. BIRT's runtime engine

http://www.eclipse.org/birt/phoenix/deploy/

would crank out the report. Your code would update a "reports"
table in your database with a new report entry.

You choose your design: save the report to a blob in the "reports"
table or save it to the file system. (I usually prefer the latter.
That requires that I save the filename as part of each record in
the "reports" table.)

The Web page which provides links to daily reports would
of course be dynamic -- i.e., your code should read the db table
which maintains the link/filename information for each daily report
and create the appropriate links.

Quartz is here:

http://www.opensymphony.com/quartz/

Quartz tutorial:

http://www.opensymphony.com/quartz/wikidocs/Cookbook.html

Here's an O'Reilly article to get you started:

http://www.onjava.com/pub/a/onjava/2006/03/01/job-scheduling -in-web-application.html

And finally, do it in Spring:

http://www.springframework.org/docs/reference/scheduling.htm l

--

Paul Furbacher
http://www.teamb.com

Re: Static Birt Reports [message #144728 is a reply to message #144166]

Thu, 16 March 2006 16:02

Eclipse User

Originally posted by: m.n.com

And see what is being done with Pentaho. www.pentaho.org

Paul Furbacher wrote:
> Vik wrote:
>
>> I am querying a very large Data Set 5 Million rows and the report
>> generation is slow. Is there any way I can generate the report every
>> night and deploy it as a HTML so that end users always see the HTML
>> and do not have to run the report query and load the server.
>
>
> [Another message in this thread describes something similar.]
>
>
> OpenSymphony's Quartz comes to mind. Set up a "job" in Quartz to
> do the report generation at a convenient hour (in the middle
> of the night). Set the output of the report to the expected
> location in your Web app's directories. BIRT's runtime engine
>
> http://www.eclipse.org/birt/phoenix/deploy/
>
> would crank out the report. Your code would update a "reports"
> table in your database with a new report entry.
>
> You choose your design: save the report to a blob in the "reports"
> table or save it to the file system. (I usually prefer the latter.
> That requires that I save the filename as part of each record in
> the "reports" table.)
>
> The Web page which provides links to daily reports would
> of course be dynamic -- i.e., your code should read the db table
> which maintains the link/filename information for each daily report
> and create the appropriate links.
>
> Quartz is here:
>
> http://www.opensymphony.com/quartz/
>
>
> Quartz tutorial:
>
> http://www.opensymphony.com/quartz/wikidocs/Cookbook.html
>
>
> Here's an O'Reilly article to get you started:
>
>
> http://www.onjava.com/pub/a/onjava/2006/03/01/job-scheduling -in-web-application.html
>
>
>
> And finally, do it in Spring:
>
> http://www.springframework.org/docs/reference/scheduling.htm l
>
>
> --
>
> Paul Furbacher
> http://www.teamb.com

Previous Topic:	Multi-select in combo box parameters?
Next Topic:	Multiple Masterpages?

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Apr 30 16:39:14 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter