407-248-1481
QuoteWerks Knowledgebase Topic (Article ID 5926)
Print Layouts - How do you create a Layout that does not number Comment or Group Member lines?This information applies to : |
Article ID 5926 Created/Updated June 16, 2015 Category Print Layouts
|
|
| Question:
How do you create a Layout that does not line number comment or Group Member lines? Solution: This solution requires multiple formulas that are all inter-connected. 1. Create a formula called counter with the contents: .if.documentitems->linetype=2.or.documentitems->&lineattributegroupmember.then.1 2. Place counter in the Report Footer and format: set the Summarization Type to Total and the field to be invisible. 3. Create a formula called LN with the contents: .if.documentitems->linetype<>2.and..not.documentitems->&lineattributegroupmember.then.sys->rec_count-calc->counter (After creating the LN formula and positioning it in the layout, double-click on it and check the checkbox labeled "Suppress Zero Values." This will prevent the zeroes from appearing.) 4. Place LN in the Detail Section. LN is going to be the actual line number, so do not set its property to be invisible. An Alternate formula setup: "COUNTER" formula (does in the report footer; weeds out comments, headers, group headers, etc): .if.documentitems->linetype=2.or.documentitems->&lineattributegroupmember.or.documentitems->linetype=256.or.documentitems->linetype=4.or.documentitems->linetype=16.or.documentitems->linetype=64.or.documentitems->linetype=128.or.documentitems->linetype=512.then.1 "LN" formula: .if.documentitems->linetype=1.and..not.documentitems->&lineattributegroupmember.or.documentitems->linetype=8.and..not.documentitems->&lineattributegroupmember.then.sys->rec_count-calc->counter |
||
|
|
©1993-2024 Aspire Technologies, Inc.
407-248-1481 (9am-5pm ET M-F)
Please Wait...