Printable Reports

On this page

Alloy Navigator has two kinds of printable reports. A summary report is a list report: it appears in Reports > Printable Reports. A detail report belongs to one type of record, such as incidents or assets: it does not appear in the Reports section, and you run it from the print button of a record of that type. Both kinds open in a new browser tab, on the same report page.

In the Web App

Before you begin

  • Which reports are listed for you can depend on the view permission of the object types that the report file lists, for example tickets. In most cases this is the right to view any record of that type: a technician who can see only their own incidents does not qualify for an incident report. See Security Roles and Permissions Reference.
  • Opened without a record, the report page checks your right to view reports. Opened for a record, as a detail report is from the print button, it checks your report right for that record.

Find a summary report

Go to Reports > Printable Reports. By default, the list shows one column, Name, sorted in ascending order. The category tree on the left filters the list by category. The tree starts with two fixed rows, All Reports and Uncategorized; a report with no category appears under Uncategorized. One report can be filed in several categories. In a new database, the supplied Reaction Time report is filed under Uncategorized only, and User Session under Service Catalog Management.

The list does not show a report's format, its categories, or the permission it requires.

An upgrade can add categories to the tree. The summary reports that an upgrade inserts are filed into New in Alloy Navigator <version> or Updated in Alloy Navigator <version>; see Report Settings. A database upgraded from Alloy Navigator version 6.5.1 or earlier has a Legacy Reports (Alloy Navigator 6) category, and every top-level report category that existed before that upgrade is moved under it; see Changes for older databases. A database migrated from Alloy Navigator Express has a Legacy from Alloy Navigator <version> category, named for the version it was migrated from, that holds the customized summary reports kept from before the migration.

Run a summary report

  1. In Reports > Printable Reports, click the report. It opens in a new browser tab.
  2. If the report has parameters you can change, a parameter panel opens before the report renders. Fill in the fields and submit the panel. Required fields are checked in the browser first; if one is empty, a message box appears and the report does not run.

If the report has no parameters you can change, it renders at once.

Only reports in the Microsoft Report Builder format run on the report page. A report stored in another format, such as a .rpt file from an older report engine, can still be listed, but its link leads to a page that the Web App does not include, so the report does not open.

Run a detail report from a record

  1. On the toolbar of a record, click the print button (titled Report). A menu lists the visible detail reports for that record type. It shows "Loading..." while it fetches the list, and "No Actions" when there is no report.
  2. Click a report. It opens in a new browser tab for the record you started from. If the report has parameters you can change, the parameter panel opens first, as for a summary report.

On Knowledge Base articles and announcements, a click on the print button prints the record instead of opening the menu while no report list has been loaded yet or the loaded list has no visible report; the button then has no drop-down arrow. The print button does not appear on PO Item records.

When a create action opens the full form of a new record, that form has no print button until you save the record for the first time. The first save opens the saved record's own form, which has the print button unless the record type hides it.

Report parameters

Parameters vary by report. For example:

  • The supplied Asset Barcode Labels report asks for a barcode type: "Use Code 39" (the default) or "Use Code 128". Code 39 encodes the asset tag and leaves out any character other than digits, upper-case letters, space, and -.*$/+%. Code 128 encodes the asset's barcode field.
  • The supplied Customer Satisfaction Rating (Incidents) and Customer Satisfaction Rating (Service Requests) reports ask for "Date From:" and "Date To:", which select tickets by their submit date, and a "Group By:" choice, such as Type, Category, or Assignee (the default). In the Service Requests report, both dates can be left empty. They count only tickets whose rating you may see: the View All Ratings permission shows the rating of every ticket, and View Own Ratings the rating of a ticket assigned to you.
  • The supplied Asset Barcode Labels and Asset QR Code Labels reports filter by asset type and by category, one value each, with "Show All" as the default. They list statuses, organizations, and vendors with nothing selected. Each of these three lists is required: select at least one value in each before the report runs. Both reports leave out assets in the Inactive status.

The supplied Asset QR Code Labels report takes each QR code image from the outside web service api.qrserver.com over plain HTTP, and sends it the barcode field of each asset it prints. Whatever fetches the image therefore needs access to that service. An asset with no barcode gets no QR code.

A parameter named exactly ID is reserved. On a detail report it is hidden from the panel and filled with the record the report was opened from. A summary report that declares a parameter named ID does not open; you are taken to an error page instead.

Export or print a report

The report page shows the report viewer's toolbar, with its export menu, its print button, a find box, and page navigation. The export menu lists the formats that the Microsoft report viewer control offers; the Web App does not filter them. To export the report, choose a format in the export menu; the report is downloaded as a file in that format. The find box's Next button is unavailable while the search text is empty or a search has found nothing, and you cannot type in the page-number box.

