Reports can be text or graph, or screen, and data can be imported.
The definition files needs to be edited with Notepad, or some other text editor - usereport tab
Note: Probe for Windows v2 has an editor for RPT and IPT definitions. (GPT in progress)
Reports can be printed to paper, or exported as comma-delimited files.
Reports to paper have different sections - report header, page header, details, etc
Each line in the RPT file specifies an item, and in which section it will print. Only items in the detail (each site) section will be exported. An item can be...
In addition, a column can be specified.
A column will be printed in 2 parts...
The column titles can be printed either...
Each item that is to be printed has a specification line with format...
Section codes specify in which section of the report the item is to be printed.
|RH||Report header - printed once at beginning of report|
|RF||Report footer - printed once at end of report|
|PH||Page header - printed at top of each page|
|PF||Page footer - printed at bottom of each page|
|GH1||Group header 1 - printed before a group break|
|GF2||Group footer 2 - printed after a Group break|
|D||Detail printed for each site|
|Cn||Column, to go in both detail and column headers.|
|CH||Column header - printed either at top of page or after group header.|
Type codes specify the type of data that is to be output.
|SECTIONHEIGHT||Height of section in cm|
|TEXT||Text box e.g. Source = NAME will print Top Paddock|
|LABEL||Label displaying fixed text e.g. Site Report
but can include variables...
e.g. Source = \OWNER1
displays the first line in the Owner registration file.
|FORMULA||Text box will display numeric data or formula|
e.g. Source = FULL or COTTON.DWU*1.2
|INDIRECTFORMULA||Value of a formula|
e.g. Source = LOWER will evaluate the LOWER formula
|LINE||Draws a line from Left, Top to Right, Bottom|
size = line width in points (0 = hairline)
The source specifies where the data is coming from. It can be the name of a field in the database, or a formula. See Formulas and Variables
RIGHT=8 is a point 8 cm from the left margin. If the left margin = 2.5 cm, it will print at 10.5 cm from left edge of paper.
TOP=1.2 is a point 1.2 cm below the top of the current section.
If a font or font size is not specified, the report default font is used.
Units and format are only applicable for numeric formulas.
Line sizes are specified in points. (1 pt = 1/1440 inches; 0 = hairline, the thinnest line possible on the printer).
Colours are specified with a colour code (e.g. RED)
|hexadecimal (preceded by an &) - same as HTML.|
|Specification line in RPT file||Result|
The column header section height should be specified - this section can also have lines drawn like any of the other sections.
Each column to be output needs a column specification, with the type code Cn, with format...
Each column will be printed in to two parts, the title going to a LABEL (in either the page header or group header) and the source to a FORMULA in the detail section. The horizontal position of the items will be calculated based on the column width.
The actual output will be suppressed if width=0. This can be used to calculate intermediate results.
The character | will force a new line in a column title.
|ColNum||Cn n = column number|
|Source||Any reserved word (variables) or formula.|
|Width||Width of output, in cm.|
|Format||see Format Codes|
|Align||Alignment. L= left; C = centred; R = right.|
|Units||1 = display units (eg mm/day) 0= no units|
|Title||The title at the top of a column - use | for multiple lines.|
|TypeCode||Formula or IndirectFormula|
|Line in RPT file||Printed Result|
Site Name ----------- Top Paddock Site 33
Probe Dwu mm/day ------------- 2.3 mm/day 1.1 mm/day
Amount ------------ 12 Ml
EPIAMT - data field that contains the calculated amount or water required if scheduling is based on estimated daily water use
To customise graph reports useand edit the file GITEMS.TXT or GPT file.
|Prior to version 1.0.204...||After version 1.0.204...||Prwin v2|
|Report names in file GNAMES.TXT.||File GNAMES.TXT is not used||File GNAMES.TXT is not used|
|All reports in the file GITEMS.TXT||As well as GITEMS.TXT, any *.GPT files in C:\Prwin folder are also available||GPT files need to be in shared reports folder|
|The report number is Item 1 in each line.||Reports start with the command ReportTitle
Number and Order are not used
|same as Prwin1|
|Item 8 used for 'units'
Item 11 used for 'bold'
|Same as 1.0.204||Item 8 used for text OPTIONS
Item 11 used for object COLOUR
Each line in the GPT file has the format...
Number, Order, Command, Source , Alias , Format , Align , Units|Options , Orientation , Size , Bold|Colour , Left, Top , Right, Bottom
Note: If a formula is used that contains commas (e.g. =IF(criteria,Value1,Value2)) , use '~' as the delimiter between items.
|Number||Report number from GNAMES.TXT (not used)|
|Order||Printing order (not used)|
|Command||see Command Codes|
|Source||Text, data field or formula|
|Format||d/m/y; 0.00; DWU see Format Codes.|
|Align||Left; Centre; Right, LB; CB; RB with word wrap|
|Units||1=display units (e.g. mm/day); 0 = no units|
|Orientation||Position relative to point see Text Boxes and Labels|
|Size||Relative size of font (100% = standard; 200 = big), or line width in points|
|Bold||1 = bold; 0 = normal|
|Left||Left coordinate position|
|Top||Top coordinate position|
|Right||Right coordinate position|
|Bottom||Bottom coordinate position|
|ReportTitle||Source = report title|
|GraphType||Sets the current graph type|
0 = Depth Graph | 1 = Time Graph
|GraphPosition||Set current graph position|
|GraphTickSize||Set tick size||graph|
|GraphLegendPosition||Set current graph legend position||paper|
|GraphSymbolSize||Set symbol size||graph|
|GraphScale||Set current graph scale|
|PlotGraph||Plots current graph|
|PlotAxes||Plots just axes|
|Text||Plot text from data field||data|
|Label||Plot a label|
(but may contain variables e.g.
|Formula||Plot result of a numeric formula||data|
|IndirectFormula||Plot the evaluation of text that is a formula|
|Picture||Picture in .BMP or .WMF||data|
|Line||Draw line from Left,Top - Right,Bottom|
Source can (optionally) set the colour Size can (optionally) set the line width in points
(also applies to box and arrows)
|Box||Draw box from Left,Top - Right,Bottom||data|
|Arrow||Draw arrow from Left,Top -> Right,Bottom||data|
|DoubleArrow||Draw double arrow from Left,Top <-> Right,Bottom||data|
|Gauge||'Fuel gauge' showing current RZ1 relative to Full and Refill/PWP, or 'Bucket' of water allocation.|
Source = RZ1 or K5, etc
Orientation = 0 = lower base is refill | 1 = lower base is PWP
Align = 0 = Fuel gauge showing RZ1; Align = 1 = plot as bucket of allocated water
Size = relative font size (over-ride default font) of labels
Bold = 0 normal | 1 = bold
base PWP; font 80% of standard, bold, gauge at horiz= 60-62%, vertical=20-35%
cumulative delivered water in keydata row 5, allocated amount entered as maximum, bucket at horiz= 70-72%, vertical=20-35%
|Colour||Set colour for following items|
|DrawWidth||Set width in points for following lines||points|
|DrawStyle||Set line style lines. 0 = solid | 1 = dotted||points|
|Font||Name = Source; Size = Alias|
|Include||Include another report. Source = Report name|
|GraphRows||Set which rows to plot on time graph.|
Source = 0 = All | 1 = Selected | 2 = Field list; Alias = Field list name
|GraphColumns||Set which columns to plot on depth graph.|
Source = 0 = All | 1 = Selected | 2 = Latest. Alias = NumberOfLatest.
|v2 Commands below|
|BeginIf||Start of an IF block; Source = condition|
|BeginElseIf||Start of an ELSEIF block; Source = condition|
|BeginElse||Start of an ELSE block|
|EndIf||End of an IF block|
|ProfileGauge||Diagram showing changes in soil moisture down profile|
|GraphOption||Set any option.|
Source = numeric code of option; Alias = value of option
See option codes
|RestoreSettings||Restore all options to user settings|
|NewPage||Print a new page|
|Orientation||Set paper orientation. Source= 1 = Portrait | 2 = Landscape |
Text can be positioned in two different ways.
If Right, Bottom are entered then...
||prints 'Full:' right aligned in a box from 88-92 % horizontal, 10-12 % vertical.|
If Right, Bottom are not entered then...
||The value of RZ1 is printed just above the last probe reading...|
The position of a graph and the legend are in percent of paper (or screen) - top left of paper is 0%, 0%; centre of paper is 50%, 50%; bottom right of paper is 100%, 100%
The position of all other items (text, labels, lines, arrows, scales) are in either...
(1) Percent paper units
|Left=50, Right=50||exact centre of the screen or paper.|
(2) Data units
Can be specified as either a value or a formula.
If the position is numeric (e.g. 50) it is assumed to be percent % paper units.
|Top = 50||50% of paper|
If alpha or a formula (e.g. FULL+20 or +250 ) it is assumed to be in 'real-world' data units (e.g. mm of water). The value is then converted to percent paper to position the item.
|Top = Full + 20||Full point + 20|
Prwin2 saves extra options for text and formulas as characters.
G = 0 (OFF); H = 1 (ON); I = 2, etc
GHHGGGGGG will show text in bold, and numeric values with units
|1||Plot border around object|
|2||Text in bold|
|3||Show units (e.g. mm)|
|4||Display in red if negative|
Numeric codes used with command GraphOption to over-ride user preferences
|1||Plot Effective Rainfall|
|2||Plot Delivered Rainfall|
|3||Plot Effective Irrigations|
|4||Plot Delivered Irrigations|
|5||Plot Prediction using Probe DWU|
|6||Plot Prediction using Estimated DWU|
|7||Plot Prediction using site formula DWU|
|8||Plot Last Year|
|11||Plot Prediction using ScheduleDWU|
|14||Plot DWU calculated from site DWU formula|
|15||Plot Selected global formulas|
0 = Use Global settings
1 = use local, site-specific, settings for site
|19||Plot Permanent wilting point profile|
|20||Plot Full point profile|
|21||Plot Refill point profile|
|22||Shade between Full-to-Refill profiles|
|23||Shade between latest profiles|
|24||Shade between Current-to-Full profiles|
|25||Shade between Current-to-Refill profiles|
|26||Shade between Current-to-Previous profiles|
|27||Plot Last year|
0 = use Global settings
1 = use local, site-specific, settings for site
|41||GainsSavedIn||0 = separate column|
1 = keydata rows
|42||DeliveredIrrigationRow||Keydata row for delivered irrigations|
|43||EffectiveIrrigationRow||Keydata row for effective irrigations|
|44||DeliveredRainRow||Keydata row for delivered rains|
|45||EffectiveRainRow||Keydata row for effective rains|
|46||PredictMode||0 = existing date/amount system|
1 = drip method (amount = DWU*DAYS)
|47||CorrectForRZ1Change||Add any change in RZ1 from previous probe readings|
|48||CorrectForLimits||0 = None|
1 = stay inside limits
2 = track to average
|49||AutoImportTextFile||Automatic import from text file and append new data.|
|50||CorrectForKSoil||Correct DWU using Ksoil when predicting|
|51||ScheduleUserEnteredDate||User has changed the schedule date|
|52||ScheduleUserEnteredAmount||User has changed the schedule amount|
|53||ScheduleWith||0 = ProbeDWU|
1 = EstimatedDWU
2 = site Historical DWU formula
|54||ScheduleLocal||Using local setting for CorrectForLimits, CorrectForRZ1Change, DripDays|
|55||CorrectPDWU||If scheduling with PDWU, and PDWU < 0 or > 10, use EDWU (or HDWU)|
|56||AutomaticPostGain||???is this the same as Prwin1 ???|
||A label with 'Full:', positioned to the left of X=88%,Y=10%|
||Value of full point in amount (e.g. mm or ins) units, positioned to the right of X=88%,Y=10%|
||A vertical arrow pointing to the last probe reading...|
||A vertical line at date = BUDBURST (set as global formula)|
The size of ticks and symbol are in units of percent of graph size.
Ticks=2 will give 'standard' ticks with a length of 2% of the size of the graph; ticks=100 will give a grid across the graph.
Format codes are used to set the display format. The value displayed (e.g. mm or ins, and decimal places) will also depend on
|DWU||Daily water use in mm/day|
|AMT||Amount of water in mm|
|VOL||Volume of water in Ml|
|AREA||Area in Ha|
|DEPTH||Depth of reading in cm|
|VSW||Volumetric soil moisture in %|
|EMITRATE||Volumetric soil moisture in %|
|0.0||1 decimal place|
|0.000||3 decimal places|
Other Microsoft format codes (as used in Excel) can also be used.
Different screen layouts can be customised. Each layout is given a name, and can be chosen on.
To customise screen layout definitions use
Ver2 has a slightly different format with more options, but it also has an SPT editor.
|Prior to version 1.0.204||After version 1.0.204||Version 2|
Each line in the SPT file has the format...
LayoutNumber, Column, Type, Source, Width, Format, Align, Units, Title 'Comment
|LayoutNumber||Same number as LayoutName in |
|Column||Screen column number, starting at 1|
|Source||Field name, or formula|
|Width||Width of column in characters|
|Format||Format code for numeric data|
|Align||Left | Right | Centre|
|Units||1 = units (e.g. mm/day); 0 = no units|
|Title||Title at top of column.|
Separate lines with '|'.
Can also include variables e.g.
|Comment||Explanatory text that will be displayed if user right clicks on column title|
Examples of screen column definitions...
|Line||Result on screen|
|start of a new layout called PR41Sites|
In column 1
Site Num 33
In column 5
Refill mm 230
In column 5
Deficit mm 230mm
The lines at the top of the file are set by various options on
These options allow the data to be filtered, only importing a reading every 6 hours, for example
If the data is from continuous logging systems, an irrigation can be automatically posted if there is an increase in soil moisture
There are two types of lines...
Note: ver2 has a different format, but it also has an IPT editor.
The line has the format...
Cn, Format, Start, Width, Row 'Comment
|Cn||Column number e.g. C4|
|Format||G - any numeric|
DT - date and/or time
T - text
|Start||Start of data in characters - not required for delimited data files|
|Width||Number of characters - not required for delimited data files|
|Row||Normally 1, but some loggers output data over more than 1 line|
|Comment||any text as a comment or reminder after a ' is ignored.|
Examples of column definitions...
|Date and time information in column 1|
|General data in column 2 (rain in this case)|
|General data, from character positions 12 to 23 incl, in line 1|
The line has the format...
|On||Output number e.g. |
|Source||Column number (e.g. |
|Destination||TYPE | DATE | R1-R16 | SN | K1-K16 - see examples|
|Calculated||0 = calculated, 1 = just a column|
|Comment||any text after a ' is ignored - can be used for comments or reminders.|
|1 (code for Probe) put in TYPE|
|Date/Time from column 1 put in DATE|
|Value in column 8 put in Reading 1 (probably 20cm reading)|
|Value in column 12 put in Reading 2 (probably 30cm reading)|
|Value in column 15 put in Keydata 4 (temperature ?)|
|Value in column 12 put in Keydata 11 (salinity)|