Skip to Content
Former Member
Jul 30, 2008 at 06:37 PM

Crystal freezes when changing stored procedure



I have a problem modifying a report. The report runs from a stored procedure, with many parameters in the stored procedure. The sp itself doesn't use most of these parameters, but I need them to be in there, because the reports are run from a third-party application that can either use crystal parameters or stored procedure parameters, but not both, so most parameters are used from crystal.

The problem I have is that when I try to add a new parameter (of type nvarchar(27)) to the sp, the report stops working completely in crystal (it displays "accessing database", will sometimes get to "reading records 2/2", then freezes). Nothing else has changed in the report, and the sp still runs fine in about 4 seconds in SQL Server management studio.