| Author |
 Topic  |
|
|
RobRobs
New Member
United Kingdom
6 Posts |
 Posted - 12/09/2006 : 14:14:59
|
is is possible to automatically set the line attribute to exclude if the quantity value is zero in the worksheet
|
|
|
Tolleh
QuoteWerks Genius
USA
2066 Posts |
Posted - 12/09/2006 : 17:18:42
|
I believe you can use the QuoteWerks API to accomplish this. If, however, all you wish to do is not print a line if the quantity is 0, then you can do this in the print layout. Set the filter of the detail section to the following:
.IF.DocumentItems->QtyTotal <> 0
Hope this helps,
Dan |
"For [G o d] so loved the world that he gave his one and only Son, that
whoever believes in him shall... have eternal life." John 3:16 N.I.V.
    |
 |
|
|
RobRobs
New Member
United Kingdom
6 Posts |
Posted - 12/15/2006 : 05:45:20
|
great this works just fine.
Thanks |
|
|
|
Tolleh
QuoteWerks Genius
USA
2066 Posts |
Posted - 12/15/2006 : 18:40:36
|
quote:
Originally posted by RobRobs
great this works just fine.
Thanks
You're Welcome!
Dan |
"For [G o d] so loved the world that he gave his one and only Son, that
whoever believes in him shall... have eternal life." John 3:16 N.I.V.
|
|
|
|
grouptek
QuoteWerks Enthusiast
Kuwait
19 Posts |
Posted - 03/04/2010 : 18:34:07
|
quote:
Originally posted by Tolleh
I believe you can use the QuoteWerks API to accomplish this. If, however, all you wish to do is not print a line if the quantity is 0, then you can do this in the print layout. Set the filter of the detail section to the following:
.IF.DocumentItems->QtyTotal <> 0
Hope this helps,
Dan
Hi Dan
What if I want to print the line but not to print "0" (for the quantity) if the quantity is zero.
I tried to use the following formula ("...Mismatch")
.if.documentitems->qtytotal<>0.then.documentitems->qtytotal.else."" |
Mohammad |
|
|
|
mattquintadena
QuoteWerks Master
United Kingdom
278 Posts |
Posted - 03/04/2010 : 19:01:11
|
Nice young quote being revived here :-)
The easiest way to do this is to right-click the qty field and choose 'suppress zero values' |
Matt Rose
Quintadena Ltd. ; The World's Number One QuoteWerks Solution Partner ; 3 years running.
matt.rose@quintadena.com
Looking to get more from QuoteWerks? - www.quintadena.com/extensions.pdf |
|
|
|
Tolleh
QuoteWerks Genius
USA
2066 Posts |
Posted - 03/04/2010 : 19:44:07
|
quote:
Originally posted by mattquintadena
Nice young quote being revived here :-)
Yep, its nice to see people are using the search feature
quote:
Originally posted by grouptek
Hi Dan
What if I want to print the line but not to print "0" (for the quantity) if the quantity is zero.
I tried to use the following formula ("...Mismatch")
.if.documentitems->qtytotal<>0.then.documentitems->qtytotal.else.""
Matt's suggestion is the easiest solution, however, so you understand the "mismatch" problem:
Both possible returns to the formula must be the same type
documentitems->qtytotal is a number type
"" is a text type
To fix your formula, make documentitems->qtytotal a text type:
.if.documentitems->qtytotal<>0.then.text(documentitems->qtytotal).else.""
Hope this helps,
Dan |
"For [G o d] so loved the world that he gave his one and only Son, that
whoever believes in him shall... have eternal life." John 3:16 N.I.V.
|
|
|
|
grouptek
QuoteWerks Enthusiast
Kuwait
19 Posts |
Posted - 03/06/2010 : 16:55:56
|
| I feel 3.5 years younger. Thank you Sirs. |
Mohammad |
|
|
| |
Topic |
|
Not printing lines with zero values
