Using RapidReports

RapidReports allows you to quickly create a report using a single click. The feature may need to be configured and implemented in order to be available for your installation. Once a default or customized report has been created, it will appear under Build > Automation Tools > RapidReports in the Report Manager page.

RapidReports contains two functions that can be assigned to users. The administrator must explicitly assign access rights to either one or both of these. Depending on the functionality assigned to a role, a user can create default reports from the available list, or create and customize the reports. A report designated as a Global Report can be viewed and run by all users. The functions are:

•Report Manager: Usually assigned to Administrators or super-user roles. Allows you to create a Default report, to clone, edit, and rename Default reports, and to designate a report as a Global report.

•Report Viewer: Can be assigned to any role to allow them to view reports, or to run a Default report, a global report, or any report created for a workspace that they can access.

Any role with access rights can create a report from any workspace where RapidReports is implemented.

Available Formats: Once a report is generated, it can be printed to PDF or HTML.

Using a Saved Search: The data can be sorted and filtered by selecting and running a Saved Search, and then generating a report. To do this:

1.Run the selected search.

2.When the results are displayed, click the RapidReports print icon and use the Default Template to create a report from the search results.

The report displays any column contained in the search, as long as the column also appears in the report template. The search parameters do not impact the columns contained in the pre-configured template. To only display certain columns in a report, you can create a report template that is specific to your requirements. See Use Report Manager to Customize and Edit a Default Template for more information.

Use Report Manager to Customize and Edit a Default Template

Before you begin, remember that the report you produce by clicking on the RapidReports icon, may not exactly match the search you run. The search is created using the List view from the workspace. However, the columns in the report template appear in the order specified within the template. This means that the data you request, is presented based on the pre‑configured report template you selected. To view the data in a different format, or to show only some of the columns, or to view columns in a different order, you need to customize a template for your requirements.

Once a default template has been created, you can edit it to change items such as margins, to customize the logo, and so on. Use the following procedure to create customized templates.

1.Log in to the application using the Administrator role.

2.From Settings > Build > Automation Tools > RapidReports, open the Report Manager page select the default template (or any other template) in order to customize it.

3.The toolbar options are described in the following table.

Icon	Description
	Click the Clone icon to create a clone of a Default report
	Click the Edit icon to change the name of a template and to designate it as a Global template. The Global check box is selected by default.
	Click the Design icon to change the design of the template. •Edit the footer information by clicking the footer and then adding System Variables to display other information. •The columns you see in the Default report (as listed below) are the only columns that you are able to retain for any new reports you create. You cannot add other columns. They are: Incident (displays Incident Number) , Summary, Status, Priority, Customer, Location, Team, Owner, Service, Category, Source, Created On, and Modified On. • When editing a report template or creating a customized template you can delete any columns that you do not need. However, if you delete a column heading (such as Team) then you must also delete the appropriate (associated) table column from the report. •Options in the Style Designer such as charts or graphs, cannot be enabled in Reports and will not work. •Select an item on the report to activate the associated properties that you can edit, in order to change the appearance. For example, font, font weight, or alignment.
	Click the Trash icon to delete the selected template. Once deleted a template cannot be retrieved.
	Click the Reload/Refresh icon to refresh the list.

4.Select the Design icon to open the Properties and to edit the template.

We recommend not changing the basic format. However, you can customize a few basic elements as described in the following table. Most properties can be viewed from the Home tab. The bottom bar lists the default measurement unit used by the template.

Select an element in order to see the appropriate properties in the left pane.

Properties in the Style Designer such as charts or graphs are unavailable and will not work.

Element	How to edit
Logo	If this exists, replace with a company logo or add a logo to the template. You can change the logo directly in the Report Designer or in the Admin UI Branding which will change all logos for any NEWLY created reports. (Any reports created before the branding changes are made will not be updated.)
Measurement Unit	Available from Home tab. Change the measurement units so they are appropriate for your installation. The setting is located on the bottom bar under Properties and is applied to and affects, page size and page layouts. The default is Millimeters but you may want to change the default to inches.
Page size	Select the Page option from Properties and select from the available values for page size (A4, Letter etc.) and margins. If you cannot see the Page option click in the margins of the report example (the white area) that displays in the right pane. From here you can select a default Orientation (Portrait or Landscape) and a paper size (A4 or Letter). Edit Margins by using the following structure: Left;Top;Right;bottom. Example: 1.25;0.5;0.5;0.75 Add a Watermark if required. You can also leave defaults as is, and only edit the settings for other templates.

5.Click the Save icon on the top left to save your changes.

Using Report Manager to Clone, or Customize a Template

To create a customized template it is recommended that you clone the Default template, then customize it as needed. You can also customize the default template before you clone it, as described in Use Report Manager to Customize and Edit a Default Template.

1.Log in to the application using the Administrator role.

2.Open the Configuration Console and from Settings > Build > Automation Tools > RapidReports, open the Report Manager page and click on the Default Template - Default

3.Click the Clone option from the Report Manager to clone the template, then edit it.

Or, from the application, as any user with access to Report Manager, click on RapidReports > Report Manager to open a template designer, and create a new global or personal template.

Other Report Manager Options

Once the feature is configured you will see a full list of Forms in the Report Manager.

•Search and Filter

Reports can be searched for or filtered, by report name or report type. The options are as follows:

Item	Description
Type	Select a checkbox in the list to filter your choices.
Source name	Enter a source such as Incident or IncidentLayout to see the forms associated with that source. The source name is usually the name of the item as it appears in either the gridView or formView (i.e. from where it was generated).
Report name	Enter the first few letters of the report name to see the choices.
Owner	Enter the owner name as it appears in ISM, to see all templates owned by that user.
Show global only	Check this box to see only templates designated as Global.
Reset Filters	Click to reset the search parameters to the default.

•Export or Import Reports: Export a report to a JSON file or import a JSON template into the system by selecting the Export or Import icons on the top left.

•Print: A generated report can be saved to PDF.

•Email: Send the report in email by using the Email option after a report is generated.

•All columns that you see in the default list view will appear in the report. Hiding them won't hide them in the report. However, you can create a template that only includes the columns you need. For example, Incident Number, Summary, Customer Name, and Owner. See Using Report Manager to Clone, or Customize a Template for more information.

•You can scale to select one page or the whole report. Selecting the option to load a report page by page is the quickest way to view it. Loading the full report (if it consists of multiple pages) may take some time. The one page view is the default option.