Hello Experts, How to print the item descriptions in horizontal manner separated by comma... not like vertical on by one, its wasting paper
[*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
[*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
Instead of Info: $$FullList:BasicUserDescription:$BasicUserDescription try Set as : $$FullList:BasicUserDescription:$BasicUserDescription It may work Regards
[*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
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($$StringLengthMyValue)/40):"1" where @MyValue filed contain concatenated description lines, and 40 shows 40 character per line.
Sorry.. I did not see this post earlier. I think this can help: http://www.tdlexpert.com/index.php?...ription-as-additional-column-in-invoice.6141/ to add further description change set as formula at field level
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
[*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
[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 ""
[*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 ""