Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Mobile Operator

TABLE OF CONTENTS

Configure the SSRS Reports

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedJan 17, 2025
  • 4 minute read

The SSRS Report is designed to offer customers a simplified version of the reports available in AVEVA Mobile Operator Web Reports.

Note: We recommend you to use Force Protocol Encryption on the SQL Server for a secured encrypted connection to the SQL server. For more information, see the Microsoft documentation on configuring SQL Server Database Engine for encrypting connections.

Take the following steps to install and configure the SSRS Report.

SSRS Prerequisites:

  • The SSRS version must be 2016 or later.

To setup and configure SSRS Reports

  1. On the machine hosting the Reporting Services, open the SQL Server Reporting Services Configuration Manager from SQL Server's Start Menu entry under the Configuration Tools folder.

    Note: The Report Server and the AVEVA Mobile Operator Database Server may be the same or different machines, depending on your configuration.

    The Reporting Services Configuration Connection window appears.

  2. Enter the Report server's machine name in the Server Name text box, and then click Find. A list of SSRS Instances appears.

  3. Select the desired instance from the list, and then click Connect.

    The Reporting Services Configuration Manager appears.

  4. Click the Service Account option in the Connect section.

  5. Select the required option, Use built-in account or Use another account, to set the service account.

    To know more about the options, see the Microsoft documentation.

  6. Click the Web Service URL option in the Connect section.

  7. Enter the desired address for the Web Service URL in the Virtual Directory: text box.

    The URL to the Web Service appears in the Report Server Web Service URLs section.

  8. Click the provided URL to test connection to the Report Server Web Service.

  9. Click the Database option in the Connect section.

  10. Click Change Database.

    The Report Server Database Configuration Wizard opens.

  11. Select the Create a new report server database option, and then click Next.

  12. Enter the database server name in the Server Name text box.

  13. Select the desired Authentication Type, and provide the appropriate Username and Password.

  14. Click Next.

  15. Enter the desired Report Server Database name in the Database Name text box.

  16. Select the language used for the database scripts from the Language drop-down list.

  17. Click Next.

  18. Select the desired Authentication Type, and provide the appropriate User name and Password, of an account used to set up the new Report Database.

    Note: The account specified in this step is used only once for setup of the database.

  19. Click Next.

    A progress bar and messages indicate the progress of configuration and testing.

  20. When complete, click Finish to return to the Reporting Services Configuration Manager.

  21. Click the Report Manager URL option in the Connect section.

    The Virtual Directory text box is populated with the value entered earlier.

    The full URL appears in the URLs: field.

  22. Click the provided link(s) to test your connection to the Report Server.

  23. If you intend to distribute reports via e-mail, click the E-mail Settings option in the Connect section. Otherwise, skip to step 25.

  24. Enter your e-mail server and account's information into the provided text boxes.

  25. Click Apply, and then click Exit, to save your changes and exit the Reporting Services Configuration Manager.

Deploying the RDL files

  1. Copy the contents of the "SSRS" patch folder to a temporary folder on the system.

  2. For SSRS 2017 and later:

    1. Copy the executable files, RS.exe and RS.exe.config (if available), from the installation folder of SQL Server Reporting Services 2017 and later (default installation path of SQL Server Reporting Services 2017 is C:\Program Files\Microsoft SQL Server Reporting Services\Shared Tool).

    2. Paste the RS.exe and RS.exe.config files in to the temporary folder in Step 1.

  3. Run the Deploy.bat file you just copied.

    A prompt appears. A note also appears,informing that the SSRS version must be 2016 or greater.

  4. Enter the name or IP of the server running SSRS, and press Enter.

  5. Enter the name of the Report Server Web Service Virtual Directory, and press Enter.

    The batch file executes, displaying progress output as setup is performed.

  6. When the output displays The command completed successfully, press any key to exit the batch file.

    Configuring the data source's properties

    1. Open the Report Manager URL you configured earlier.

      The SQL Server Reporting Services web page opens.

    2. Click the Data Sources folder.

      A list of Data Sources appears.

    3. Click the downward-facing chevron next to your Data Source, and then click Manage.

      The Properties of the Data Source appear.

    4. Change the following strings in the Connection string text box:

      1. Data Source: The name of your Database Server

      2. Initial Catalog: The name of your Database.

      Note: Both of these settings are on a single line. Due to text wrapping, your input may look like:
      Data Source=<Database Servername>;Initial
      Catalog=<Database>

    5. Next, provide the database connection credential information in the Connect using: section near the bottom of the page.

      Refer to the following Microsoft Developer Network (MSDN).

      Tip: Select your version of SQL Server from the Other Versions link near the top of the page for version-specific information.

    6. Click Test Connection.

      The message Connection created successfully. appears.

    7. Click Apply to save your changes.

    8. Click the Home breadcrumb link at the upper left of the page to return to the SSRS main page.

    9. Click the Reports folder.

      A list of Reports displays.

      You can apply a custom logo to the SSRS Reports. The SAT_Branding table in the database includes a CustomLogo field. If an image is present in this column, the logo is displayed on the report.

      Use the following script to upload an image to the CustomLogo column in the SAT_Branding table. Run this script on the database server and to reference a file on the server hard drive.

      UPDATE SAT_Branding

      SET CustomLogo =

      (SELECT BulkColumn

      FROM OPENROWSET(BULK N'<file location>\customLogo.jpg', SINGLE_BLOB) AS x)

      To remove a custom logo, run the following script.

      UPDATE SAT_Branding SET CustomLogo = NULL

      TitleResults for “How to create a CRG?”Also Available in