CREATE  PROCEDURE [dbo].[csp_CR_Run]
(
@report_id NVARCHAR(12)
)
AS
SET NOCOUNT ON

declare	@return_code INT
,	@webserver sysname

set @return_code = 0

select	@webserver = Configuration_Type_Configuration_Option_Value
from	tbl_Configuration_Type_Configuration_Option
where	Configuration_Type_ID = '{D8050F28-5E85-41E4-B119-23F0C1033473}'
and	Configuration_Option_ID = '{097168E2-E869-4851-9C6D-89AF48AD844D}'

declare @oReport int
,	@resultcode int
,	@desc varchar(255)
,	@src varchar(255)
,	@rc bit

EXEC @resultcode = sp_OACreate 'SIReport.RunReport', @oReport OUT
set @return_code = @resultcode

/*if @resultcode <> 0
begin
print 'error creating object'
	exec sp_OAGetErrorInfo @oReport, @src OUTPUT, @desc OUTPUT
	print @src
	print @desc
end*/

if @resultcode = 0
BEGIN
	EXEC @resultcode = sp_OAMethod @oReport, 'Run', @rc OUT, @report_id, @webserver
	set @return_code = @resultcode
	if @resultcode <> 0
	begin
	print 'error executing method'
		exec sp_OAGetErrorInfo @oReport, @src OUTPUT, @desc OUTPUT
		print @src
		print @desc
	end
	EXEC sp_OADestroy @oReport
END

SET NOCOUNT OFF
return @return_code
GO