Creating and Exporting Data Views

The Data View and Download tool allows users to customize views containing specific loan data which can then be exported to Excel and downloaded. It also allows authorized users to create, save, and delete views.

 

Creating a Data View

  1. Decide what information should be included as part of the view then click the Field List to display the Field Chooser.

  2. Drag the fields to be included in the view individually from the Field Chooser to the Loans grid and place them it in order which the information is to be displayed on the view. To remove a field from the report, drag it from the grid back to the Field Chooser.

  3. Enter parameters into the fields below the header to narrow the view. (For example, if the report is to include only those borrowers with the last name of “Tanner”, enter Tanner below the Borrower Last Name field and press the Enter key to display only those records matching the criteria. To further narrow the displayed information, enter parameters into other report fields.

  4. Drag a selected field into the area directly above the header fields labeled Drag a column header here to group by that column to group by that particular field.

  5. Drag another field in order to subgroup within that main grouping. (For example, to group by last name and then sub-group by county, first drag the Borrower Last Name header then the County header.)

  6. Click the Create Filter button and create a filter (if applicable), then click the OK button.

  7. Click the Create View button on the tool bar then enter the name of the view on the Save View screen.

  8. Check Global View (Visible to everyone) to make the view global so everyone can see it (if desired). If not, leave unchecked to save the view as a private view.

  9. Click the Save button to save the view and return to the Data View & Download Tool.   

 

Exporting a Data View

  1. Click the Export to Excel icon after creating the required view to download the data in the required format.

  2. Click OK to display the File Download screen.

  3. Click Open to display the report on the screen, or click Save and select a location to save the file.

 

Deleting a Data View

  1. Click the Delete View button on the tool bar while in the view.

  2. Click the Delete button on the Delete View screen to remove the view.

 

See the section titled Data View & Download Tool in the technical portion of this guide for further details.