Configure Reports

The Reports menu in SmartSimple provides tools to create, configure, copy, delete, restore, and export reports. For field definitions, see Report Field and Settings Reference.

Who: Reports are for any user who understands reporting concepts and is familiar with databases and data relationships, regardless of role.

When to Use Reports

Use reports when:

• Data needs to be pulled from more than one data source, such as combining information from two Universal Tracking Applications (UTA/module) with related contact records. For example, a report that displays reviewer details from a panel review alongside the associated applications.
• Information is needed from historical or log-based data that is not otherwise accessible within the system. For example, a report showing the time applications take between statuses across all applications, rather than one at a time.
• Calculations are required to summarize or forecast data. For example, a forecast report showing upcoming grant payments, broken down by month and grouped by program.

↑ Back to top

Configure Report Permissions

To give a System Role access to the Reports menu and to manage or export report data, configure permissions at the System Role level.

1. Click the System Administration gear in the upper navigation bar, and then select Global Settings from the drop-down menu.
2. Click the Security tab, locate the Business Security section, and click System Feature Permissions.
3. Click the Menu tab.
4. Locate the Reports – Menu Access field and select the appropriate roles from the drop-down menu.
5. Click the Features tab.
6. Locate the Reports – Export Data field and select the appropriate roles from the drop-down menu.
7. Locate the Report – Manager field and select the appropriate roles from the drop-down menu.

↑ Back to top

Create a Report

To create a new report:

1. Click the Menu icon in the upper navigation bar, and then select Reports from the Tools drop-down menu.
   • The Reports page will only be available if the Reports – Menu Access option has been enabled for your role.
2. Click the New Report [+] button.
3. Enter the relevant information in the fields.
4. Click Save.
   • After saving, the page refreshes and displays the full report editing view. The Builder Type field is no longer editable after the initial save. 
   • The system automatically populates the Created By, Last Modified, and Last Modified By fields.

↑ Back to top

Launch the Report Builder

To configure the columns, fields, and criteria for a report, open the Report Builder after saving the report.

1. Click the edit [pencil] icon next to the applicable report.
2. Click the Report Builder [four-square] icon above the report name.
   • The Report Builder opens in a modal window, either Neo or Classic, depending on the Builder Type selected when the report was created.

↑ Back to top

Copy a Report

To create a copy of an existing report:

1. Click the edit [pencil] icon next to the applicable report.
2. Click Save As.
3. Enter a name for the new report and click Save.
   • The system creates a copy under the new name. The copy includes all configurations from the Report Builder, Advanced, Security, File Export, Custom Export, and Report Template tabs.
   • The copy does not include sub-report settings and charts.

↑ Back to top

Delete Reports

Users must have the appropriate permissions to delete a report.

Delete Reports in Batch

To delete multiple reports at once:

1. Click the Menu icon in the upper navigation bar, and then select Reports from the Tools drop-down menu.
2. Click the checkbox next to each report you want to delete.
3. Click the Delete [trash] icon.
4. Click Yes to confirm the deletion.

↑ Back to top

Delete an Individual Report

To delete an individual report:

1. Click the Menu icon in the upper navigation bar, and then select Reports from the Tools drop-down menu.
2. Click the edit [pencil] icon next to the report you want to delete.
3. Click Delete.
4. Click Yes to confirm the deletion.

↑ Back to top

Restore or Purge Deleted Reports

Restoring and purging reports from the Deleted Reports tab requires System Administrator privileges.

1. Click the Menu icon in the upper navigation bar, and then select Reports from the Tools drop-down menu.
2. Click the Deleted Reports tab.
3. Click the checkbox next to the name of the report you want to restore or purge.
4. Click the Restore icon to restore the report or click the Purge [trash] icon to permanently delete the report.
   • If permanently deleting the report, click Yes to confirm.

↑ Back to top

Enable Internet Access (Public Viewing) for a Report

Enabling internet access for a report generates a URL that allows the report to be viewed publicly without requiring a system login. The URL can be linked to a website or distributed by email.

1. Click the Menu icon in the upper navigation bar, and then select Reports from the Tools drop-down menu.
2. Click the edit [pencil] icon next to the report.
3. Click the Advanced tab.
4. Locate the External Access field and toggle Internet Enabled on.
5. Click Save.

After saving, the system automatically generates the URL, Export URL, and Export URL-XML fields. Copy and paste these URLs for use. An optional Access Key field is available to password-protect the report. The system appends the access key to the URL. Change the access key at any time to revoke access.

↑ Back to top

Export a Report

Export reports to external applications and file formats using File Export or Custom Export settings, or schedule automatic exports on a recurring basis.

Configure File Export for a Report

To set up standard file export for a report:

1. Click the Menu icon in the upper navigation bar, and then select Reports from the Tools drop-down menu.
2. Click the edit [pencil] icon next to the report.
3. Click Export in the left navigation.
4. Click the File Export tab.
5. Select an Export Format from the drop-down menu.
6. Complete the remaining fields.
7. Click Save.

↑ Back to top

Configure a Custom Export for a Report

To configure a custom export layout for use with Microsoft Word, Microsoft Excel, or QuickBooks:

1. Click the Menu icon in the upper navigation bar, and then select Reports from the Tools drop-down menu.
2. Click the edit [pencil] icon next to the report.
3. Click Export in the left navigation.
4. Click the Custom Export tab.
5. Complete the Header, Detail, Footer, and File Extension fields to define the export layout.
6. Enter a File Extension.
   • For example, XLS or CSV.
7. Click Save.
8. Return to the Reports list and click the Export icon next to the report name.

↑ Back to top

Schedule an Export for a Report

To schedule automatic report exports to a SmartFolder or SFTP location:

1. Click the Menu icon in the upper navigation bar, and then select Reports from the Tools drop-down menu.
2. Click the edit [pencil] icon next to the report.
3. Click Export in the left navigation.
4. Click the Scheduled Export tab.
5. Select an Export Type from the drop-down menu.
6. Enter an Export File Name.
   • Append a timestamp using date tokens such as [YYYY]-[MM]-[DD].
   • Do not include a file extension in this field.
7. Toggle Activate on.
8. Locate the When to Run section and select a Run Type from the drop-down menu.
9. Select a Frequency from the drop-down menu.
10. Locate the Export to Folder section and select a Folder Type from the drop-down menu.
11. Click Save.

↑ Back to top