Administration Guide

Report Parameters

The majority of standard reports have parameters, which are static or dynamic values you supply to the report, such as start and end dates, grouping and sorting options, etc. In order to generate a report, you must assign values to those parameters.

NOTE: When a reporting job runs, it uses a standalone command-line tool (ReportCmd.exe) for generating reports. The ReportCmd.exe utility is installed in the product’s installation folder, which is typically C:\Program Files\Alloy Software\Alloy Navigator 8\Bin\.

INFO: For more information on the Standalone Reporting Module and its parameters, see Help: Reporting Module.

You specify report parameters when you configure basic settings for reporting jobs. You can assign static values to report parameters, for example:

  • /"Group_By"="Operating System"
  • /"Minimal Unit Cost"=100
  • /Time=12:00:00

NOTE: If the parameter name or value contains spaces, it must be enclosed in double quotes.

Clearly, static date and time values offer little practical value for automatically generated reports, particularly for date range parameters. This is where you should use macros, as follows:

  • /Date_From=BOLM
  • /Date_To=EOLM
  • /Time=BOD

NOTE: BOLM, EOLM, and BOD are special macros returning the timestamp of the Beginning Of Last Month, End Of Last Month, and Beginning Of (current) Day, respectively. For the list of supported date-time macros and their values, see Help: Date-time macros for parameter values.

Assigning Parameters

When you configure a job for a Microsoft Report Builder report, you just need to click the Build button, and Alloy Navigator will automatically prompt you for report parameters. All pre-packaged reports are Microsoft Report Builder reports, also called Report Definition Language (RDL) reports.

In order to enable Alloy Navigator to access report parameters, you must have Microsoft Report Viewer 2016 Runtime installed on your local computer. Typically, this component is installed together with Alloy Navigator.

NOTE: Microsoft Report Viewer 2016 Runtime requires the Microsoft System CLR Types for SQL Server 2016 component, which is also shipped with Alloy Navigator. For details, see Installation Guide: Reporting.