Skip to main content



      Home
Home » Archived » BIRT » Batch Processing
Batch Processing [message #368517] Sat, 06 June 2009 09:20 Go to next message
Eclipse UserFriend
Hi,
I have a requirement where I need to schedule(batch processing) a report.
I create a report with the required datasource and the respective data set.
The report is executed as per the schedule and the resultset is stored in
the temporary table.

How can i retrieve the resultset later from this temporary table using
this report. The dataset associated with the report would point to the
source table. Is there any way I can fetch the data from this temporary
table without changing the dataset associated with this report.

Can I also store the information i.e. the datasource name and this
temporary table name somewhere in the report so that I can fetch the
values any time later.

Any pointers will be appreciated.

Regards,
Anirudh
Re: Batch Processing [message #368519 is a reply to message #368517] Sun, 07 June 2009 12:05 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: johnw.innoventsolutions.com

You can run a report and keep it in a report document. Then you can use
a Data Extraction Task to retrieve the data from the report document.

John

Anirudh wrote:
> Hi,
> I have a requirement where I need to schedule(batch processing) a report.
> I create a report with the required datasource and the respective data set.
> The report is executed as per the schedule and the resultset is stored
> in the temporary table.
>
> How can i retrieve the resultset later from this temporary table using
> this report. The dataset associated with the report would point to the
> source table. Is there any way I can fetch the data from this temporary
> table without changing the dataset associated with this report.
>
> Can I also store the information i.e. the datasource name and this
> temporary table name somewhere in the report so that I can fetch the
> values any time later.
>
> Any pointers will be appreciated.
>
> Regards,
> Anirudh
>
Re: Batch Processing [message #368522 is a reply to message #368519] Mon, 08 June 2009 02:49 Go to previous messageGo to next message
Eclipse UserFriend
John, Thanks for replying. But I did not understand it. Can you kindly
elaborate.

Thanks,
Anirudh
Re: Batch Processing [message #368560 is a reply to message #368522] Wed, 10 June 2009 02:49 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: johnw.innoventsolutions.com

The Data Extraction Task is part of the BIRT API. If your not familiar
with the BIRT API programming, this might be a little confusing :)

Basically, when BIRT runs a report, there is an file generated called a
report document that contains all the data for the report and all the
elements, it just hasn't been rendered to its final output yet. With
this file format, you can do things like specify multiple output formats
in a single pass, read the table of contents, and extract the data.

John

Anirudh Jhina wrote:
> John, Thanks for replying. But I did not understand it. Can you kindly
> elaborate.
>
> Thanks,
> Anirudh
>
Re: Batch Processing [message #368561 is a reply to message #368560] Wed, 10 June 2009 04:06 Go to previous messageGo to next message
Eclipse UserFriend
John,
Yes I am new to BIRT API, but am trying to get a hang on it :)
So if I understand it correctly BIRT API's give you control on.
1. Selecting the DataSet to be used in the BIRT Reporting Engine.
2. Generate the RPTDocument based on the DataSet chosen before running the
TASK.
3. Create a Rendering task and use the RPTDocument to render results.

We know steps 2 and 3 can be achieved, but we are not sure if step 1 is
possible.


Thanks,
Anirudh
Re: Batch Processing [message #368590 is a reply to message #368561] Fri, 12 June 2009 02:05 Go to previous message
Eclipse UserFriend
Originally posted by: johnw.innoventsolutions.com

Yes, you can add, modify, or manipulate a data set to be used during run
time. You can do that internally using BIRT scripting.

John

Anirudh wrote:
> John,
> Yes I am new to BIRT API, but am trying to get a hang on it :)
> So if I understand it correctly BIRT API's give you control on.
> 1. Selecting the DataSet to be used in the BIRT Reporting Engine. 2.
> Generate the RPTDocument based on the DataSet chosen before running the
> TASK.
> 3. Create a Rendering task and use the RPTDocument to render results.
>
> We know steps 2 and 3 can be achieved, but we are not sure if step 1 is
> possible.
>
>
> Thanks,
> Anirudh
>
>
Previous Topic:permgen space error
Next Topic:Displaying a table based on the value of its data elements
Goto Forum:
  


Current Time: Tue Nov 04 03:19:09 EST 2025

Powered by FUDForum. Page generated in 0.48970 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top