Need code to make Excel Sheet from Sales Register

Discussion in 'Requests' started by Gaurav Kothari, Jan 23, 2015.

    
  1. Gaurav Kothari

    Gaurav Kothari New Member


    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
    Untitled.jpg Untitled1.jpg
     


  2. Gaurav Kothari

    Gaurav Kothari New Member


    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
     


Share This Page