Hi,
I developed a custom Excel report based on a Stored Procedure that is executed via a Custom Load Method from an IDO.
I coded a form with 4 fields binded to variables that are used in the BGTaskParms variable.
I coded an IDO that extends “SLReportDataViews” with a Custom Load Method linked to my Stored Procedures that have 4 input parameters and 30 output columns.
The Background Task has also been defined.
The problem is that the 4 parameters are not reaching the Stored Procedure. I’ve added a script into the Stored Procedure so that every time the Stored Procedure is called, all 4 parameters are logged in a separate table.
I’ve seen that they are set to NULL every time, except when the Stored Procedure is called within SSMS.
For test purposes, I’ve told my Stored Procedure to skip the use of the 4 parameters. The Excel report is generated successfully from CSI and is full of data. But the report is useless because the 4 parameters are not used to filter the data.
Here are some screenshots of the setup, can you check if something is wrong?
My Stored Procedure with the 4 parameters.
The same 4 parameters on the Custom Load Method side.
My report form with an example of one of the fields binded to a variable.
Definition of my “Run Background Task” event.
Definition of my “BGTaskParms” variable.
Example of a Background Task History with the parameter field.
Thank You
Romain M.
