41
©2002-2016, Ido Millet, ido@MilletSoftware.com
Page 69
Range and Multi-Value Parameters
Visual CUT supports all parameter types including multi-value, range, and mixed parameters.
To learn how such parameter values can be specified via command line arguments, save the
report settings in Visual CUT, open Visual CUT.mdb in MS Access and observe the parameter
values saved in the Report_Opt table.
A multi-value discrete parameter value is specified as follows:
---------------------------------------------------
... "Parm1:Competition:::Gloves:::Helmets"
---------------------------------------------------
A range parameter (in this case a date range) is specified as follows:
---------------------------------------------------
... "Parm1:7/15/1996>>>7/15/2003>>>3"
---------------------------------------------------
The 3 at the end indicates the start and end points are included.
A 0 at the end would indicate the start and end points are NOT included.
A 2 at the end would indicate the start point is included and the end point is not.
A 1 at the end would indicate the start point is not included and the end point is.
Add 4 to these values if there is no Upper Bound.
Add 8 to these values if there is no Lower Bound.
For example, this would indicate all dates up to, and including 7/15/2003:
---------------------------------------------------
... "Parm1:12:00:00 AM>>>7/15/2003>>>9"
---------------------------------------------------
The 12:00:00 AM value is just a place-holder. Any date value would work (will be ignored).
Request User Input for Certain Parameters
You can use "ParmN:[?]" command line arguments to indicate that Visual CUT should prompt
the user for certain parameter values. For example,
---------------------------------------------------
... "Parm1:Today" "Parm3:[?]"
---------------------------------------------------
Would set the first parameter to today's date, prompt the user for the 3
rd
-parameter, and use saved
parameter values for all other parameters. This is useful when Visual CUT is called from a
command line and the user needs to interactively override saved parameter values.
Null Values
Null parameter values (for Stored Procedures) are specified in command lines by using the
constant [VC_NULL]. For example, to specify that the first parameter value is null, use:
"Parm1:[VC_NULL]"