Crystal Reports stored procedure error
Posted on 2014-03-20
Hi, I am trying to use a SQL stored procedure for my Crystal Report. When I select the stored procedure it requires me to enter a value for my input parameter. When I input a value (I've tried 80000, 80,000, 80) and click OK, I get the following error: Not supported Details: Cannot obtain error message from server. I am using Crystal Reports 9
My stored procedure is very simple so I'm not sure what is causing the problem. It works fine when executed via SQL Server Management Studio.
Here is my procedure:
-- Add parameter for top paid amount
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
Set ReservedBy = 'john.doe', Reservedon = getdate()
Where (Tracking = 0 or Tracking is null) and
Reservedby is null and Completeuser is null
and tmhppaid > @toppaidamt
I've tried removing the input parameter and setting update values to static values as well and I still get the same error.
Any suggestions on how to troubleshoot/fix this issue?