Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Data Extraction Task
Data Extraction Task [message #675164] Mon, 30 May 2011 13:26 Go to next message
Jan Kohnert is currently offline Jan Kohnert
Messages: 192
Registered: July 2009
Senior Member
Hello,
I've set up a data extraction task as described here:
http://wiki.eclipse.org/Data_Extract_%28BIRT%29_2.1

Using this, I can easily extract all data contained within the report. But, how can I extract the data that is contained in the result set delivered by the query defined in the reports design file but is not being shown anywhere in the report? I've checked the report document, and the unused data is contained inside this file.

Is there a way to access this by API?

I need this, because I want to register printed items. I do mark a item printed by its unique id. This registration is done after creating the document using the BIRT API. No report file scripting should be used.
The id is contained in the result set, but is never being show somewhere.

Example: My query delivers three columns:
NAME  VALUE  ID
----- ------ ----
foo   1      4711


'foo' and '1' is getting printed on the report.
4711 is the unique index to use to register the item.

So for registration the unprinted column ID is required.

Thank you!

[Updated on: Mon, 30 May 2011 13:26]

Report message to a moderator

Re: Data Extraction Task [message #675487 is a reply to message #675164] Tue, 31 May 2011 16:06 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Jan,

There is a DataEngine API to create or call datasets created in a
report, but it is not finalized and may change. Can you add a hidden
table that is bound to the dataset? It should not show up in the output
but should be accessible using the data extraction task.

Jason

On 5/30/2011 9:26 AM, Jan Kohnert wrote:
> Hello,
> I've set up a data extraction task as described here:
> http://wiki.eclipse.org/Data_Extract_%28BIRT%29_2.1
>
> Using this, I can easily extract all data contained within the report.
> But, how can I extract the data that is contained in the result set
> delivered by the query defined in the reports design file but is not
> being shown anywhere in the report? I've checked the report document,
> and the unused data is contained inside this file.
> Is there a way to access this by API?
> I need this, because I want to register printed items. I do mark a item
> printed by its unique id. This registration is done after creating the
> document using the BIRT API. No report file scripting should be used.
> The id is contained in the result set, but is never being show somewhere.
> Example: My query delivers three columns:
> NAME VALUE ID
> ----- ------ ----
> foo 1 4711
>
> 'foo' and '1' is getting printed on the report.
> 4711 is the unique index to use to register the item.
> So for registration the unprinted column ID is required.
> Thank you!
>
Re: Data Extraction Task [message #675685 is a reply to message #675487] Wed, 01 June 2011 08:01 Go to previous messageGo to next message
Jan Kohnert is currently offline Jan Kohnert
Messages: 192
Registered: July 2009
Senior Member
Jason,
Since the data is contained in the report document, would it make sense to file a bug/feature request to get access to it? Having invisible tables somewhere isn't really an enduring solution for me. But, I could easily wait another release or so.
Jan
(no subject) [message #675687 is a reply to message #675487] Wed, 01 June 2011 08:01 Go to previous messageGo to next message
Jan Kohnert is currently offline Jan Kohnert
Messages: 192
Registered: July 2009
Senior Member
Jason,
Since the data is contained in the report document, would it make sense to file a bug/feature request to get access to it? Having invisible tables somewhere isn't really an enduring solution for me. But, I could easily wait another release or so.
Jan
Re: Data Extraction Task [message #675781 is a reply to message #675685] Wed, 01 June 2011 13:24 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Jan,

Yes you can file a bug for this, but the queries of unused data sets
should not be getting called at all. Do you have the dataset tied to a
parameter?

Jason

On 6/1/2011 4:01 AM, Jan Kohnert wrote:
> Jason,
> Since the data is contained in the report document, would it make sense
> to file a bug/feature request to get access to it? Having invisible
> tables somewhere isn't really an enduring solution for me. But, I could
> easily wait another release or so.
> Jan
>
Re: Data Extraction Task [message #676717 is a reply to message #675781] Mon, 06 June 2011 10:00 Go to previous messageGo to next message
Jan Kohnert is currently offline Jan Kohnert
Messages: 192
Registered: July 2009
Senior Member
Jason,
the data set itself is not unused. Just some columns inside of it are.
What do you mean with the dataset being tied to a parameter? A parameters value is getting passed to the query, but thats it.
Jan
Re: Data Extraction Task [message #676773 is a reply to message #676717] Mon, 06 June 2011 13:37 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

I meant that the dataset was used in a dynamic parameter. It does not
sound like this is how you use it. If you use the data in the report it
should be available for data extraction. Where is the dataset used?

Jason

On 6/6/2011 6:00 AM, Jan Kohnert wrote:
> Jason,
> the data set itself is not unused. Just some columns inside of it are.
> What do you mean with the dataset being tied to a parameter? A
> parameters value is getting passed to the query, but thats it.
> Jan
>
Re: Data Extraction Task [message #676832 is a reply to message #676773] Mon, 06 June 2011 16:51 Go to previous message
Jan Kohnert is currently offline Jan Kohnert
Messages: 192
Registered: July 2009
Senior Member
The data set is bound to a table in the reports flow area. My first posts example shows the usage of the sets columns. Simplified sad, the query returns three columns, two of them are shown in the report, and the third one is not. But the third column contains the data required by the potential data extraction task.
Previous Topic:BIRT Exception when starting/stopping GlassFish 3
Next Topic:Reference dataset data values from chart script?
Goto Forum:
  


Current Time: Tue Oct 21 20:10:19 GMT 2014

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

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