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.
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
Also im running 7.9.1.