You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
You are viewing the article in preview mode. It is not live at the moment.
Custom Reports - Working with Custom Reports

Overview

Custom Reports module provides an intuitive, self-service environment for gathering, formatting, and presenting your budget data. Built to simplify financial communication, the reporting engine enables users to tailor reporting views specifically for budget owners, municipal council, and public stakeholders.

Key Features

  • Folder Management: Organize reports using folder structures and save frequently used reports as favorites.
  • Multi-Level Hierarchical Display: Group data using existing multiple levels such as Tree or Segments with structured ordering
  • Read Mode: Present financial data directly from your browser with expandable groupings and real-time data expansion during live presentations.
  • Segmented Page Generation: Utilize page selection capabilities to generate multiple report instances segmented by specific Tree or Related Segments.
  • Multi-Format Exports: Export final reports directly to PDF with various page controls like sizes and headers. Options also exists to export to Excel or a CSV file.

Navigating Custom Reports

The Custom Report screen is where new Custom Reports can be added/deleted, existing Custom Reports can be organized into folders and Custom Reports can be marked as favourite.

 

Folders - are a visual way to group similar Custom Reports together. All folders are created and managed by the end user and once a Custom Report exists it can be added to a Folder. 

Important areas:

  1. Search Bar - refine the list of Custom Reports and Folders based on the text searched.
  2. Sorting & Filtering - sort a column by clicking the title. The filters allows for quick search operations like 'begins with' or picking specific values like Yes/No.
  3. Tools - These are operations that apply to the table. The tools include Refresh, Toggle Groups and Add.
  4. Actions - This column allows you to interact with a single Custom Report. The possible Actions are Run Report, Copy Report, Edit Report and Delete Report.
  5. Favourite - Mark individual Custom Reports so that they can be quickly accessed.

Add a New Custom Report/Folder

  1. From the the Tools press the  icon.
  2. This will give you two Options:
    1. New Report - a dialogue to create a New Custom Report will be shown. Please see the Related Articles below for assistance with this.
    2. New Folder - a dialogue will ask you to specify a name before accepting.  
  3. The Folder of Custom Report will be added to the table.

Move a Custom Report into a Folder

  1. You can move a Custom Report using the Drag and Drop icon as seen in this image.
  2. The only supported operation is moving a Custom Report into a Folder, or out of a Folder.

Duplicate an existing Custom Report

  1. In the Actions column of the table press the  icon on relevant Custom Report.
  2. A new dialogue will appear where you will need to provide a new name for this copy and press the Save button.

Note: Custom Reports are allowed to have the same Name provided they are in different Folders.

Filter Favourites

Once Custom Reports start to be marked with Favourites follow these steps to quickly see them.

  1. .Click the Filter button on the Favourites column 
  2. Uncheck No and ensure that Yes is checked.
  3. Press the Apply button.
  4. Now only the Custom Reports table will only show Custom Report (and their respective Folder) in the table.
  5. There is also a Reset on the Filter button on the Favourites column. This will return all Custom Reports.
Related Articles: Custom Report - Design
Related Articles: Custom Report - Run Report