Skip to main content

Create Self Service Reports

  • Updated

Create Self Service Reports

Generate and manage reports using the self-service reporting capability. Create customized reports using a table visual, adding a report header and footer as needed.

Additionally, you can apply filtering, conditional formatting, and grouping to your data. Apply aggregate functions on different fields to produce the report you need. Export easily as a PDF, including all of your customizations.

Note: Self service reports are limited to 15 columns of data, 1,000 groups of data, and 100,000 records.

Create a Self Service Report

Note: In this release, when your admin enables the Enhanced Experience user interface, you will see changes to workflows you may have used in previous releases.

Create a report from any available data source that supports tables. You can apply any filtering, grouping, or conditional formatting as needed. Add a header and footer to provide information and context as needed. After you create a report, you can favorite it, save a copy of it, and easily export it (up to 15 columns of data) as a PDF.

  1. Navigate to the Reports work area.

  2. Select Create Report. A blank Untitled report work area opens. Edit an editable area of the report, or connect a data source using the Select source button to open the Select a Source modal.

    Note: Before or after you select a source, you can edit the title, header, footer, and trademark text of this report.

  3. Select an available source from the options provided in the Select a Source modal. Scroll through the options, filter sources by connection type, or use the Search feature to find specific sources. After you make your selection, a Select Columns modal opens.

    Note: Only sources with data that can be presented in a table are shown.

    Optionally, enable the toggle provided to Enable Groups Header/Footer.

  4. Select one or more columns from your data source to build your report. Scroll through the options or use the Search feature to find specific fields.

    select columns for a self service report

    Note: You can control the fields used and shown to users for self service reports by adjusting the field visibility in your sources. See Hide Fields.

  5. When you have picked all of the columns you wish to include in the report, select Create Report. After your report is generated, it displays the report data in an editable widget in the Untitled report work area.

    Note: The maximum number of columns you can include in a report is fifteen.

    use this work area to design your self service report

  6. Name and save your report when you're ready, updating the name, adding a description, and assigning tags as needed.

    Optionally, edit the header and footer of this report, or select the Report Header & Footer icon to disable the header and footer of this report.

The Report Header and Footer

Note: By default, the report header and footer are enabled for all reports. Select the Report Header & Footer icon in the reports icon bar to toggle the header and footer sections on and off.

  1. Select edit icon in the header or footer area of the report to make changes to it. The selected section expands and opens for editing. Apply formatting as needed. See Format Self Service Reports.

  2. Enter the header or footer text you would like to include, then select the edit icon again to save your changes. The section shrinks and your changes are visible in the report work area.

  3. By default, the current date is included in the footer work area, and you can optionally add trademark text, copyright information, or other static information alongside the date.

  4. When you are satisfied with your edits, Save your changes.

    Important: The name of the report, the date of the report, pagination information, and any trademark information you provide are included in all reports, even if the headers and footers are disabled.

Export Your Self Service Report

When your users create self service reports and scheduled service reports, this can induce some load on your environment and the self service microservice. This microservice was added to enhance performance of self service report creation and Excel (XLSX) exports with formatting and conditional formatting for table visuals and reports.

For more information about performance considerations for self service reporting, exports of reports and table visuals, see Self Service Report Microservice.

  1. After you create and save your report, you can access and select the export icon.

  2. Select the export icon to open the export menu.

  3. Select PDF or Data (XLSX).

    If you select PDF, a preview window displaying the first few rows of entries in your report opens. If you like the look of your report, select Export PDF to download the report. Select Cancel to go back and make changes to your report.

    If you select Data (XLSX), your data is prepared and downloads.

Related articles

Comments

0 comments

Please sign in to leave a comment.