Eclipse Community Forums: BIRT » Generate parameter value from report dataset

Home » Archived » BIRT » Generate parameter value from report dataset

Generate parameter value from report dataset [message #689462]

Mon, 27 June 2011 12:57

Eclipse User

I have a report design which has two parameters. Is is possible that, while the data for the one parameter comes from my application, the data for the second comes dynamically from another dataset which uses the first parameter to retrieve the value of the second parameter?

I have created the situation above but the value of the second parameter always resorts to the default value I supplied when I created the param.

I have other ways of doing this but if this can be done it would be very helpful.

FYI - I'm using BIRT 2.3.2

Thanks in advance,
Don

Re: Generate parameter value from report dataset [message #689500 is a reply to message #689462]

Mon, 27 June 2011 14:06

Eclipse User

Why not use a multi-dataset cascaded parameter. Have a look at the
attached example.

Jason

On 6/27/2011 12:57 PM, c-dowood@state.pa.us wrote:
> I have a report design which has two parameters. Is is possible that,
> while the data for the one parameter comes from my application, the data
> for the second comes dynamically from another dataset which uses the
> first parameter to retrieve the value of the second parameter?
>
> I have created the situation above but the value of the second parameter
> always resorts to the default value I supplied when I created the param.
>
> I have other ways of doing this but if this can be done it would be very
> helpful.
>
> FYI - I'm using BIRT 2.3.2
>
> Thanks in advance,
> Don

Attachment: cacademulitvalues.rptdesign
(Size: 40.41KB, Downloaded 465 times)

Re: Generate parameter value from report dataset [message #689501 is a reply to message #689500]

Mon, 27 June 2011 14:11

Eclipse User

Don,

Sorry I posted a 2.5.2 example. Here is an older one.

Jason

On 6/27/2011 2:06 PM, Jason Weathersby wrote:
> Why not use a multi-dataset cascaded parameter. Have a look at the
> attached example.
>
> Jason
>
> On 6/27/2011 12:57 PM, c-dowood@state.pa.us wrote:
>> I have a report design which has two parameters. Is is possible that,
>> while the data for the one parameter comes from my application, the data
>> for the second comes dynamically from another dataset which uses the
>> first parameter to retrieve the value of the second parameter?
>>
>> I have created the situation above but the value of the second parameter
>> always resorts to the default value I supplied when I created the param.
>>
>> I have other ways of doing this but if this can be done it would be very
>> helpful.
>>
>> FYI - I'm using BIRT 2.3.2
>>
>> Thanks in advance,
>> Don
>

Attachment: cascade.rptdesign
(Size: 53.40KB, Downloaded 482 times)

Re: Generate parameter value from report dataset [message #689523 is a reply to message #689462]

Mon, 27 June 2011 15:06

Eclipse User

Jason,

Thanks for the example. I looked at the Cascading Parameter Group and it's not quite what I need. Here's what I'm looking for using a variation of the example you attached.

Say I wanted to include the Customer's Country of Origin in the header section of the report and this information is stored in a Country Master table that is tied to a Customer Master table by Country ID. The user will supply the Customer ID by making a selection. I wish to have a separate dataset that will get the translation of that customer's Country of Origin...this dataset would have a parameter that is dependent on the Country ID for the specific Customer just selected. I wish this Country ID param to be automatically populated (defaulted) to this value.

This is just a hypothetical situation but, in theory, this is what I'm trying to accomplish. This differs from the example in your attachment in that the second parameter in your example is selected by a user. My need is to have that second parameter to be automatically determined since it can only be one value based on param_1. Perhaps there's something I'm misunderstanding about the Cascading Parameter Group...if so, please don't hesitate to tell me.

Thanks for any assistance you can offer.
Don

Re: Generate parameter value from report dataset [message #689559 is a reply to message #689523]

Mon, 27 June 2011 16:36

Eclipse User

Don

Maybe I am misunderstanding the issue, but in the example I posted, the
second parameter could have been just one value. It would depend on how
the second dataset is constructed. BTW you can have many more levels.
As far as representing any dataset values on the report that is
definitely doable. You would just use nested datasets, where inner
datasets are fired and passed parameters based on parameters and outer
data set values.

Jason

On 6/27/2011 3:06 PM, c-dowood@state.pa.us wrote:
> Jason,
>
> Thanks for the example. I looked at the Cascading Parameter Group and
> it's not quite what I need. Here's what I'm looking for using a
> variation of the example you attached.
>
> Say I wanted to include the Customer's Country of Origin in the header
> section of the report and this information is stored in a Country Master
> table that is tied to a Customer Master table by Country ID. The user
> will supply the Customer ID by making a selection. I wish to have a
> separate dataset that will get the translation of that customer's
> Country of Origin...this dataset would have a parameter that is
> dependent on the Country ID for the specific Customer just selected. I
> wish this Country ID param to be automatically populated (defaulted) to
> this value.
> This is just a hypothetical situation but, in theory, this is what I'm
> trying to accomplish. This differs from the example in your attachment
> in that the second parameter in your example is selected by a user. My
> need is to have that second parameter to be automatically determined
> since it can only be one value based on param_1. Perhaps there's
> something I'm misunderstanding about the Cascading Parameter Group...if
> so, please don't hesitate to tell me.
>
> Thanks for any assistance you can offer.
> Don

Re: Generate parameter value from report dataset [message #689783 is a reply to message #689559]

Tue, 28 June 2011 07:12

Eclipse User

Jason,

Essentially what I want boils down to this. I want to have a second parameter that will not be selected by a user but instead will be retrieved based on the value of the the first parameter. This second value will than be used to retrieve the necessary data for the report. So the only parameter the user will see/select will be parameter #1.

Thanks again for your help.
Don

FYI - I am using the viewer; however, I have built my own JSP page for interacting with the end user to establish parameter #1. I'm not using the pre-built parameter page.

Re: Generate parameter value from report dataset [message #689923 is a reply to message #689783]

Tue, 28 June 2011 11:16

Eclipse User

Would nested tables work for you? Take a look at the attached example.

Jason

On 6/28/2011 7:12 AM, c-dowood@state.pa.us wrote:
> Jason,
>
> Essentially what I want boils down to this. I want to have a second
> parameter that will not be selected by a user but instead will be
> retrieved based on the value of the the first parameter. This second
> value will than be used to retrieve the necessary data for the report.
> So the only parameter the user will see/select will be parameter #1.
> Thanks again for your help.
> Don
>
> FYI - I am using the viewer; however, I have built my own JSP page for
> interacting with the end user to establish parameter #1. I'm not using
> the pre-built parameter page.

Attachment: nested.rptdesign
(Size: 38.87KB, Downloaded 450 times)

Re: Generate parameter value from report dataset [message #690005 is a reply to message #689923]

Tue, 28 June 2011 14:38

Eclipse User

Jason,

Do you have this in a BIRT 2.3.2 version...or a version that's compatible with this?

Thanks,
Don

Re: Generate parameter value from report dataset [message #690015 is a reply to message #690005]

Tue, 28 June 2011 14:51

Eclipse User

Try this one.

Jason

On 6/28/2011 2:38 PM, c-dowood@state.pa.us wrote:
> Jason,
>
> Do you have this in a BIRT 2.3.2 version...or a version that's
> compatible with this?
>
> Thanks,
> Don

Attachment: nested.rptdesign
(Size: 36.17KB, Downloaded 412 times)

Previous Topic:	cannot display charts
Next Topic:	Unique Count

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 08 03:11:11 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter