| Data Extraction Task [message #675164] |
Mon, 30 May 2011 09:26  |
Eclipse User |
|
|
|
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 09:26] by Moderator |
|
|
| Re: Data Extraction Task [message #675487 is a reply to message #675164] |
Tue, 31 May 2011 12:06  |
| Eclipse User |
|
|
|
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 #676832 is a reply to message #676773] |
Mon, 06 June 2011 12:51 |
| Eclipse User |
|
|
|
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.
|
|
|
Powered by
FUDForum. Page generated in 0.70713 seconds
Home