Page 1 of 1
OpenOrders report question
Posted: Mon Jul 20, 2015 2:11 pm
by joe.mag
This is not technically a Crystal Reports question but it is very much a reporting question. In 2.6 we relied upon SoftPro's csp_150079_OpenOrder stored procedure to get the raw data for our own open orders report we coded in SQL Server Reporting Services. We have recently migrated to 4.0 and I'd like to know if there's an equivalent to csp_150079_OpenOrder that would give me roughly the same data in the same columns.
TIA
Re: OpenOrders report question
Posted: Mon Jul 20, 2015 2:41 pm
by Lisa Ennis
All of the database objects for the canned reports are in the rptdoc schema. Any custom stored procedures would be in the spc schema. The "rptdoc.OrdersByOrderStatus" stored procedure may give you what you need. The "csp_150079_OpenOrder" that you reference is a custom stored procedure. That stored procedure should have been updated when your upgrade was completed, and should now be in the spc schema. If it is not there, please contact SoftPro Support and they can assist you with getting that stored procedure in place.