Parallels RAS Reporting Service Guide
ProductsSupportPartnersDocumentation
  • Introduction
    • Parallels RAS 19 release history
  • Installing Parallels RAS Reporting
    • System requirements
    • Install Microsoft SQL Server
      • Install Microsoft SQL Server 2016 or earlier
      • Install Microsoft SQL Server 2017 or 2019
      • Install Microsoft SQL Server 2022
    • Install Parallels RAS Reporting
    • Running Parallels RAS reports
    • GDPR compliance
  • Creating Custom Reports
    • Requirements and Information
    • Enable Custom Reports in the RAS Console
    • Install Microsoft SQL Server Report Builder
    • Create a New Blank Report
    • Add a Data Source
    • Add a Dataset
    • Design the Report
    • Run the Report in the RAS Console
    • Summary
    • Example: Report with Charts
      • Create a New Report
      • Add a Dataset
      • Design the Report
        • Add a Bar Chart
        • Add a Pie Chart
        • Format the Report
  • RAS Reporting Database Schema
Powered by GitBook

Social media

  • Facebook
  • Twitter
  • LinkedIn
  • YouTube

Other Resources

  • Feedback

© 2025 Parallels International GmbH. All rights reserved.

On this page
Export as PDF
  1. Creating Custom Reports
  2. Example: Report with Charts

Add a Dataset

Add a dataset as follows:

  1. In the Report Builder, right-click the Datasets folder in the left pane and then click Add Dataset.

  2. In the Dataset Properties dialog, type a data set name and then select the Use a dataset embedded in my report option.

  3. In the Data source field, select the data source that you created earlier.

  4. In the Query type section, select Text to use an embedded SQL as your query.

  5. Enter the following query into the Query edit box:

    SELECT

    m.Name as [Machine Name],

    mt.MachineType as [Machine Type],

    mt.SortingID as [SortingID]

    FROM

    dbo.Machines m RIGHT OUTER JOIN

    dbo.MachineType mt ON mt.MachineType_ID = m.MachineType_fk

  6. To test the query, click the Query Designer button. In the dialog that opens, click the exclamation sign icon (at the top) to run it. If the query is valid, you will see the result set.

  7. Close the Query Designer dialog and then click OK to save the dataset.

PreviousCreate a New ReportNextDesign the Report

Last updated 9 months ago