Report Parameters

Report parameters can be added and modified in the report template. Custom parameters can be added via the Web Administrator and then added to the report template.

For example,

These parameters can then be extracted The arguments for the report should be the report name and then any user-selected parameters from the parameter web pages (for example, report start time and end time). The other constant parameters defined in the report template are then extracted directly from the database using the standard stored procedure spCmn_GetReportParameterValue.

For example,

CREATE PROCEDURE dbo.spLocal_RptData 
@RptName	varchar(255), 
@RptStartDATETIME varchar(25), 
@RptEndDATETIME	varchar(25)
 
AS

DECLARE @RptTitle	varchar(4000)

-- Get parameter report title
EXEC spCmn_GetReportParameterValue @RptName,	      -- Report name
                                  'strRptTitle'         --Parameter name
                                  'My Report Title',    -- Default value
                                   @RptTitle OUTPUT     -- Actual value