Hi,
I have a report of related to TDS Details...my problem is that i want CESS Amt. / TDS Amt. / Surcharge Amt. in different columns...
i think this is possible only when we query on both Withholding Tax Type with Withholding Tax Code fields...like...
Withholding Tax Type ..........Withholding Tax Code
............EE........................................G2
............IE.........................................GT
............SE........................................G1
When meet the condition, it pick the value of CESS Amt. / TDS Amt. / Surcharge Amt..and transport the value in related column..
Please note that there is lots of Withholding Tax Type value with Withholding Tax Code value fields in the table, it is right to mention all the codes separetly in my code or any other method is possible..
Pls suggest...