Code: [#Line : EI ColumnOne] Option : Global EI ColumnOne [!Line: Global EI ColumnOne] Add : Right Fields : After : VCH DiscTitle : SchemeAmtTL,SchemeAmtTL1,SchemeAmtTL2 [Field : SchemeAmtTL] Info : "Dis-1" Align : Centre Width : 5 Style : Small Border : Thin Left Right [Field : SchemeAmtTL1] Info : "Dis-2" Align : Centre Width : 5 Style : Small Border : Thin Left Right [Field : SchemeAmtTL2] Info : "Dis-3" Align : Centre Width : 5 Style : Small Border : Thin Left Right [#Line : EI ColumnTwo] Option : Global EI ColumnTwo [!Line: Global EI ColumnTwo] Add : Right Fields : After : VCH DiscTitle : SchemeAmtTL ,SchemeAmtTL1,SchemeAmtTL2 Local : Field : SchemeAmtTL : Info : " " [#Line : EI InvInfo] Option : Global EI InvInfo [#Line : CI InvInfo] Option : Global EI InvInfo [!Line: Global EI InvInfo] Add : Right Fields : After : VCH Discount : SchemeAmt,SchemeAmt1,SchemeAmt2 [Field : SchemeAmt] Use : Number Field Width : 5 Set Always : Yes Storage : SchemeAmt Format : "Zero, Percentage" Align : Right [Field : SchemeAmt1] Use : Number Field Width : 5 Set Always : Yes Storage : SchemeAmt1 Format : "Zero, Percentage" Align : Right [Field : SchemeAmt2] Use : Number Field Width : 5 Set Always : Yes Storage : SchemeAmt2 Format : "Zero, Percentage" Align : Right [System:UDF] SchemeAmt : Number : 2345 SchemeAmt1 : Number : 2346 SchemeAmt2 : Number : 2347 [#Field: VCH NrmlValue] Delete : Set as Add : Set as :($Rate * $BilledQty) * (100 - $SchemeAmt) / 100 * (100 - $SchemeAmt1) / 100 *(100 - $SchemeAmt2) / 100
Very nice this tdl file but print preview not show extra discount column how to print this extra discount column please tell me
if any item qty equal to 3000 kg and it's discount value 10% then discounted result should be 300 after giving discount the total price would like Rs. 2700/- i need such report which column presents only discounted value. if you try such code please share to sumamehtra@gmail.com