Guided Reports

Use the guided reports engine to create non standard reports. This feature aims to provide some middle ground between the built in canned reports and writing custom SQL reports.

Build And Run Reports

Reports Dictionary

Use the reports dictionary to define custom criteria to use in your reports

Load Saved Reports

Choose the report to run from the list

Report NameTypeNotesSaved ResultsSaved SQLDelete
&phase=Run%20this%20report"> "> &phase=Show%20SQL">Show SQL &phase=Delete%20Saved">Delete

Build A Report

Step 1 of 6: Choose a Module to Report on


Build A Report

Step 2 of 6: Pick a Report Type

">

Tabular:

Step 3 of 6: Select Columns for Display

Note: Be careful selecting when selecting columns. If your choice is too broad it could result in a very large report that will either not complete, or slow your system down.

"> ">

Step 4 of 6: Select Criteria to Limit on

"> "> ">
"> _value" name="_value" value="" >/lib/calendar/cal.gif" id="buttonfrom1" style="cursor: pointer;" />

Dictionary Definitions


">

Step 5 of 6: Pick which columns to total

"> "> "> "> ">
">

Step 6 of 6: Select how you want the report ordered

"> "> "> "> "> ">
">

"> ">

Save Your Custom Report

"> "> Report Name:
Notes:

Show results

Download the report

">

Create Report From SQL

Report Name:
Type:
SQl:
Master:   Sub report:

Save Your Custom Report

Your report has been saved

The report you have created has now been saved. You can now