I need a report for output in below format.
Perno ,name ,Casual leave entitlement ,casual leave balance,earned leave entitlemnet,earned leave balance
x y 10 5 20 6
But output of standard report pt_qta10 gives in below format
perno ,name,absence quota type number ,deduction
x, y ,casual leave 10 5
x y privilege leave 20 6
Through standard report there will be 2 records each for quota type...
Client requirement is to have in 1 single record for 1 perno.
Please advice how this requirement can be met..
Using adhoc query or through abaper