| Reusing data [message #259253] |
Wed, 24 October 2007 04:34  |
Eclipse User |
|
|
|
Originally posted by: nikolaine.gmail.com
Hello
A database query retrieves data into a dataset. However, I plan to
reuse the same data in 2 sub reports. How do I save the retreived data
in memory and reuse it the sub reports? A global variable collection
may be of use. But, which class ?
Thanks
Niko
|
|
|
|
|
| Re: Reusing data [message #259703 is a reply to message #259394] |
Fri, 26 October 2007 18:05  |
| Eclipse User |
|
|
|
Niko,
Try this with the 2.2.1 BIRT build. First create a table that binds to the
data set you want to use. Make sure you give this table a name. (You can
hide this table if you don't want it shown in the report). Create your
charts, and have them use the table as the data source. You do this in the
Select Data step in the chart wizard: check "Use report item" and select the
table as the source of data. This will make all your charts use the table's
result set, and the data set query will be run only once.
Does this work for you?
--
Gary Xue [Actuate Corporation | BIRT Committer]
"Niko Laine" <nikolaine@gmail.com> wrote in message
news:ffpalv$sap$1@build.eclipse.org...
> Hi Gary
>
> Thanks for your response. This what I would like to achieve. After
> querying and retrieving the data rows, I would like to save it in memory
> for reuse . I would like to reuse the data to present the same data as 3
> different chart views.
>
> Thanks
> Niko
>
>
>
>
> Gary Xue wrote:
>> Niko,
>> You cannot use a global Javascript variable to record a collection of
>> data rows and reuse the row set in a different table. You can however use
>> a variable to rememer a single value to use it in a different part of the
>> report.
>> I suspect however that you use case may be addressed by either sub
>> queries (have 2 or more items bound to an outer item's result set), or
>> result set sharing feature introduced in BIRT 2.2.1. If you can give a
>> concrete example on the type of report you want, I might be able to
>> suggest a solution.
>>
>> regards,
>>
|
|
|
Powered by
FUDForum. Page generated in 0.11165 seconds
Home