Executing Stored Procedure From Report

Ignition
1

I am looking for some way to execute a stored procedure each time a report is scheduled to run.
Is there a way to do this from within the report itself?
I have tired putting the command in a extra query but it just errors out.

USE [IGN_DieselPlant]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[usp_fuel_consumption]
@report_date = N’2017-03-01’,
@report_partition = N’Monthly’,
@hour = N’1’,
@minute = N’1’
SELECT ‘Return Value’ = @return_value
GO

Also im running 7.9.1.

2

Use a scripting datasource and the system.db.createSProcCall function(s). Scripting datasources will be called every time the report is run/generated, but do not have to actually return any data.