Table of Contents

Add a Report

The following provides a brief overview for creating a new report that can be edited in Report Builder.

Report Builder's interface works the same as the DevExpress Report Designer interface. Because of the complexity involved, only the main steps for setting up a report are covered here. We recommend that new reports be created by team members experienced in database design and queries.

Please refer to the end-user guide to Devexpress Reports for additional information on managing properties, expressions, and data-bound fields.

  1. Open Report Builder in Administration.
  2. Select Add Report above the grid.

  3. Fill in the Add Report form:
    • Type in Name.
    • Type in a Description.
    • Select a Privacy setting. 
    • Select Yes or No for Visible in Reports Module. This option shows or hides the report in the Reports module gird regardless of the privacy setting and is applied to all users.

  4. The Report Wizard will open. In the first step, select a Report Type.

  5. Select Next at the bottom.
  6. In the next step, Specify Data Source Settings, select the predefined queries (tables, views, or stored procedures) or custom queries, configure master-detail relationships, and configure parameters if needed.

    Please note that the data connection is already selected.

  7. Select Next at the bottom.
  8. In the next step, Define Report Layout, select queries, detail reports, and data fields that will appear in the report. If needed, configure groups and add summary fields (sum, count, average, etc.)

  9. Select Next at the bottom.
  10. In the last step, Specify Page Settings, adjust the report appearance by editing the page size, margins, color scheme, and report title.

  11. Select Finish at the bottom.

The report will appear in the Design View and is ready for editing. 

Privacy settings include:

  • Shared - Allows others who access the account to access and edit the report.
  • Read-only - Allows others who access the account to view but not edit the report.
  • Private - Allows only you to access and edit the report.