Hi,
I want to move the data into diff. columns against 1 document no.
like:--
A/C Doc. No..............Year.......Base Amt.........WH. Tax........Cess.........TDS.......Surchage
1900000944...............2008.........321.00-............1.00...............0.00..........0.00..........0.00
1900000944...............2008.........321.00-............7.00...............0.00..........0.00..........0.00
1900000944...............2008.........321.00-............2.00...............0.00..........0.00..........0.00
Please look at WH. Tax column, now i want that value of 1st line item means 1.00 should goes under Cess Column, same 7.00 value should goes under TDS column and 2.00 value should goes under Surcharge column.and data must come in a single row.......like..
Note:- i don't want to show the WH. Tax column in my report..., i want this output...
A/C Doc. No..............Year.......Base Amt.........Cess.........TDS.......Surchage
1900000944...............2008.........321.00-............1.00..........7.00..........2.00
Please tell me, where i m wrong, i m pasting my code....please check...
Thanks