A MassTransit message bus interface for SQL Server Reporting Services.

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

Experimental. Currently, only report execution is implemented.

First, copy the application files to a suitable directory. A good choice would be C:\Program Files\RSMassTransit. Then, edit the RSMassTransit.exe.config file as required.

RSMassTransit runs as a normal console application if invoked by a logged-on user. It will exit on the first keypress.

RSMassTransit.exe

Otherwise, RSMassTransit runs as a Windows service. To install the service:

RSMassTransit.exe /install

To uninstall the Windows service:

RSMassTransit.exe /uninstall

To run RSMassTransit as a console application in a non-interactive context, such as an Azure Web Job:

RSMassTransit.exe /console

• Requirements:
  • Visual Studio 2017
  • SQL Server Reporting Services 2016 (might work with earlier versions)
  • PowerShell 5 (might work with earlier versions)
• In RSMassTransit.PowerShell project properties, Debug tab:
  • Click "Start external program" and enter:
    C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe
  • In "Command line arguments", enter:
    -NoLogo -NoProfile -NoExit -Command "Import-Module .\RSMassTransit.psd1"
• In solution properties, Startup Project tab, ensure that Action is set to Start for:
  • RSMassTransit
  • 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)