Reports - Overview and Basics

Topics Covered:

• Getting Started
• Running a Report
• Viewing the Report
• Selecting, Formatting, Filtering, and Data Fields
  • Data Sources
  • Filters
  • Running Your Report with "Ask Me" Filters
  • Formatting the Report

Introduction

There are many types of reports already seeded in your database. They cover just about every basic reporting need. This means that you are never more than three or four clicks away from gaining powerful insights into any area of your platform.

Reports can be easily formatted and filtered. You can reformat them as much as you want. Conveniently, you can edit filters on the Run Screen to quickly look at different data sets.

Getting Started

Login into the Administrative Console of your Database and click the Reports button. You will see a list of all of seeded reports.

Running a Report

To run a Report, select the Visualize Report button on the Reports page.

This will open the Visualize Report window, where you can view when the report was last run. On this window, you can select the Visualize Report button to view the report in the browser window, select the Download Raw Data button to view the report in an Excel document, or select the Mail button to run the report and have it emailed to a list of recipients.

Viewing the Report

With the report open in the browser, you can filter columns by using the filter options on the right, open the report in a new tab (Open in New Tab button), or export the report into an Excel file (Export button).

Selecting, Formatting, Filtering, and Data Fields

To change what information is pulled back on your report, you will need to edit the Report Fields. To do this, select the Edit Fields icon (this icon can be found throughout reporting and will always have the same function).

This will open the Report Editor window where you can select and format data fields for the report. Every selected item in the Data Sources will appear on the report. 

Important! When you create a report, you will be asked to select a Report Type. The Report Types will narrow down the available Data Sources. Some Data Sources will be unavailable to use depending on which Report Type is selected. If you are struggling with creating a report, please reach out to Configio Support.

Data Sources

Data fields are grouped by their source (these are called Data Sources). Each Data Source has available options that can be selected to be included in the report, or unselected to be removed from the report.

Pro-Tip! Hover over a field to see a tooltip containing its description. If you don't see the field that you are looking for, use the search fields at the top of each Data Source (to search for fields within the Data Source) or the search field above the Data Sources to search for fields in all available Data Sources. 

You can use the Check All button to include or exclude all fields in a source. If no fields from a source are included, then you can remove the source via the X icon on the Data Source. 

Select Save when you are done to save the report or Save & Run to save the report and visualize it. To add or remove Data Sources select the Add/Remove Data Sources button. Select the tabs to add sources from the System Sources, from Forms, and from Account Membership Groups, Peer Groups, and Custom Report Fields (these must be built out ahead of time). Select the source that you want to add and uncheck any source that you want to remove. Select the Save Data Sources button when completed.

You can further customize the report by rearranging the column order, renaming the columns, sorting, and hiding columns.

Order columns by dragging and dropping fields. The first field will be the "A" column, the second will be "B," and so on.

To change the name of the column header, insert the desired name into the Alias field.

Changing the Sort Order will change how the data rows are arranged. Input or toggle a sort order, and choose ascending or descending. The Report will sorted by the "1" field, then by the "2" field field, and so on.

If Visible is selected, the column will default as unhidden in the Excel document. If Visible is unchecked, the column will default as hidden in the Excel document, but can still be opened.

If you decide a specific column is no longer needed, you can select Delete to quickly remove the data from your report.

As always, it is recommended that you Save often when making changes or creating a report. 

This knowledge article provides information on specific Configio features. To ensure continuity with documentation and product functionality, Configio reserves the right to amend or update this knowledge article as needed. For more information, reach out to Configio Support.