Reporting Dashboard - Passing Parameters

The following table provides a list of tags that define all of the available parameters that can be passed to the report engine.

The integer value of these tags is derived from the corresponding parameter list. Consequently, when defining a tag within the report SQL, you must ensure that the appropriate parameter list is enabled.

Queue	[PARAM1]
SkillGroup	[PARAM2]
User	[PARAM3]
CallType	[PARAM4]
Status	[PARAM5]
ReceivedBy	[PARAM6]
Urgency	[PARAM7]
Product Type	[PARAM8]
Risk	[PARAM9]
Product	[PARAM10]
Priority	[PARAM11]
Impact	[PARAM12]
Key 1	[PARAM13]
Service Area	[PARAM14]
Key 2	[PARAM15]
Symptom Code	[PARAM16]
Key 3	[PARAM17]
Cause Code	[PARAM18]

Example: This example shows how to construct a report showing the Current Calls for an Operator specified System Queue.

Sample Code

<Reporting> <ReportTitle>Current Calls For Help Desk Queue</ReportTitle> <ReportHeader></ReportHeader> <ReportFooter></ReportFooter> <Parameters> <Queue>true</Queue> <SkillGroup></SkillGroup> <User></User> <CallType></CallType> <ReceivedBy></ReceivedBy> <Status></Status> <Priority></Priority> <Key1></Key1> <Key2></Key2> <Key3></Key3> </Parameters> <Report> <Title>Current Calls</Title> <Totals></Totals> <Query>SELECT CallID, Subject FROM tbl_Calls WHERE QueueID = [PARAM1] AND CallStatusID IN (1, 2, 4, 7)</Query> <Columns></Columns> </Report> </Reporting>

Note: In the example above. the Queue list has been enabled by setting the Queue parameter to true. (i.e. true).

When the operator selects a Queue from the available list, the unique QueueID is passed to the report engine as [PARAM1]. The SQL syntax for the report is then parsed and all instances of [PARAM1] are replaced with the selected QueueID.

Security: Non-Administrators, the operator will only be presented with a list of available Queues for which they are a member of. System Administrators will be presented with all available Queues.

Reporting Dashboard - Passing Parameters

See Also