Multi value cascading parameter

Hi,

I would like to know if it's possible to allow selection of multi value for cascading parameter on several levels. For example I have three parameters A,B and C. I want to select in B parameter multi value and compute the appropiate result for C depending on the multi value selected for B.

I know that is possible for the last level of the cascading parameter but I didn't find any answer about my example.

any idea?

Thanks in advance

Find more posts tagged with

Comments

mwilliams

I think this is a limitation of the cascading parameter group in BIRT. You can log an enhancement request for this functionality in the bugzilla on eclipse.org.

Maxwelll

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="97553" data-time="1331568396" data-date="12 March 2012 - 09:06 AM">
I think this is a limitation of the cascading parameter group in BIRT. You can log an enhancement request for this functionality in the bugzilla on eclipse.org. </blockquote>
 
Thanks for the response. 
This enhancement is already log, but there are no news since 2010-05-18. 
Do you kown how the update of list value of cascading parameter is managed? 
Can I force dataset, linked to a parameter, to be updated after the selection of an other parameter? 
Thanks in advance

mwilliams

You could always create your own parameter page where you do your own database calls and populate the lists, then call your BIRT reports from it.

Have you "voted" for the enhancement? The more votes it has from the community, the more likely it is to get implemented.

Maxwelll

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="97572" data-time="1331586196" data-date="12 March 2012 - 02:03 PM">
You could always create your own parameter page where you do your own database calls and populate the lists, then call your BIRT reports from it. 
 
Have you "voted" for the enhancement? The more votes it has from the community, the more likely it is to get implemented. </blockquote>
 
I will try to create my own parameter page. 
Yes I have voted for the enhancement. 
Thanks

mwilliams

If you put the details, for the enhancement, in here, others who stumble upon this thread with the same issue can vote for it, as well.

Maxwelll

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="97607" data-time="1331653911" data-date="13 March 2012 - 08:51 AM">
If you put the details, for the enhancement, in here, others who stumble upon this thread with the same issue can vote for it, as well. </blockquote>
 
The bug can be found <a class='bbc_url' href='https://bugs.eclipse.org/bugs/show_bug.cgi?id=208477'>here</a>. 
 
I find a solution to allow the selection of multi value for intermediate level in cascading parameter. 
 
To do that I have changed the __refresh_cascade_select method on the BirtParameterDialog.js of the viewer (webcontent\birt\ajax\ui\dialog). 
 
then I add some script in the beforeOpen of the dataset linked to the parameter. (this.queryText = this.queryText.replace("'test'", params["test"].value)) 
 
And finnaly in the query of the dataset I add somethings like that : select ... from ... where columName IN ('test') ... 
 
This is a solution but it's not a perfect one because of SQL injection. 
 
Say me if you want more details.

mwilliams

Thanks for the update! This could be a good post to put in the devShare if you have time to write it up!

Maxwelll

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="97772" data-time="1331756900" data-date="14 March 2012 - 01:28 PM">
Thanks for the update! This could be a good post to put in the devShare if you have time to write it up! </blockquote>
 
Hi, 
 
I submit my dev in the topic Designing BIRT Reports - tips and tricks (I suppose it has to be validate, because it doesn't appear in the topic?).

mwilliams

Can you try submitting it again? I don't see it either and it shouldn't need validation to appear.

Maxwelll

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="97830" data-time="1331835452" data-date="15 March 2012 - 11:17 AM">
Can you try submitting it again? I don't see it either and it shouldn't need validation to appear. </blockquote>
 
Ok, it's done, you can find it <a class='bbc_url' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/1477-allow-multi-value-for-cascading-parameter/'>here</a>.

mwilliams

Thanks!