The page replaces the viewer's own refresh control with a Refresh button:

  • After you have submitted the parameter panel, Refresh restores the values you submitted, for up to one hour. A report with no visible parameters then runs at once; a report with visible parameters opens the parameter panel again, filled in with those values, and runs when you submit it.
  • A second Refresh without submitting the panel in between reads the report's own parameters again.

Where reports run

The Web App renders a report itself, with its own copy of the Microsoft report viewer control, processing the report locally. It reads the report definition and runs the report's queries on the Web App's own connection to the Alloy Navigator database, whatever data source the report file names. It does not use the Report Viewer 2016 runtime.

Reports run on a schedule are rendered by a separate report engine that the Automation Server runs; see Scheduled Reports. That engine needs Microsoft Report Viewer 2016 on the computer that runs it; the Web App does not. Because the two render reports differently, a report that renders in the Web App can still fail when it runs on a schedule, and the other way round.

Manage summary reports

The Printable Reports toolbar has four controls: New, Delete, Rename, and Organize, whose menu holds Save, Replace, and Categories. Three report rights control them:

  • New needs the create right.
  • Rename and every Organize item (Save, Replace, Categories) need the modify right.
  • Delete needs the delete right.

A control you may not use is disabled, not hidden. Its tooltip reads "Permission denied" when you lack the right (for New, always this reason), and "No records selected" when the selection does not fit: Rename, Replace, and Categories work on exactly one report, Delete and Save on one or more.

Add a summary report

Custom reports are designed in Microsoft SQL Server Report Builder and added as .rdl files.

  1. In the category tree, select the category you want the report filed under.
  2. Click New and choose an .rdl file. The report is uploaded into the selected category.

To change the categories afterward, use Organize > Categories.

When a size limit for a single attachment applies, an .rdl file at or over it is not uploaded, whether you add it with New or with Organize > Replace. The upload is refused with a message that begins "The size of the file you are trying to upload exceeds the size limit for a single attachment". See System Performance.

A report runs on the report page only when every dataset is embedded in the report file and every query parameter is a plain reference to a report parameter (=Parameters!<name>.Value). Otherwise the report stops with a message:

  • A shared dataset: a message that begins "Could not retrieve data for the report. Only embedded datasets are supported."
  • Any other query parameter value: "Can't parse query parameter expression:", followed by the expression.

The report's "Use single transaction when processing the queries" setting is ignored.

Rename, replace, save, or delete a summary report

  • Rename opens a Rename dialog: "Enter a new name for the report:", with a Name field filled in with the current name. The Rename button is unavailable while the field is empty.
  • Organize > Replace opens a file picker for an .rdl file and overwrites the selected report's file.
  • Organize > Save downloads the file of every selected report.
  • Delete opens a Delete dialog, "Are you sure you want to delete the selected item(s)?", and deletes every selected report after you confirm.

Organize summary reports into categories

  • Organize > Categories opens a flyout listing the categories of the selected report, where you add or remove categories. Adding opens a picker that offers every report category. The Printable Reports list updates at once.
  • The category pane's plus button (titled New) holds New Category, which creates a category beside the selected one, and New Subcategory, which creates one under it. Categories nest without a depth limit. Creating a category needs the edit right for reports.
  • The pane's Open button holds Move to top level (available only for a category that has a parent), Move to category, which opens a Select object from list category picker, Delete, and Properties.
  • Fixed categories cannot be edited, moved, or deleted. Report categories cannot be reordered and cannot be marked as public or internal.
  • Deleting a category also deletes every category under it and removes the links between reports and those categories. It does not delete any report; a report that was filed only in the deleted categories then appears under Uncategorized.

Manage detail reports

Detail reports belong to a record type, not to one record. You manage them from any record of that type.

  1. On the record's toolbar, click the print button, then click Manage Reports... at the foot of the menu. The Manage Reports flyout lists the detail reports of that record type in two columns, Name and Visible.
  2. To add a report, click New and choose an .rdl file. It is added as a detail report of the record type.
  3. To show or hide a report in the print menu, click its Visible button. The change applies at once, without a prompt, to every record of that type. A hidden report stays in the flyout.
  4. For other actions, point to the report's row, click More, and choose Open, Download, Rename, Replace, or Delete. Rename and Replace work as on the Printable Reports toolbar, and Delete asks for confirmation first.

New needs the right to add reports. Rename and Replace need the modify right, and Delete needs the delete right; without it, the action is disabled with "Permission denied". Open and Download need only a selected row.

New and Replace in the flyout refuse an .rdl file at or over the size limit for a single attachment in the same way as on the Printable Reports toolbar.

The 6.5.1 upgrade step (run for Alloy Navigator version 6.5.1 or earlier) hid every detail report the database held at that time. In a database upgraded from Alloy Navigator version 6.5.1 or earlier, show those reports again with the Visible button. See Changes for older databases.