Ad hoc report...issue with list box

[apthansh]

Hi All,

Can anybody help me here.Please see attached sample QVW file.I have split the list box into 2 different items but the data is coming from one single column.However when I select value in one list box the other selected item will clear off.

Ex:If I select Rent and then Active Rent will disappear from the generated report.How can I avoid that ?

I want to keep all the selections applied in the report.How can I do that ?

Thank much.

[maxgro]

maybe with 2 kpi tables

load * iNLINE [

KPI1

Rent

Others

];

load * iNLINE [

KPI2

Active

Inactive ];