HelpCenter

Explore
ADM Report Retrieval Redesign 11-2019
Updated

Introduction

As part of the server release rel-191025-server, new report functionality has been added to ADM which allows you to retrieve reports more easily. You will now have an organized list of reports that can be setup to send as PD or Excel files through email or run on a periodic basis.

The reports themselves have not changed. Only the screens where you set up the report criteria have changed.

 

 

Reports Main Screen

To access the Report Main screen:

  1. Click on the Reports tab on the Home page of ADM. The screen will display two panels, Reports List and Scheduled Reports. (Figure 1)

Image1.PNG

Figure 1 – Reports Main screen

  1. You can view and manage the following new sections in the Reports List panel:
    • FAVORITES
    • RECENTS
    • ALL REPORTS
    • Report categories:*
      • ADMINISTRATION
      • CONSUMER
      • TRANSACTIONS
      • FINANCIAL
      • PRODUCT
      • INVENTORY

*These categories will be expanded when you first open the Reports Main screen.

 

FAVORITES

When you have chosen reports as FAVORITES, they will appear in the FAVORITES section in the Reports List panel.

  • To designate a report as a FAVORITE, click the star next to the eye symbol to the right of the report’s name. The star will turn blue and a copy of the report will appear in the FAVORITES section. (Figure 2)
  • To remove a report from the FAVORITES section, click on the star again.

Image2.PNG

Figure 2 – Reports selected as Favorites

 

RECENTS

The last five reports that you have accessed will be listed in the RECENTS section. You cannot delete reports from the RECENTS section. The reports change on a revolving basis as you continue to access additional reports. Reports in this section can also be designated as FAVORITES or previewed by clicking on the eye symbol.

 

ALL REPORTS

ALL REPORTS contains the search function that allows you to search for a specific report without having to browse through the six report categories. Click on ALL REPORTS to expand or collapse the list of all reports.

 

Scheduling Reports

The Scheduled Reports panel will populate with a grid after you have run and scheduled a  report. The saved information will be shown in the Scheduled Reports grid. The grid will contain these fields: (Figure 3)

  • Report Name
  • Frequency (Daily, Weekly, Monthly Specific, Monthly Relative)
  • Data Range
  • Format (MS Excel or PDF)
  • Created By

Image3.PNG

Figure 3 – Scheduled Reports grid

 

To Schedule a Report:

  1. Click on the report you want to schedule. The report scheduling criteria will display in the left panel. (Figure 4)

Image4.PNG

Figure 4 – Report Scheduling criteria

  1. Choose the date or date range. Setting a time range is optional (if this field is displayed). The default date range is Last 30 days.

Date Range

The following Date Ranges can be set in the Run Report form:

  •  Yesterday
  •  This Week
  •  Today
  • Current and Previous Month
  •  Last Seven Days
  •  Last Month
  •  Last 30 Days
  •  This Month
  •  Last 60 Days
  •  Custom Range
    (If this is selected, the Scheduled Reports grid will show the From Date and To Date in the Data Range column).
  •  Last Week
 
  1. Choose the Location(s).

  2. Click Run Report. The report will display in the right panel. (Figure 5)

Image5.PNG

Figure 5 – Report displayed in the right panel

  1. Click Schedule Report in the upper right corner of the screen. The report scheduling options will display in the Scheduling Form in the left panel. (Figure 6)

Image6.PNG

Figure 6 – Options for scheduling a report

  1. Select the Frequency of the report.

 

Frequency

The following Frequency options will display in the Scheduling Report grid:

  • Daily – The selection will appear as daily. This is selected by default.
  • Weekly – The selection will appear weekly (M/F,S/S).
    (i.e., Weekly with recur Monday through Friday or any combination of days that you choose.)
  • Monthly Specific – The selection will appear as monthly (Day 1, 26, 31).
    (i.e., Monthly with recur on day 1, 26, and 31 of every month.)
  • Monthly Relative – The selection will appear as monthly (1st Sunday).
    (i.e., Monthly with recur on the 1st Sunday of every month.)
  1. Choose the Recipients from a list of ADM users or manually enter comma separated emails.

  2. Select the Report Format: Excel or PDF. Excel is selected by default.

  3. Click Schedule Report. The message “Report Scheduled” will flash in the lower right corner when the report has been successfully scheduled.

  4. Click Done at the top of the screen. The Scheduled Reports grid displays showing your new report. (Figure 7)

Image7.PNG

Figure 7 – Your reports displayed in Scheduled Reports grid

 

To Delete a Scheduled Report:

  1. Click in the row of any report. Editing Scheduled Report options will display in the left panel. (Figure 8)

Image8.PNG

Figure 8 – Editing Scheduled Report options

  1. Select Delete.

The message “Scheduled Report Deleted” will flash in the lower right corner when the report has been successfully deleted. The report will be removed from the Scheduled Reports grid but will still be available in the left panel with all of the other reports.

 

Editing the Scheduling Forms

The Scheduling Form can be used to edit:

  • Scheduled report frequency
  • Format selected
  • Email addresses

The message “Scheduled Report Updated” will flash in the lower right corner when the report has been successfully updated.

 

Reports Previews

To see a preview of any report, tap the eye symbol next to the star by the name of the report. You will see a preview of the report that you selected.(Figure 9) The Report Preview grid will include the following sections:

  • Report Name
  • Description
  • Knowledge Base – links about the report
  • Data Included – types of data included in the report
  • Preview – image of a sample report

Image9.PNG

Figure 9 – Preview of Account Funding report

If a preview is not available, the message “No preview available for this report” will display.

You can access Report Previews by clicking on the eye symbol in the Report List panel, Run Report Form or the Scheduling Form.

 

Run Report Form and Report Results

You will now be able to run reports conveniently without losing your report criteria when you want to re-run the report for different date ranges or locations.

To access the new Run Report form: (Figure 10)

  1. Click on any report in the Report List Panel (left) on the Reports Main The form contains:
  • Name of the report
  • Report Preview icon
  • Date range fields
  • Locations selection fields
  • The Run Report button

Image10.PNG

Figure 10 – Run Report form

  1. Define your criteria. The Results screen will display the results of the report in the right panel. (Figure 11)

Image11.PNG

Figure 11 – The Results screen

  1. You then have the option to export the data to Excel or Print to PDF.

The Results screen will also display these buttons and fields:

  • Done button
  • To Excel button
  • Print button
  • Scheduled Report button
  • Title of the report
  • Date Range