Skip to main content
Eptura Knowledge Center

Reports

The Reports allows you to access a wide variety of default reports for all modules. 

  1. You can either search for a report or navigate the list to the report.

clipboard_e96ea449aa70409810ff855ae6f89af7c.png

  1. Click the report you want to display.

When your report displays, the following can be completed:

  • Export your Report
  • Filter Report Data
  • Sort a Column
  • Move, Resize, and Hide Columns
  • Set Output Scale
  • Navigate the Report Pages

Addition, you can schedule the report.

Export your Report

The Reports Module provides the ability to export your report in a variety of types. While this is optional, if you would like to export your report, perform the following:

  1. After you have selected your report from the Reports Overview Screen, select the Export icon. A list of export options appears in the drop-down menu. 

clipboard_e303121bc8a6b05051649a8cfb2ddf20e.png

  1. Select your preferred export type. 

The preferred export types are explained in the table below. 

Option Format Name Usage

PDF

Adobe Acrobat

To prevent horizontal truncation of a report when exported, set the Actual Size option in the Report Editor.

XLS

Excel (Paginated)

Not recommended for exporting most tables or crosstabs. Repeats headers and footers on each page.

XLS

Excel

Ignores page size and produces spreadsheet-like output.

CSV

Comma Separated Values

Characters outside the Latin 1 character set can cause the Excel spreadsheet to look unacceptable. Try using the file and importing it using Excel’s Import functionality.

DOCX

Word

Do not export reports having more than 63 columns. In Microsoft Word, you cannot create tables having more than 63 columns.

RTF

Rich Text Format

Creates a large output file, yet takes a little longer to output (e.g. a PDF output). 

ODT

OpenDocument Text

For best results, minimize the number of rows and columns and make sure they don’t overlap.

ODS

OpenDocument Spreadsheet

Same as ODT.

XLSX (Paginated)

Microsoft Open XML Format Spreadsheet

Ignores page size and produces a spreadsheet output.

XLSX

Microsoft Excel

Produces a Microsoft Excel spreadsheet.

PPTX

Microsoft PowerPoint

Allows you to export as a Microsoft PowerPoint slide.

  1. Save the report in the export file format (e.g. PDF), or open the report in the application.

Filter Report Data

  1. As you run your report, click the column you want to use for filtering the report. 

reports_filter_report_1c.png

  1. Click the reports_filter_icon_1a.png. The Filter column appears. By default, Show all rows is selected. 

reports_filter_column_1e1.png

  1. To build your filter, click the radio button to select Show only rows where

  2. Select a comparison operator from the drop-down. 

reports_comparison_operator_1a.png

  1. Enter a value for comparison with the data in the column and click the OK button.  The view of report changes to show your filtered output.  

  2. A small star icon appears in the heading of the filtered column, to the right of the heading text. To clear the filter indicator and once again display all the accounts, reopen the Filter column dialog and select Show all rows, then click OK

Sort a Column

You may also sort your report information alphabetically in ascending or descending order.

  1. Click the column you want to use for sorting the report. 

  2. Click the reports_ascending_1.png (sort ascending) or reports_descending_1.png (sort descending). The report refreshes and the data appears sorted by the selected column.  

Move, Resize, and Hide Columns

Columns are easily moved, resized, and hidden in your report.

  • To move a column, click the column you want to move, then drag the column left or right into the new position. The reports_drag_column_1.png indicates where the column is placed.

reports_moving_columns_1a.png

  • In order to resize a column, click the column you want to resize, then drag the reports_drag_column_1.png until the column is the size you want. 

  • To hide a column, click the column you want to hide, then move your mouse over the reports_formatting_icon_1.png and select  Hide Column.    

reports_hide_column_1a.png

Set Output Scale

You can determine the display size for any report by using the report scaling options, located in the Report Viewer toolbar. 

  • Click reports_increase_size_icon_1.png to zoom in on the report.
  • Click reports_decrease_size_icon_1.png to zoom out on the report.
  • Click reports_increase_size_report_icon_1.png to open the Zoom Options drop-down menu, and select the percentage by which you want to increase or decrease the size of the displayed report. 

Navigate the Report Pages

If your report has multiple pages, you can use the pagination controls to move through the report quickly.

To navigate the published report:

  • Use reports_previouspage_icon.png to navigate to the previous page.
  • Use reports_nextpage_icon.png to navigate to the next page.
  • Use report_movetoend_icon.png to go to the end of the report.
  • Use report_movetobeginning_icon.png to go to the beginning of the report. 
  • If you know the number of the page you want to view, enter the page number in the Current Page indicator box.