Aquantify

Help updated for Aquantify v3.2.0.254

Manage report definitions

Use Data > Reports to maintain report definitions. The editor and designer require Setup Reports permission.

Define a report and its parameters

  1. In the left pane, double-click an existing report or select it and choose More > Edit. To create a report, click the Add new plus icon.
  2. In Attributes, enter a unique Name and a description. Review Active.
  3. Under Basic, select Roles to restrict access. Users need any one of the selected roles and the required reporting permissions. Leave Roles empty to allow everyone with those permissions to access the report.
  4. In Parameters, click Add for each input the report needs. Enter its name, data type and a representative Design value.
  5. Click the Attributes page’s Save before working with the saved definition’s queries, schedules or template.

Role assignments control who can run a report and access its generated outputs. Users with Setup Reports can manage every definition.

Report Attributes page showing the setup tabs, report name, Roles picker and parameter design value
The example shows the Roles picker under Basic and an integer IssueId parameter with a design value of 17.
InputWhere it is used
Name and data typeDefine the inputs offered when a user runs the report and when a schedule is configured.
Design valueProvides a representative input for working on the report template.
Run or schedule valueSpecifies the actual scope of that report execution.

Excel queries

The Excel queries tab defines datasets for Excel (from queries) output. Add a query, enter its Name and SQL, then Save. The query name becomes the worksheet name, so use a short, clear name suitable for Excel. Edit or delete queries through the row controls.

Excel query dialog identifying worksheet Name, SQL and final Save action
Query-based Excel output uses these datasets rather than the report’s page layout.

Use SELECT queries and report parameters with matching names, such as @IssueId for the report’s IssueId input. Aquantify validates the query and its parameter references. Choose a dataset and conditions that return the intended records; use explicit units, dates and identifiers in exported data.

Open the template designer

  1. Save the report definition and its parameter design values.
  2. On the Attributes tab, look at the right side of the Basic header. Click the document icon labelled Edit template in its tooltip. It is immediately to the left of the circular Reset template icon.
  3. FastReport Online Designer opens. Edit the template, use Preview to check it, and click the designer’s Save icon. Then return to Data > Reports and run the report with representative inputs to check the output.
An arrow points to Edit template in the Basic header on the Attributes tab, immediately left of Reset template
Edit template appears in the Basic header once the definition has been saved.
FastReport Online Designer toolbar with the green Preview button and the Save icon on the top bar
Preview checks the layout. The disk icon on the blue bar saves the template.

For bands, fields, formatting and page layout, use the FastReport Online Designer documentation. Aquantify’s guide covers the report definition, inputs, outputs and scheduling.

Maintain an existing definition

Use Show inactive to find disabled definitions. Check existing schedules when changing parameters or datasets; those schedules also need suitable values. Query and schedule dialogs save their changes when their own Save action completes.

See Run reports and Schedule reports.

Browse or search all help topics →