Creating Custom Reports with the SQL Report Builder

Admin: Corporate Admin
Page: Reports > Custom
URL: [CLIENTID].corpadmin.directscale.com/Corporate/Reports/Custom
Permission: ManageCustomReports() or ViewCustomReports()

The SQL Report Builder in Corporate Admin allows you to build customized reports by querying a copy of the Database using SQL statements.

  You can also create reports with the Visual Report Builder
DirectScale Custom Reports

There are hosts of DirectScale-made custom reports covering a wide range of datasets. The report you need may already be created or close enough to base your report on it.

Creating a Report

To create a new report with the SQL Report Builder:

  1. Click + Add Report and select SQL Report Builder.

    New Report > SQL Report Builder

    The SQL Report Builder page opens. This page features the same functionality as the SQL Manager.

    Sql Report Builder page
  2. Enter the SQL query in the Query Box.

      Find useful queries in the SQL Query Library.
  3. Click Preview. The Preview Report panel allows you to test your query and ensure that it’s pulling in the intended data. Click the X to close the panel.

  4. Click Save. The Save Report pop-up opens.

  5. In the pop-up, enter a Report Name.

  6. Click Save to confirm.

    Save Report pop-up window

The report will now be added to the list of available reports accessible to you and other users. However, only yourself and users with the ManageCustomReports permissions can edit or delete the report.

Editing Your Custom Reports

To edit a report made by yourself or another user:

  1. Locate the report from the Report Name list.

  2. Click the Pencil button to begin editing.

    Edit button
  3. The SQL Report Builder opens with the query loaded in the Query Box.

    Edit query
  4. Make the applicable adjustments.

  5. Select Preview to review the changes before saving.

  6. Click Save. A pop-up window will appear. The Report Name field will automatically populate with the report’s current title.

  7. Leave the name unchanged to save changes to the report.

      CAUTION: If you update the existing report name and confirm the changes, the report will save under the new name; it does not create an additional report.
  8. Click the Save button.

    Save pop-up

Deleting Reports

To delete a report:

  1. Click the Delete button to remove the report. The Delete Custom Report pop-up window opens.

    Delete Report
  2. In the pop-up, click Delete to confirm.

    Delete Confirmation
  CAUTION: You cannot recover a deleted report.
Was this article helpful?
0 out of 0 found this helpful
Previous Next

Comments

0 comments

Please sign in to leave a comment.