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


Are you using the most current release of QuoteWerks?
Version 5.5 Build 1
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

New Search