Display Fields in a Listbox

[sekharQV]

Hi Techies,

Could you please help me on below requirement.

I have the following fields available in my app

"DuplicateBankAccount",  "DuplicateTaxId",  "DuplicateBankAccountAndTaxId",  "DuplicateAddress", "Missing Bank Accounts or TaxId"

My 1st requirement is to display above fields in a listbox with one more option 'All' where 'All' is combination of all above fields.

2nd requirement is i have 5 fields (field1,field2,..etc) which contains associated count of the values of above fields respectively.

so when i click on "DuplicateBankAccount" in listbox,then it should show the "field1" values under count column(or expression) of straight table(fields in table are supplier name and count which could be expression), and when i click on "DuplicateTaxId", then it should show the "field2" values under count column of table and so on and when i click "All" in listbox,then it should show sum all filelds(field1+field2+..+field5) under count column of table.

Could anybody suggest me, how to achieve it.

Help is appreciated.

Thanks & Regards,

Rajasekhar.

[Nicole-Smith]

Please do not post the same question more than once.  Someone has already replied to your thread here: Display fileds as drop down list

[Qrishna]

Something like in the below pic?