How to print Item Description Side by side ?

Discussion in 'Free Source Codes' started by Dev Asish, Sep 23, 2017.

    
  1. Dev Asish

    Dev Asish New Member


    Hello Experts,

    How to print the item descriptions in horizontal manner separated by comma... not like vertical on by one,

    its wasting paper
     


  2. rishabhexp

    rishabhexp New Member


    ADD A NEW COLOUM IN THE PRINTED INVOICE NEXT AND SET AS DESCRIPTION
     



  3. [*Part: EI DescExplosion]
    Option : EIDescExplosion0 : not $$InPrintMode
    Option : EIDescExplosion1 : $$InPrintMode
    [!Part: EI DescExplosion0]
    Line : EI DescExplosion
    Repeat : EI DescExplosion : BasicUserDescription
    BreakOn : $$IsEmpty:$BasicUserDescription
    Scroll : Vertical
    [!Part: EI DescExplosion1]
    Line : EI DescExplosion1
    [Line: EI DescExplosion1]
    Fields : EI Desc1
    Indent : If $$InPrintMode Then 5 Else 2
    Option : EI DescExplosion Excel : $$InExportMode AND @@IsExcelFormat
    [Field: EI Desc1]
    Use : Narration Field
    Alignment:Justified
    ;Line:$$Line:BasicUserDescription
    Style : Small Italic
    Info : If $$IsEmpty:$Vmeter Then $$FullList:BasicUserDescription:$BasicUserDescription else ""
    Cells : @@ExcelItemColumn
     



  4. [*Part: EI DescExplosion]
    Option : EIDescExplosion0 : not $$InPrintMode
    Option : EIDescExplosion1 : $$InPrintMode
    [!Part: EI DescExplosion0]
    Line : EI DescExplosion
    Repeat : EI DescExplosion : BasicUserDescription
    BreakOn : $$IsEmpty:$BasicUserDescription
    Scroll : Vertical
    [!Part: EI DescExplosion1]
    Line : EI DescExplosion1
    [Line: EI DescExplosion1]
    Fields : EI Desc1
    Indent : If $$InPrintMode Then 5 Else 2
    Option : EI DescExplosion Excel : $$InExportMode AND @@IsExcelFormat
    [Field: EI Desc1]
    Use : Narration Field
    Alignment:Justified
    ;Line:$$Line:BasicUserDescription
    Style : Small Italic
    Info : $$FullList:BasicUserDescription:$BasicUserDescription
    Cells : @@ExcelItemColumn
     


  5. Systecg

    Systecg Member


    NOT WORKING PLZ UPDATE

    THANKS
     


  6. Systecg

    Systecg Member


    NOT WORKING PLZ UPDATE

    THANKS
     


  7. scuba

    scuba Member


    sir not working plz update code thx
     


  8. HVPatel

    HVPatel Active Member


    Instead of Info: $$FullList:BasicUserDescription:$BasicUserDescription
    try Set as : $$FullList:BasicUserDescription:$BasicUserDescription
    It may work

    Regards
     


  9. scuba

    scuba Member


    sir not working plz update code thx
     


  10. scuba

    scuba Member


    sir not working plz update code thx
     


  11. scuba

    scuba Member


    sir not working plz update code thx
     



  12. [*Part: EI DescExplosion]
    Option : EIDescExplosion0 : not $$InPrintMode
    Option : EIDescExplosion1 : $$InPrintMode
    [!Part: EI DescExplosion0]
    Line : EI DescExplosion
    Repeat : EI DescExplosion : BasicUserDescription
    BreakOn : $$IsEmpty:$BasicUserDescription
    Scroll : Vertical
    [!Part: EI DescExplosion1]
    Line : EI DescExplosion1
    [Line: EI DescExplosion1]
    Fields : EI Desc1
    Indent : If $$InPrintMode Then 5 Else 2
    Option : EI DescExplosion Excel : $$InExportMode AND @@IsExcelFormat
    [Field: EI Desc1]
    Use : Narration Field
    Alignment:Justified
    ;Line:$$Line:BasicUserDescription
    Style : Small Italic
    Info : $$FullList:BasicUserDescription:$BasicUserDescription
    Cells : @@ExcelItemColumn
     



  13. I Have an idea for this.

    just delete repeat in part in which description prints

    create a function to add all description values to a single comma separated field by using while loop.

    put newly created field value at the place of original description field.

    you may have to change Lines Value as per space available to print.

    i. e. Lines : $$Round:(($$StringLength:mad:MyValue)/40):"1"

    where @MyValue filed contain concatenated description lines, and 40 shows 40 character per line.
     


  14. Devendra_Rawat

    Devendra_Rawat Well-Known Member



  15. Santosh

    Santosh Member


    DEAR EXPERT
    PLEASE HELP
    HOW TO PRINT ITEM DESCRITION SIDE BY SIDE IN COLUMN
     

    Attached Files:



  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use $$FullList
     


  17. Santosh

    Santosh Member


    Sir
    NOT WORKING
    PLEASE HELP
     


  18. Santosh

    Santosh Member


    AMIT SIR
    ITEM DESC. PRINT BUT NOT PRINT IN COLM TO COLM
    ACTUALLY WE ARE WRITE SR. NO. OF ITEM
    MORE THEN 20 PCS. OF BATTERY
     


  19. Santosh

    Santosh Member


    WhatsApp Image 2021-06-11 at 4.50.19 PM.jpeg 1.jpg 2.jpg

    [*Part: EI DescExplosion]
    Option : EIDescExplosion0 : not $$InPrintMode
    Option : EIDescExplosion1 : $$InPrintMode
    [!Part: EI DescExplosion0]
    Line : EI DescExplosion
    Repeat : EI DescExplosion : BasicUserDescription
    BreakOn : $$IsEmpty:$BasicUserDescription
    Scroll : Vertical
    [!Part: EI DescExplosion1]
    Line : EI DescExplosion1
    [Line: EI DescExplosion1]
    Fields : EI Desc1
    Indent : If $$InPrintMode Then 5 Else 2
    Option : EI DescExplosion Excel : $$InExportMode AND @@IsExcelFormat

    [Field: EI Desc1]
    Use : Narration Field
    Alignment:Right
    ;Line:$$Line:BasicUserDescription
    Style : Small Italic
    Info : If $$IsEmpty:$Vmeter Then $$FullList:BasicUserDescription:$BasicUserDescription else ""

    Cells : @@ExcelItemColumn
     


  20. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    It is working fine.......... maybe your $Vmeter condition is wrong.
     


  21. Amit Kamdar

    Amit Kamdar Administrator Staff Member



  22. Santosh

    Santosh Member


    Sir,
    working fine but not lines not come in column to column
     


  23. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [Field: EI Desc1]
    Use : Narration Field
    Alignment: Justified
    Full Width : Yes

    ;Line:$$Line:BasicUserDescription
    Style : Small Italic
    Info : If $$IsEmpty:$Vmeter Then $$FullList:BasicUserDescription:$BasicUserDescription else ""
     


  24. Santosh

    Santosh Member


    Thank you very much sir
     


  25. Santosh

    Santosh Member


    [*Part: EI DescExplosion]
    Option : EIDescExplosion0 : not $$InPrintMode
    Option : EIDescExplosion1 : $$InPrintMode
    [!Part: EI DescExplosion0]
    Line : EI DescExplosion
    Repeat : EI DescExplosion : BasicUserDescription
    BreakOn : $$IsEmpty:$BasicUserDescription
    Scroll : Vertical
    [!Part: EI DescExplosion1]
    Line : EI DescExplosion1
    [Line: EI DescExplosion1]
    Fields : EI Desc1
    Indent : If $$InPrintMode Then 2 Else 1
    Option : EI DescExplosion Excel : $$InExportMode AND @@IsExcelFormat

    [Field: EI Desc1]
    Use : Narration Field
    Alignment: Left
    Width : 45
    ;Line:$$Line:BasicUserDescription
    Style : Small Italic
    Info : If $$IsEmpty:$Vmeter Then $$FullList:BasicUserDescription:$BasicUserDescription else ""
     


Share This Page