# Using Stored Procedure in Ignition Report **URL:** \ **Category:** Ignition\ **Created:** [August 17, 2022, 12:59am UTC](https://forum.inductiveautomation.com/t/using-stored-procedure-in-ignition-report/63084 "2022-08-17T00:59:09Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![eden](https://avatars.discourse-cdn.com/v4/letter/e/5f9b8f/32.png) [@eden](https://forum.inductiveautomation.com/u/eden)\ **Post date:** [August 17, 2022, 12:59am UTC](https://forum.inductiveautomation.com/t/using-stored-procedure-in-ignition-report/63084/1 "2022-08-17T00:59:09Z")
I have a question about Data Sources in Reports. Has anyone been using a stored procedure instead of a direct sql statement for data sources in reports? Do you use Basic SQL Query query type or do you use a Script? What is suggested? ![script](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/c/5c26abe59b9c37089cc48a2519554580dff8a704.png) ![Basic SQL Query](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/8/686481bca33452b2f4856d28250d3e8d950c263f.png) I’ve also noticed that the stored procedure runs fast in SQL Server Management Studio (SSMS) is is slow to load in the report. Has anyone encountered this? ---
**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\ **Post date:** [August 17, 2022, 12:36pm UTC](https://forum.inductiveautomation.com/t/using-stored-procedure-in-ignition-report/63084/2 "2022-08-17T12:36:35Z")
We just use the stored procedure just like a normal sql query and pass it the required parameters. ![ReportSP](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/6/66b354c3a74dad37011867b808400d963b2a3d31.png) ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [August 17, 2022, 3:02pm UTC](https://forum.inductiveautomation.com/t/using-stored-procedure-in-ignition-report/63084/3 "2022-08-17T15:02:47Z")
> [@eden](#): > > I’ve also noticed that the stored procedure runs fast in SQL Server Management Studio (SSMS) is is slow to load in the report. Has anyone encountered this? > [@Slow Query in Ignition](https://forum.inductiveautomation.com/t/slow-query-in-ignition/55908/3): > > Found it - try SET ARITHABORT ON before executing the query: ---
**Author:** ![eden](https://avatars.discourse-cdn.com/v4/letter/e/5f9b8f/32.png) [@eden](https://forum.inductiveautomation.com/u/eden)\ **Post date:** [August 17, 2022, 11:45pm UTC](https://forum.inductiveautomation.com/t/using-stored-procedure-in-ignition-report/63084/4 "2022-08-17T23:45:52Z")
Will try that @paul-griffith. Cheers. ---
**Author:** ![eden](https://avatars.discourse-cdn.com/v4/letter/e/5f9b8f/32.png) [@eden](https://forum.inductiveautomation.com/u/eden)\ **Post date:** [August 19, 2022, 4:50am UTC](https://forum.inductiveautomation.com/t/using-stored-procedure-in-ignition-report/63084/5 "2022-08-19T04:50:13Z")
![CPU](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/2/2283b2fcf10ccb4844f15ccfd03b1e258338413e.png) When running a report, the CPU usage goes up to above 90%. Is there a way to check what’s causing this? ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [August 19, 2022, 3:26pm UTC](https://forum.inductiveautomation.com/t/using-stored-procedure-in-ignition-report/63084/6 "2022-08-19T15:26:42Z")
How much data (number of rows, number of columns) is returned by the query? How many pages is the resulting report? You can get a thread dump (from the gateway web UI, in the status → diagnostics → threads section) while the query is running/the report is generating, but it likely won’t tell you a whole lot. ---
**Author:** ![eden](https://avatars.discourse-cdn.com/v4/letter/e/5f9b8f/32.png) [@eden](https://forum.inductiveautomation.com/u/eden)\ **Post date:** [August 21, 2022, 9:53pm UTC](https://forum.inductiveautomation.com/t/using-stored-procedure-in-ignition-report/63084/7 "2022-08-21T21:53:24Z")
10 rows, 131 columns. 10 pages for the report, each page has 4 charts aned 8 tables