Reporting

In Aspire, reports allow team members to select, summarize, and display information to provide understanding and support decision-making. There are four different categories of reports in Aspire based on how they are implemented: 

• Standard Reports
• Search Lists
• Pivot Table Reports
• Built-in Reports

While many reports are scattered throughout Aspire, this page focuses on the ones that are gathered on the Reports screen.

Standard Reports

Aspire provides standard reports that are rendered in a fixed standard format. Depending on the nature of the report, they provide some parameters (such as time period, branch, or division) on which the information in the report can be filtered. Most of these reports can be found on the Reports screen though a few are available elsewhere in Aspire. Standard reports may only be generated and printed in PDF format.

Standard reports provide drill-down capability so that if you click on specific numbers within the report, Aspire will show a search list comprised of entity records that comprise the selected number. For example, at the End of Month Report, if you drill down into the enhancement revenue for all branches Aspire will display a search list comprised of all work tickets that contributed to that enhancement revenue. This capability allows further analysis based on the details behind the report.

The following table summarizes the standard reports available in Aspire.

Search Lists

Search lists provide a mechanism for displaying selected fields of information about a specific entity in Aspire such as a property, an opportunity, or a work ticket. There are roughly 40 different entities represented in Aspire for which search lists can be created. Some entities have multiple search lists. For example, work tickets have a general search list available in the Aspire Navigation Bar, another search list available on the Schedule Board for scheduling visits, and several search lists available as drill-downs in other reports.

Search lists provide the following methods to output from Aspire. These can be found under the Moredrop-down to the right of the Search list screen:

• Print (to screen/printer or .PDF to screen (then to the printer) 
• Export to Excel (.XLS or .XLSX) 

Most search lists in Aspire allow you to drill down into any line item represented in the list to see additional detail. The screens displayed when you drill down are dependent on the type of item represented by each row of the list.

The article Creating Search Lists in Aspire enumerates all search lists in Aspire and shows how to navigate to them.

Search lists have many uses within Aspire including:

1. Looking up information about an entity (i.e. opportunity, property, etc.)
2. Reviewing a selected list for an entity to ensure that processes are being properly completed (i.e. create a list of all older received purchase receipts to determine if vendor invoice has been received and should be approved)
3. Determining work that needs to be completed (i.e. using the Purchase Assistant to determine what purchase receipts need to be created)

The article Creating Custom Fields provides definitions of many of the fields available in search lists throughout Aspire. It describes some of the key fields especially those related to dollar values and commonly used dates and demonstrates their use within Aspire search lists. The webinar also explains the use of advanced search formulas that allow you to define new calculated fields that become available in search lists.

Mobile Forms Report

The Mobile Forms Report is a special case of search lists. This search list allows you to view data entered by crew leaders based on custom mobile forms defined by the company.

When the Mobile Forms Report is initially displayed, Aspire requires you to select a search view from the available drop-down list. By default, there is a system search view (having the suffix, “[System]”) automatically defined for each form version for which data has been entered in the Crew Mobile App by a crew leader. Additionally, you can customize and save additional search views in the same way that you can for other search lists.

Once a search view has been selected from the drop-down list, the Mobile Forms Report screen takes on the familiar look of a typical search list as depicted below.

Unlike other reports on the Reports screen, when you save a report, it is added to the Select Search View list within the report instead of to the Favorite Reports list.

Pivot Table Reports

Pivot table reports provide a reporting mechanism for quickly filtering, grouping, and summarizing data at different levels for analysis. They are primarily designed to be interactive in nature. Pivot table reports are available on the Reports Screen.

The pivot table reports section provides two different options for displaying each report – the report title which is a hyperlink, and the adjacent arrow icon. Clicking the hyperlink will display the pivot report in the current browser tab replacing the Report screen. Clicking the arrow icon will display the pivot report in a new browser tab.

Pivot table reports may be exported as PDF files or Microsoft Excel spreadsheets.

Built-In Reports

Built-in reports represent reports or documents available throughout Aspire that are specifically designed for printing, and whose print format can be customized for the company by the AspireCare team. Some common built-in reports are invoices, purchase receipts, and statements.

When printing is initiated for any of these reports, they will be displayed/printed in PDF format. If you have chosen Choose Report Export Type permission, they can write the report in any of the following formats:

• Portable Document Format (.PDF)
• Microsoft Excel (.XLS or .XLSX)
• Web Page (.HTML)
• Image (.PNG)
• Web Page Archive (.MHT)
• Rich Text Format (.RTF)
• Text (.TXT)

The following table identifies these reports.