Reports Deployment

Deploy Reports for the First Time

The following table outlines the steps that you must complete to deploy and configure this module for the first time. These instructions assume that you have completed the steps for deploying the basic system architecture.

These tasks may be completed by multiple people in your organization. We recommend, however, that the tasks be completed in the order in which they are listed.

StepTaskNotes
1Install the Reports Designer. This step is required.
2Set up the Reports Designer.This step is required.

Install the APM Reports Designer

Before You Begin

  • Install one of the following versions of Microsoft Visual Studio and the corresponding version of Microsoft SQL Server Data Tools (SSDT):
    Visual Studio VersionSSDT Version
    Microsoft Visual Studio 2017Microsoft SQL Server Data Tools (SSDT) - Business Intelligence for Microsoft Visual Studio 2017 (15.8.0)
    Microsoft Visual Studio 2019Microsoft SQL Server Data Tools (SSDT) - Business Intelligence for Microsoft Visual Studio 2019
    • If you install SSDT for Microsoft Visual Studio 2019, install Microsoft Reporting Service Projects (VSIX 2.6.2). For more information on how to install Microsoft Reporting Services Projects (VSIX 2.6.2), refer to the Microsoft SSDT documentation.
    Note: The following versions of SSDT are supported with Microsoft SQL Server 2016:
    • 2017 (15.8.0)
    • 2019

Procedure

  1. On the machine that will serve as the APM Reports Designer, access the APM Distribution package, and then navigate to the Admin folder.
  2. Run Setup.exe.
    The Meridium Admin - InstallShield Wizard window appears.

  3. Select Next.
    The License Agreement window appears.

  4. Read the License Agreement and, if you agree, select the I accept the terms of the license agreement check box, and then select Next.
    The Select Installation Location window appears.

  5. Select Next to accept the default location.
    The Select the features you want to install window appears.

  6. Select SSRS Data Processing extension for Visual Studio, and then select Next.
    The Complete the Installation window appears.

  7. Select Install.
    The Setup Status window appears, displaying a progress bar that shows the progress of the installation process.

    When the SSRS Data Processing extension for Visual Studio is installed, a message appears, indicating that the installation is complete.

  8. Select Finish.
    The Meridium Admin - InstallShield Wizard window is closed.
  9. As described in the following table, navigate to the paths corresponding to the Microsoft Visual Studio version installed in your system.
    Visual Studio VersionPath
    Microsoft Visual Studio 2017C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional\Common7\IDE\CommonExtensions\Microsoft\SSRS
    Microsoft Visual Studio 2019C:\Program Files (x86)\Microsoft Visual Studio\2019\Professional\Common7\IDE\CommonExtensions\Microsoft\SSRS
  10. Open the RSReportDesigner.config file using a text editor (for example, Notepad).
  11. Locate the following code in the configuration file, and then replace {meridiumserver} with the name of the APM server: <ServerUrl>http://{meridiumserver}/meridium/api/</ServerUrl>
  12. Save the configuration file.

Results

The APM Report Designer is installed.

Set Up the APM Report Designer

After installing the APM Report Designer plugin, you must set up APM Report Designer to interact with APM Server.

Before You Begin

Procedure

  1. On the APM Server, open Microsoft Visual Studio.
  2. On the Tools menu, select Options.
    The Options window appears.

  3. On the Options window, in the left section, select APM Report Designer, and then select General.
    The MeridiumServerURL box appears in the right section.

  4. In the MeridiumServerURL box, enter the Meridium Web Services URL in the following format:
    http://<server_name>//meridium/api/v1

    The APM Report Designer setup is complete.