Constants
The following tables list the constants defined in the CSReports.sql file for use in creating parameterized reports.
DataType
ParamType
ParamType_DateRange Operand
ParamType_Expression Operand
ParamType_SelectOrder Operand
ParamType_SiteName Operand
DataType
The following table lists the valid data types.
| Data type | Value |
| DataType_date | 1 |
| DataType_integer | 2 |
| DataType_float | 3 |
| DataType_currency | 4 |
| DataType_text | 5 |
ParamType
The following table lists the valid parameter types. The Constraint column lists where the parameter type is used in the query.
| Parameter type | Value | Constraint |
| ParamType_SingleValue | 0 | Anywhere |
| ParamType_Expression | 1 | WHERE clause |
| ParamType_SelectOrder | 2 | SELECT clause |
| ParamType_DateRange | 3 | WHERE clause |
| ParamType_SiteName | 4 | WHERE clause |
ParamType_DateRange Operand
The following table lists the valid date range operands.
| Operand | Value |
| DateRangeOpnd_All | 0 |
| DateRangeOpnd_From | 1 |
| DateRangeOpnd_OnOrBefore | 2 |
| DateRangeOpnd_Today | 3 |
| DateRangeOpnd_ThisWeek | 4 |
| DateRangeOpnd_ThisMonth | 5 |
| DateRangeOpnd_ThisQuarter | 6 |
| DateRangeOpnd_ThisYear | 7 |
| DateRangeOpnd_Yesterday | 8 |
| DateRangeOpnd_LastWeek | 9 |
| DateRangeOpnd_LastMonth | 10 |
| DateRangeOpnd_LastQuarter | 11 |
| DateRangeOpnd_LastYear | 12 |
ParamType_Expression Operand
The following table lists the valid expression operands.
| Operand | Value | Constraint |
| ExpOpnd_None | 0 | None |
| ExpOpnd_Equals | 1 | None |
| ExpOpnd_NotEquals | 2 | None |
| ExpOpnd_IsNull | 3 | None |
| ExpOpnd_IsNotNull | 4 | None |
| ExpOpnd_LessThan | 5 | Numeric data types only |
| ExpOpnd_LessThanOrEquals | 6 | Numeric data types only |
| ExpOpnd_GreaterThan | 7 | Numeric data types only |
| ExpOpnd_GreaterThanOrEquals | 8 | Numeric data types only |
| ExpOpnd_Like | 9 | Char data type only |
| ExpOpnd_NotLike | 10 | Char data type only |
ParamType_SelectOrder Operand
The following table lists the valid select order operands.
| Operand | Value | Constraint |
| SelectOrderOpnd_All | 0 | SQL only |
| SelectOrderOpnd_Distinct | 1 | SQL only |
| SelectOrderOpnd_Top | 2 | SQL and MDX |
| SelectOrderOpnd_Bottom | 3 | MDX only |
ParamType_SiteName Operand
The following table lists the valid site name operands. This operand is applicable only for SQL queries.
| Operand | Value |
| SiteNameOpnd_All | 0 |
| SiteNameOpnd_Equals | 1 |
| SiteNameOpnd_NotEquals | 2 |
| SiteNameOpnd_Like | 3 |
| SiteNameOpnd_NotLike | 4 |