RSMassTransit

A MassTransit message bus interface for SQL Server Reporting Services.

Idea by Jahn Swob (@jahn-swob), implemented by Jeff Sharp (@sharpjs).

Status

• RSMassTransit exexutes reports and uploads their contents to blob storage. Other features like report discovery or deployment might become supported at some indeterminate time in the future.
• Used in production for several years with few reported defects.
• Test coverage is inadequate.
• Documentation is inadequate.

Installation

TODO

Development Setup

• Requirements:
  • Visual Studio 2019 or later
  • SQL Server Reporting Services 2019 (might work with earlier versions)
  • .NET SDKs and targeting packs (see TargetFrameworks in each project file)
  • PowerShell 5.1+
  • PowerShell Core 6.x or PowerShell 7+
• In solution properties, Startup Project tab, ensure that Action is set to Start for:
  • RSMassTransit.Tool
  • RSMassTransit.PowerShell
• On F5 run, two windows should appear:
  • RSMassTransit service console window
  • PowerShell prompt
• In the PowerShell window, enter a command similar to the following:

  Invoke-RsReport `
      -Path           '/My Reports/IT Reports/TPS Report' `
      -Format         Pdf `
      -TimeoutSeconds 30 `
      -RsCredential   (Get-Credential)