# Calling a Stored Procedure From a Report Issue **URL:** \ **Category:** Ignition\ **Created:** [March 31, 2019, 8:04pm UTC](https://forum.inductiveautomation.com/t/calling-a-stored-procedure-from-a-report-issue/23739 "2019-03-31T20:04:10Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Sam.Naji](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sam.naji/32/4657_2.png) [@Sam.Naji](https://forum.inductiveautomation.com/u/Sam.Naji)\ **Post date:** [March 31, 2019, 8:04pm UTC](https://forum.inductiveautomation.com/t/calling-a-stored-procedure-from-a-report-issue/23739/1 "2019-03-31T20:04:10Z")
I have this Stored Procedure: ```auto USE [IgnMESCustomDB] GO DECLARE @return_value int, @ReturnCode int, @ReturnMessage varchar(max) EXEC @return_value = [dbo].[splocal_AFL_Schedule_GetDisplay] @EquipLineName = N'BL07', @ReturnCode = @ReturnCode OUTPUT, @ReturnMessage = @ReturnMessage OUTPUT SELECT @ReturnCode as N'@ReturnCode', @ReturnMessage as N'@ReturnMessage' SELECT 'Return Value' = @return_value GO ``` I am trying to call it in from a report. But, I am getting nowhere! I am not seeing any columns listed in the data source of my query. Can anyone see what I am doing wrong? It is supposed to be a simple call. I spent over two hours scratching my head - ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/7/76f9a15ba6bd88c11f2cfd2726d16763c15f5f95.png) Here is my code for calling the Stored Proc: ```auto call = system.db.createSProcCall("splocal_AFL_Schedule_GetDisplay") call.registerInParam("EquipLineName", system.db.VARCHAR, "BL07") call.registerInParam("ReturnCode", system.db.INTEGER,0) call.registerOutParam("ReturnMessage", system.db.INTEGER) system.db.execSProcCall(call) dataSource = call.getResultSet()Calling Stored Procedure From a Report.doc (204.5 KB) ``` Thanks. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 31, 2019, 9:51pm UTC](https://forum.inductiveautomation.com/t/calling-a-stored-procedure-from-a-report-issue/23739/2 "2019-03-31T21:51:15Z")
You are trying to use scripting where Ignition is expecting a SQL Query. Use a scripting data source. ---
**Author:** ![Sam.Naji](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sam.naji/32/4657_2.png) [@Sam.Naji](https://forum.inductiveautomation.com/u/Sam.Naji)\ **Post date:** [March 31, 2019, 11:28pm UTC](https://forum.inductiveautomation.com/t/calling-a-stored-procedure-from-a-report-issue/23739/3 "2019-03-31T23:28:57Z")
That was silly on my part. I corrected it by using the script but I am not getting the data keys. ANy idea if I have issue with my syntax? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/fbaad74b85671a4d8cf27b9c0ee78aadf9d447c6.png) ---
**Author:** ![Sam.Naji](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sam.naji/32/4657_2.png) [@Sam.Naji](https://forum.inductiveautomation.com/u/Sam.Naji)\ **Post date:** [March 31, 2019, 11:33pm UTC](https://forum.inductiveautomation.com/t/calling-a-stored-procedure-from-a-report-issue/23739/4 "2019-03-31T23:33:23Z")
Here is my procedure which does work when I run it in the SQL server: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/1/19f91861130d233bd6aae59fa9df6f3e5c0faef3.png) ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 31, 2019, 11:34pm UTC](https://forum.inductiveautomation.com/t/calling-a-stored-procedure-from-a-report-issue/23739/5 "2019-03-31T23:34:02Z")
Your syntax looks good. You should see data under “mykey” in the preview pane. ---
**Author:** ![Sam.Naji](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sam.naji/32/4657_2.png) [@Sam.Naji](https://forum.inductiveautomation.com/u/Sam.Naji)\ **Post date:** [March 31, 2019, 11:36pm UTC](https://forum.inductiveautomation.com/t/calling-a-stored-procedure-from-a-report-issue/23739/6 "2019-03-31T23:36:18Z")
I am seeing nothing: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/7/784d4c819399d1e6aaa6ba833d29709f0480c713.png) ---
**Author:** ![Sam.Naji](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sam.naji/32/4657_2.png) [@Sam.Naji](https://forum.inductiveautomation.com/u/Sam.Naji)\ **Post date:** [March 31, 2019, 11:37pm UTC](https://forum.inductiveautomation.com/t/calling-a-stored-procedure-from-a-report-issue/23739/7 "2019-03-31T23:37:49Z")
It’s very frustrating:frowning: ( ---
**Author:** ![Sam.Naji](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sam.naji/32/4657_2.png) [@Sam.Naji](https://forum.inductiveautomation.com/u/Sam.Naji)\ **Post date:** [March 31, 2019, 11:46pm UTC](https://forum.inductiveautomation.com/t/calling-a-stored-procedure-from-a-report-issue/23739/8 "2019-03-31T23:46:49Z")
I am getting this error: WARN: Error invoking script.Traceback (most recent call last): File “function:updateData”, line 5, in updateData TypeError: registerReturnParam(): expected 1 args; got 2 ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [April 1, 2019, 12:17am UTC](https://forum.inductiveautomation.com/t/calling-a-stored-procedure-from-a-report-issue/23739/9 "2019-04-01T00:17:30Z")
You are mixing up return parameters and out parameters.