How to Customize the Settings of a Custom Report

How to Customize the Settings of a Custom Report

Custom Reports have a number of settings that can affect how they export.

Schedule

Schedule lets you set up a recurring pattern that the report will use to run itself and email itself to each email address specified.

Currency

Currency lets you set the type of currency the report will apply to any money-based fields. You can choose between:

  • Default User Currency will use the currency set up in your User Preferences.
  • (CAD) Canada, Dollars will use Canadian currency, regardless of your User Preferences.
  • (USD) United States of America Dollars will use United States currency regardless of your User Preferences.

Export


The Export tile deals with how the report will display fields that collect multiple values when you export the report as a spreadsheet.

  • Expand to multiple rows and repeat common fields
    This option will give each value its own row on the spreadsheet. Any columns that are the same between different rows will be filled in. So, your report might look like this:
  • Expand to multiple rows, do not repeat common fields
    This option will give each value its own row, but repeated information will be left blank. So, your report might look like this:
  • Collapse to a single row, using a delimiter
    This will put each value on the same row rather than expanding to multiple rows. So, your report might look like this:
  • Include currency symbols with monetary amounts?
    This Yes/No option will determine whether or not the export will include currency symbols where appropriate.
  • Attachments to include when sharing by email?
    These checkboxes allow you to set whether a report shared by email will attach the whole report, or just specific sections, based on your needs. It also informs you what format the individual sections will use.

PDF Format


Looking at the image above, you can see that the 3 checkboxes by Include are the first 3 tabs of the report. The ones you check will be the sections included in the PDF export. Details is the primary data of the report, Summary is the statistical information based on the Details, and Visualization is the charts and graphs based on the Summary.

Overflow Page Order determines how it will handle things if the report would be more than 1 page wide:

  • Down, then over will create a PDF that goes all the way to the end of the report for 1 page width, then do the next page width all the way down to the end of the report, and repeat that pattern as needed.
  • Over then Down will go all the way across the report then drop down and go across, repeating until it finishes the report.
  • Fit to Page will minimize the space each column takes up in order to fit the columns on one page. This is usually the option you will want to use.

Font Size determines the size of the text in the report.

Padding determines how much “white space” will be above and below each line.

Include Row Numbers will add numbering to each row in the report.

Repeat Headers will add the headers to the top of each page, rather than only at the top of the report itself.


    • Related Articles

    • Report Summary

      The report summary, is a pivot table representation of significant statistics in a report. Groupings define the attributes you want to group the report summary by. Calculations define the aggregated statistics displayed for the attributes. Gorilla 5 ...
    • Custom Fields

      Custom Field Types: Text - creates a text field with a name you choose when setting the field on an entity. Number - allows the user to enter a number when setting the field on an entity. Currency - allows the user to enter a monetary value when ...
    • How to Change Ownership of a Custom Report

      Whoever owns a Custom Report will be able to see that report in their My Reports tab of the Reports Workspace. You can change the ownership of a Custom Report so another person can access it from their My Reports tab: Find the report in the Report ...
    • Report Builder

      Use the Report Builder to define or edit a report. Launch the Report Builder by clicking the Add Report button   on the top right of the Reports data table or by clicking the Edit Report button   for an existing report. The Report Builder displays a ...
    • How To Edit Custom Fields in G5

      Navigate to the Customizations Workspace, and go to the Custom Fields tab. Click the Edit button on the Custom Field you want to make changes to. Make any changes you need to, then click OK when finished.