Home : Using Optional Print Values
Q11292 - INFO: Using Optional Print Values
Optional Print Values is used to setup alternate outputs on reports for the variable and is setup in Edit/View Variables, Options tab


Defining Optional Print allows text to be printed on reports given the conditions specified.  For example, when the flow is below 1, reports can print "Low Flow".  The primary condition is checked first and if the primary threshold conditions are not crossed, the secondary condition is checked.  For example, if you want the fecal coliform count to print TFTC if below 50 and to print INVALID if below 10, set up the Primary as < 10, Invalid and the Secondary as < 50, TFTC.  Reports can be set up to print the optional print value or print the raw data.


Relational Operator:  (Primary and Secondary)  is used in conjunction with the Threshold  Value, to determine whether or not the Threshold Value has been crossed.  A combo box allows selection of valid operators.  Valid relational operators are:

< (less than)
<=  (less than or equal to)
= (equal to)
>=  (greater than or equal to)
> (greater than)

Threshold Value:  (Primary and Secondary) The numeric threshold value is used in conjunction with the Relational Operator.

Optional Print Value:  (Primary and Secondary) The Optional Print Value for "Threshold Crossings". Usually, if a Threshold Value is crossed, it is (optionally) printed on reports.  It can be any string of up to 15 characters such as 'TRACE ', 'TNTC ',  etc.


Spread functions that end in OPV (such as GAVGOPV, VAROPV,...) support the use of the Optional Print value.


The following example shows a spread report displaying "High Flow" instead of the actual numeric result.  See GAVGOPV for more information. 

Download Example Template: Help_GAVG_Examples.ss3 (Click here for download instructions)

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?


Tell us why you rated the content this way. (optional)
Approved Comments...
No user comments available for this article.
Created on 6/3/2008 3:17 PM.
Last Modified on 12/9/2020 10:43 AM.
Last Modified by Scott Dorner.
Article has been viewed 4258 times.
Rated 5 out of 10 based on 2 votes.
Print Article
Email Article