Hi, Thanks for your inputs.I wanna display all values in program column instaed of blank when i didnt choose any value in the program short name prompt.

Hi Christian, Thankyou so much for quick reply..yeah,i looked at actual Sql query generated by this Ad-Hoc XML query. query: WITH SAWITH0 AS (select D1.c1 as c1, D1.c2 as c2,D1.c3 as c3,D1.c4 as c4, D1.c5 as c5, D1.c6 as c6 from (select sum(T158659.HIRE_EVENT_IND) as c1, T68497.EMPLOYEE_NUM as c2, T68497.FULL_NAME as c3,…