Skip to Content
0
Former Member
Jul 08, 2009 at 04:44 PM

Error when linking report to stored procedure defined with one input parm

17 Views

Error when linking report to stored procedure defined with one input parameter

The report will work ok, when the parameter is removed from the stpred procedure

An unhandled win32 exception occurred in crw32.exe[4480]

Stored Proc (sql server 2005)

USE [Allegro]

GO

/****** Object: StoredProcedure [dbo].[SP_Test] Script Date: 07/08/2009 10:42:14 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER procedure [dbo].[SP_Test](@valuationmode VARCHAR(55)) as

Begin

select

valuation,

valuationtime,

valuationmode

from valuation

where valuationmode = @valuationmode;

End;