USP_REPORT_SAVEPARAMETERS

Stores a report spec's parameters as a serialized DataFormItem.

Parameters

Parameter	Parameter Type	Mode
@REPORTCATALOGID	uniqueidentifier	IN
@PARAMETERS	xml	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_REPORT_SAVEPARAMETERS
            (
                @REPORTCATALOGID uniqueidentifier,
                @PARAMETERS xml,
                @CHANGEAGENTID uniqueidentifier
            )
            as
                set nocount on

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                declare @CURRENTDATE datetime
                set @CURRENTDATE = getdate()

                begin try
                    update dbo.REPORTPARAMETERS set
                        PARAMETERS = @PARAMETERS,
                        DATECHANGED = @CURRENTDATE,
                        CHANGEDBYID = @CHANGEAGENTID
                    where ID = @REPORTCATALOGID

                    if @@ROWCOUNT = 0
                        insert into dbo.REPORTPARAMETERS (ID, PARAMETERS, DATEADDED, DATECHANGED, ADDEDBYID, CHANGEDBYID)
                        values (@REPORTCATALOGID, @PARAMETERS, @CURRENTDATE, @CURRENTDATE, @CHANGEAGENTID, @CHANGEAGENTID)
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR
                    return 1
                end catch