|
Re: Generate parameter value from report dataset [message #689500 is a reply to message #689462] |
Mon, 27 June 2011 18:06 |
|
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
|
|
|
Re: Generate parameter value from report dataset [message #689501 is a reply to message #689500] |
Mon, 27 June 2011 18:11 |
|
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
>
|
|
|
|
Re: Generate parameter value from report dataset [message #689559 is a reply to message #689523] |
Mon, 27 June 2011 20:36 |
|
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 #689923 is a reply to message #689783] |
Tue, 28 June 2011 15:16 |
|
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.
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.04961 seconds