cascading parameters

Hi,

I am creating Cascading Parameters group.

I am having two parametera Param 1 and param 2.Based on the value selected in Param1, I am getting values in Combo for Param2.Now my requirement is I want to have "ALL" option also in Param2.

I tried giving default value as ALL for param2 and modified the query accordingly in BeforeOpen method of Dataset.It is working fine for the first time.But my problem is I am not able to see "All " in combo list of Param2 ,as it is updated on the basis of param1.So,I am never able to select ALL option also.

Plz help how should I proceed further to have ALL option in param 2 combo

Find more posts tagged with

Comments

Abdel

Hi Shilpa,

I am facing the same issue too.. Please let me know if you get any solution.

Thanks and Regards,
Abdel

Shilpa

Can any bdy help us how to achieve it ?

Senz79

Which version of birt you are using!!!

johnw

Couple of things you can try, assuming your cascading is driven by a database.

you can modify your query with a few unions, so, do something like:

select paramValue, category from table union all paramValue, 'All' from table

That "should" work. And, if all else fails, I always recommend the use an external dialog box since I am not a fan of the BIRT web viewers dialog.

Shilpa

Hi John

Can you please tell me how external dialog can be used.I am unaware of that.

Also,I am using BIRT 2.3

Shilpa