Reports

Reports function like Views to organize your data for display and analysis, and provide a visual representation of your data, customized to present Performance Indicators as a Dashboard view of your business.

Unlike Views, where data is restricted to a single object, Reports can present data from any Object or from multiple objects (Database Views).

About Reports

The platform's reporting engine provides a full set of options for users to dissect and refine into the format needed to make strategic business decisions or to monitor key performance indicators. Data can be filtered, ordered, color-coded, grouped (computed), and charted to create management reports that give you visual insights into your business.

Each application in the platform includes a group of standard reports. You can modify an existing report, or build new custom reports on an ad hoc basis. In addition, these presentation features are included:

• Build a tabular or matrixed report and optionally group information by rows and columns
• Provide basic computation functions with optional row/column count
• Color coding
• Chart data in a variety of graphic styles
• Email reports to team members
• Join and present data from multiple objects to form ad-hoc reports (Database Views)
• Display reports on the Home Page as a Widget (chart-based widgets are especially powerful)
• Export the report to PDF or to CVS file
• Build ad hoc fields that support complex data modeling and analysis with Computed Fields and Summary Computed Fields

Charts

A variety of chart formats are available:

• Pie
• Funnel
• Line
• Bar Chart
• Meter Gauge

When you click on a chart segment, several options appear:

• Filter - See how the chart appears for selected records.
• Drill Down - Select a record field and use it to subdivide the chart segment.
• Group - Collect records that share the same value for a selected field.
• Reset - Go back to the original chart.

Learn more: Charts

Tabular Reports

Tabular reports display data in rows and columns, as a table, with optional Color Coding to highlight significant rows.

Table of Orders by Customer

Matrix Reports

Matrix reports are used to organize and summarize your data, and are exceptionally well-suited for chart and dashboard views.

Orders by Source (Internet, Store, or Catalog) and by Offer (Discount, Purchase Incentive, or None).

The Matrix Report has a familiar format that you may know as a cross tabulation report (cross tab) or a pivot table. The resulting data is organized into a two dimensional grid which summarizes data (by total $, row count, or %).

The Matrix Report shows only summary information, based on the selected Row and Column Groups.

To create a Matrix Report, add one or more Row Groups and one or more Column Groups.

Reports in PDF Format

A Single Record can be printed as a PDF file.

Learn more: Print a Record

Working with Reports

This section describes how to run, modify and create new reports.

About Report Folders

Reports in Folders can be designated as visible to specific teams, roles, or users. See Report Folders for more information.

If a User has the viewing rights to a specific report, but does not have rights to view all the data, the report will only present the data that the user has permission to access.

Run a Report

To run a report:

1. Click the Reports tab to display the list of available reports
2. A series of options are available for each report

   Email

   Send a report via email, as an HTML file attachment to selected Users or Contacts. Find additional details at: Email a Report

   Edit

   Modify the report and Save it, or Save As a new report

   Delete

   Delete the report

   Report Name

   Run the Report

3. Click the Report Name to run the report

Report Actions

When a report is viewed, a series of action buttons become available:

Run Again

Rerun the report

Customize

Edit report options

Save

Save the report

Save As

Save the current report with a new name

Excel Print

Save the report as an Excel .xls file

HTML Print

Display the report in a browser window; it can then be printed or saved from the browser

Export

Save the report as a .csv file

Add or Edit a Report

To add or edit a report:

1. From any application, click the Reports tab and choose one of the following options:
   • Add a new report, click [New Report]

   In the Category tab, select the desired Report Category

   • See Database View for more advanced report category options

   • Navigate to an existing report and click the Edit link
2. Select the Report Options, as described below
3. Click [Preview] to see how the report will appear
4. Click [Run] to generate the report
5. Click [Save]
6. Select the Visibility option to specify who can view the report.

Repeat the process to create new reports from existing reports, building on the established data.

Report Options

• Fields
  Click the Fields tab and select the fields to include in the report.

• Order
  Optionally, click the Order tab to select the order of the columns in a tabular report, and/or to define the sort order for records in the report

• Filter
  Optionally, click the Filter tab to filter the records used for the report

• Color Code
  Optionally, click the Color Code tab to create conditional color-coding of report rows

• Group
  Optionally, click the Group tab to group records into collections based on the values in selected fields. Use these options to create both tabular reports and matrix (cross tab or pivot table) reports.

• Compute
  Optionally, click the Compute tab to add metrics to the report

• Chart
  If Grouping options were selected, click the Chart tab to select charting options

Move a Report

Moving reports involves not only modifying what data is included or excluded from the report, but may involve changing folder properties to include Visibility rights to those reports.

For example: If you have granted visibility rights to Everyone to view a certain report, you cannot move that report into a folder that restricts rights to a certain Team.

To move a report:

1. From any application, click the Reports tab
2. Click the Edit link next to the report you want to edit
3. Optionally, change the type of information that is generated by this report by modifying the Fields, Filter, Group, Compute, or Chart options
4. Finish:
   • Click [Save] to save the existing report
   • Click [Save As] to save the changes as a new report, with a new name
5. Select a Folder
   • If you save an existing report in a new folder, that report is moved to the new folder
6. Click [Save]

Delete a Report

Editing or moving reports involves not only modifying what data is included or excluded from the report, but may involve changing folder properties to include Visibility rights to those reports.

For example: If you have given visibility rights to everyone to view a certain report, you cannot move that report into a folder that restricts rights to a certain team.

To Delete a Report:

1. From any application, click the Reports tab
2. Click the Delete link next to the report you want to remove
3. Click OK in the confirmation. The report is removed from the Reports page.

Email a Report

Reports can be emailed to other team members or any other recipient.

Reports can be attached to email messages in any of these file formats:

• HTML
• CSV
• PDF

Users that have the Export Views and Reports permission can Email a Report

To Email a Report:

1. From any application, click the Reports tab
2. Click the Email link next to the report you want to send. If the report is not visible, make sure the folder containing that report is selected in the Folders drop-down list.
3. In the Send Report By Email page, complete the information under Receiver Details

   To

   Enter the name of one or more email recipients, or click the Lookup button to select team members

   Subject

   The report title appears by default, and can be edited

   Message

   The text that will appear in the body of the email message

4. In the Choose Reports to be delivered section, complete the following information:
5. Reports:The selected report is included by default

   Optionally, select additional reports to be attached to the email message

   Print Format

   HTML is the default format

   Choose from: HTML, CSV or PDF

6. Optionally, click the checkbox to Print in Landscape format
7. Click the [Send] button to send the email message

About [Save] and [Save As]

Considerations:

• The [Save] and [Save As] actions allow reports to be saved to these folders:

• My Report
• Unfiled Public Report
• Folder(s) created by the User
• Folder(s) the User can access, as determined by Folder Visibility settings

• [Save] replaces the original report
• [Save As] makes a copy of the report to the selected folder

Views, Reports and Object Inheritance

When creating Views or Reports in objects that are part of an Object Inheritance model, it is important to consider the following:

A Report or View that has no Filters will return all records from the designated object, including records from all parent object(s) in the hierarchy (following the path up to the root level).

To restrict the View or Report to only the desired objects, include the Object Name field in the Selected Fields list, and create a Filter on Object Name field to select only the objects of interest.