50
©2002-2016, Ido Millet, ido@MilletSoftware.com
Page 24
Fields & Formulas Area
Visual CUT automatically detects and lists (sorted alphabetically) in this
area all fields and formulas that are placed (even if suppressed) in
Report or Group Level-1 Headers and Footers (even if the sections are
suppressed). Hovering your mouse over a field provides a tooltip
reflecting the dynamic value associated with that field for either
a) the whole report (if in a report-level section), or
b) the selected group in the Group Values area (if in a Group1 section)
For example, hovering over the {@gr1_header} formula produced the
tooltip shown in the image provided here.
You can drag-and-drop these fields & formulas into the processing
options area to specify dynamic options (options that change their
values based on the report or group being processed).
Also listed in that area are main report parameters that are in use. For
example, {?01?Year} is the {?Year} parameter. The 01 indicates the
position of the parameter in the list of parameters. That position is
important in constructing parameter arguments such as "Parm1:2015".
The dynamic string values provided for parameter fields are converted
from the actual data type of the parameter (Boolean, date, datetime, time,
number, currency, or string). Multi-value parameters are returned as
comma separated values. Range parameters are returned as [from-to]
strings.
If you need more control over the values returned from parameters, create a formula that returns
the parameter value in the desired format (typically using the ToText() function), and place the
formula (suppressed) in the report header or footer.
Since adding current day, month, and year values to options such as export file names and email
subject are common needs, Visual CUT includes in the Fields & Formulas area a list of current
date values (day, month, year) with various variations (number, name, length). This allows you
to avoid creating formulas in your report just to pass current date values to Visual CUT.
Other fields listed in this area include:
{%UserName%}
–
provides the Windows User ID
{[ODBC_DSN:]}
–
provides the ODBC DSN used to override the default DSN for the report.
Notes:
Text objects containing fields/formulas are not included in this process.
Even if the field/formula is suppressed it will be recognized.
Even if the report section is suppressed, the fields/formulas will be recognized.
Report Header/Footer subsections a,b,c,d,and e participate in field/formula detection.
If a Group Header/Footer Level-1 has subsections, only the first and second (GH1a, GH1b,
GF1a, GF1b) subsections participate.
