Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » True subreport?(Report on data referenced in another table?)
True subreport? [message #671615] Wed, 18 May 2011 09:40 Go to next message
Colin Sutton is currently offline Colin Sutton
Messages: 59
Registered: July 2009
Member
I have been trying to display data from one data set that is referenced in another data set. I followed the subreport example, but that only allows tables to be linked. My inner data set needs a parameter supplied from a table in the outer data set.
I tried using a hyperlink, passing data from a row in the outer table via a parameter to a query in the linked report, but I don't see a way to display that data inside the outer table, only in the whole window. Is there a way to do it?
(no subject) [message #671662 is a reply to message #671615] Wed, 18 May 2011 11:05 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Colin,

The inner data set has a binding tab, which has a data set parameters
button that allows the inner dataset's query parameters to be linked to
the outer data row. Is this what you want?

Jason

On 5/18/2011 9:40 AM, Colin Sutton wrote:
> I have been trying to display data from one data set that is
> referenced in another data set. I followed the subreport
> example, but that only allows tables to be linked. My inner
> data set needs a parameter supplied from a table in the
> outer data set.
> I tried using a hyperlink, passing data from a row in the
> outer table via a parameter to a query in the linked
> report, but I don't see a way to display that data inside the outer
> table, only in the whole window. Is there a way
> to do it?
>


Jason Weathersby

BIRT Exchange
(no subject) [message #671970 is a reply to message #671662] Thu, 19 May 2011 08:57 Go to previous messageGo to next message
Colin  is currently offline Colin
Messages: 14
Registered: September 2010
Junior Member
I don't see a binding tab on the data set. The binding tab is on the array;
my parameters are used in the beforeOpen script of the data set and do not
appear in the table's data set parameter dialog.
Colin

Jason Weathersby <jasonweathersby@windstream.net> wrote:
> Colin,
>
> The inner data set has a binding tab, which has a data set parameters
> button that allows the inner dataset's query parameters to be linked to
> the outer data row. Is this what you want?
>
> Jason
>
> On 5/18/2011 9:40 AM, Colin Sutton wrote:
>> I have been trying to display data from one data set that is
>> referenced in another data set. I followed the subreport
>> example, but that only allows tables to be linked. My inner
>> data set needs a parameter supplied from a table in the
>> outer data set.
>> I tried using a hyperlink, passing data from a row in the
>> outer table via a parameter to a query in the linked
>> report, but I don't see a way to display that data inside the outer
>> table, only in the whole window. Is there a way
>> to do it?
>>


--
Colin Sutton
(no subject) [message #671988 is a reply to message #671970] Thu, 19 May 2011 10:08 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Colin,

The binding tab is on the table when it is placed in the report.
Can you post your report?

Jason

On 5/19/2011 8:57 AM, Colin wrote:
> I don't see a binding tab on the data set. The binding tab is on the array;
> my parameters are used in the beforeOpen script of the data set and do not
> appear in the table's data set parameter dialog.
> Colin
>
> Jason Weathersby<jasonweathersby@windstream.net> wrote:
>> Colin,
>>
>> The inner data set has a binding tab, which has a data set parameters
>> button that allows the inner dataset's query parameters to be linked to
>> the outer data row. Is this what you want?
>>
>> Jason
>>
>> On 5/18/2011 9:40 AM, Colin Sutton wrote:
>>> I have been trying to display data from one data set that is
>>> referenced in another data set. I followed the subreport
>>> example, but that only allows tables to be linked. My inner
>>> data set needs a parameter supplied from a table in the
>>> outer data set.
>>> I tried using a hyperlink, passing data from a row in the
>>> outer table via a parameter to a query in the linked
>>> report, but I don't see a way to display that data inside the outer
>>> table, only in the whole window. Is there a way
>>> to do it?
>>>
>
>


Jason Weathersby

BIRT Exchange
Previous Topic:Best way to design a Report
Next Topic:Automatically create daily reports by using a Java Application
Goto Forum:
  


Current Time: Sat Apr 19 18:48:01 EDT 2014

Powered by FUDForum. Page generated in 0.03661 seconds