Data Extraction Task [message #675164] |
Mon, 30 May 2011 13:26 |
Jan Kohnert Messages: 196 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 |
|
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 #675781 is a reply to message #675685] |
Wed, 01 June 2011 13:24 |
|
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 #676773 is a reply to message #676717] |
Mon, 06 June 2011 13:37 |
|
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
>
|
|
|
|
Powered by
FUDForum. Page generated in 0.03184 seconds