OpenOrders report question

Discussions related to Crystal Reports development.

Moderator: Lisa Ennis

Post Reply
joe.mag
Posts: 122
Joined: Thu Aug 04, 2011 3:11 pm

OpenOrders report question

Post 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
Lisa Ennis
Posts: 84
Joined: Thu Sep 11, 2008 1:57 pm

Re: OpenOrders report question

Post 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.
Lisa Ennis
Senior Report Developer
SoftPro
Post Reply