Reporting Dashboard - Displaying Multiple Reports
A single report can contain one or more reports (SQL queries). Each report is displayed as a table of results.
To add additional reports to your report, simply add a new report, .
Example: The example below shows how to construct a report that contains two sub reports, Calls Logged For The Period and Calls Closed For The 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>
<column id="1" visible="true">No. of Calls Logged</column>
</Columns>
</Report>
<Report>
<Title>Calls Closed 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 DATEDIFF(ss, tbl_Calls.Closed, tbl_Calls.DueDate) >= 0 AND tbl_Calls.QueueID = [PARAM1]
</Query>
<Columns>
<column id="1" visible="true">No. Of Calls Logged And Closed Prior To Due Date</column>
</Columns>
</Report>
</Reporting>
]]>
See Also
Overview
Writing a Report
Passing Parameters
Specifying a Date Range
Customizing Columns
Adding Hyperlinks