Hi dgofman,
I have opened a new question for the xml retrive
Once i get the table data in xml format....
i would like to give this data has dataprovider to dropdown menu..
which initially displays
Main menu SideMenu
-----------------------------------------------------------------------------------
Distinct client names only......
CLIENT_NAME1-------------CASE_TYPE related to CLIENT_NAME1
CLIENT_NAME2--------------CASE_TYPE related to CLIENT_NAME2
Is there anything i should alter in the query for retriving xml and populating the dropdown to get the output in the required format.............