Reporting Dashboard - Specifying a Date Range
The Start Date and End Date can be passed to your report using the tags [STARTDATE1] and [ENDDATE1]
respectively. This allows you to construct date range specific reports.
Example: This example shows how to construct a report showing the Calls logged for an operator defined period:
Sample Code
<![CDATA[
<Reporting>
<ReportTitle>Call Logging Summary Report</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>Calls Logged For The Period [STARTDATE1] to [ENDDATE1]</Title>
<Totals></Totals>
<Query>SELECT Count(tbl_Calls.CallID) FROM tbl_Calls WHERE (tbl_Calls.DateEntered BETWEEN '[STARTDATE1] 00:00:00' AND '[ENDDATE1] 23:59:59') AND tbl_Calls.QueueID = [PARAM1]</Query>
<Columns></Columns>
</Report>
</Reporting>
]]>
See Also
Overview
Writing a Report
Passing Parameters
Customizing Columns
Adding Hyperlinks
Displaying Multiple Reports