I am a novice tdl coder, I do just tweak codes to make them suitable to my needs, and unable to program a new tdl myself what I require is a TDL which exports data to excel from sales register and just need two to three fields in exported excel sheet Buyer's Name, Buyer's Address and please try if Buyer's address comes splitted across cells (i.e. address line 1, address line 2) please see attached snapshot
Done ;;;----------------Adding two New Column to Columnar Report------------;; ;;---------------------------Buyer Name, Buyer Address--------------------------;; [#Line: DSP ColVCHTitle] Local: Field: DBC Buyer1 : Set As : $$LocaleString:"Buyer Name" Local: Field: DBC Buyer2 : Set As : $$LocaleString:"Buyer Address" [#Line: DSP ColVchDetail] Add: Fields: DBC Buyer1 Add: Fields: DBC Buyer2 [Field: DBC Buyer1] Use : Name Field Set as : $BasicBuyerName Lines : 0 Style : Normal Width : 40 Scroll : Yes Border : Thin Left [Field: DBC Buyer2] Use : Name Field Set as : $$FullList:BasicBuyerAddress:$BasicBuyerAddress Lines : 0 Style : Normal Width : 90 Scroll : Yes Border : Thin Left [#Collection: Columnar Filtered Vouchers of Company] Fetch : BasicBuyerName, BasicBuyerAddress