Additional command-line parameters
The Reporting Module's additional command-line parameters are used to set parameters for a specific report. Most, if not all, standard reports require some kind of parameters: start and end date, grouping, sorting, etc.
Names of report parameters may differ from their labels displayed when reports are run from Alloy Navigator. You can view the actual parameter names of a report by saving the report as the .rdl file and then opening it in Microsoft SQL Server 2016 Report Builder, as described in the instructions below.
TIP: You can download Microsoft Report Builder at https://www.microsoft.com/en-us/download/details.aspx?id=53613.
Parameter names of Microsoft Report Builder reports begin with a letter and contain letters, numbers, underscores (_), and no spaces. In Microsoft Report Builder, parameters of the opened report are typically listed within the Parameters node of the Report Data pane, which is by default displayed on the left side of the Microsoft Report Builder window.
To find out what parameters a particular report requires:
-
In Alloy Navigator Desktop App, click Reports on the menu bar.
-
Right-click a report in the list and choose Save As. Specify the location for saving the report.
-
Go to the location you saved the report to and double-click the report. The Microsoft Report Builder window opens.
-
To see the list of the report's parameters, expand the Parameters node under the Report Data pane.
-
To view the list of possible values for this parameter, double-click the parameter and then click Available Values.
Specifying discrete parameters
NOTE: Microsoft Report Builder reports do not support ranged parameters.
Discrete parameters accept single, discrete values. They are specified for the ReportCmd.exe in the form /paramname=value for each parameter. However, if you want to pass multiple values of the parameter when generating a report, you can do it by separating each value with a semicolon: /paramname="value1;value2;valueN".If the name or value of a parameter contains more than one word, it should be quoted (for example, /"Group By"="Due Date").
The following types of discrete parameters are supported: boolean, string, numeric, currency, date, datetime, time. The formats for specifying values of different types are summarized in the following table:
| Type | Description | Example |
|---|---|---|
|
boolean |
Can be specified in one of these ways:
|
|
|
string |
If a string contains one or more spaces, enclose it with double quotation marks ("). |
|
|
numeric |
Use the decimal separator set in the Windows Regional Options (the period for default English (United States) format). Thousand separators are not allowed. |
|
|
currency |
As a numeric value, without currency symbols. The kind of currency is chosen according to the Windows Regional Options. |
|
|
date |
"yyyy-mm-dd" |
|
|
datetime |
"yyyy-mm-dd hh:nn:ss" If the time part is omitted, then the date part is set to 00:00:00. If the date part is omitted, the date is set to 1899-12-30. |
|
|
time |
"hh:nn:ss" If seconds are omitted, they are set to 00. |
|
A series of macros for specifying date and datetime values is available; for details, see Macros for time range bounds.