How can I run and pass parameters to existing SQL Server Reporting Services (SSRS)Decisions reports

RichterBell

We have many SSRS (SQL Server Reporting Services) reports already created. Is there a way to pass information from Decisions to these reports and run them externally? We’re on version 9.13 and would appreciate guidance on integrating Decisions with SSRS.

MalikB_Decisions

Yes, you can run external SSRS reports and pass parameters from Decisions using a REST Service Integration. Here’s how:

Steps:

1. In the Flow Designer, add a new flow.
2. Drag a “REST Service” step from the Integrations category into your flow.
3. Configure the REST Service step with your SSRS report endpoint URL and authentication details.
4. Set the HTTP method (GET/POST) and map Decisions data fields to the report parameters.
5. Add steps to handle the response, such as displaying results or sending emails.

Relevant Documentation:

REST Service Integration Overview

Searching the Step Catalog - https://documentation.decisions.com/docs/searching-the-step-catalog