Reporting Dashboard - Customizing Columns

The Columns element of the report allows you to define how the output columns are displayed. This includes:

Column heading
Visibility of the column
Column item prefix
Column item suffix
Column totals
Hyperlinks

Each column must be assigned a unique id ranging from 1 to the number of columns returned by the SQL query.

If you define one of the output columns, you must define all of them otherwise the report will not be displayed.

Each column is defined by the following attributes:

id:

visible: Optional attribute that defines whether the column is displayed. Possible values: true or false.

width: Optional attribute that defines the width of the column in pixels.

align: Optional attribute that defines how the item is aligned in the column. Possible values: left, right and center.

prefix: Optional attribute that defines the text to be displayed before the item.

suffix: Optional attribute that defines the text to be displayed before the item.

total: Optional attribute that defines whether items within the column are totalled.***

href: Optional attribute that defines the hyperlink associated with all items of the column.

*** items are only totalled if the report has totalled enabled, i.e. true.

Example: This example displays a list of Closed Calls that were logged within an Operator defined period includes billing details. The example also illustrates how to change the default column headings, CallID changed to Case Number, add a column prefix and apply totals.

Sample Code

<Reporting> <ReportTitle>Closed Cases - Billing Details</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>Cases Closed - Logged Within The Period [STARTDATE1] to [ENDDATE1]</Title> <Totals>true</Totals> <Query> SELECT tbl_Calls.CallID, tbl_Calls.Subject, tbl_Billing.Charge FROM tbl_Calls LEFT OUTER JOIN tbl_Billing ON tbl_Calls.CallID = tbl_Billing.CallID WHERE (tbl_Calls.QueueID = 1) AND (tbl_Calls.CallStatusID = 3) AND (tbl_Calls.DateEntered BETWEEN '[STARTDATE1] 00:00:00 AM' AND '[ENDDATE1] 11:59:59 PM') AND tbl_Calls.QueueID = [PARAM1] </Query> <Columns> <column id="1" visible="true">Case Number</column> <column id="2" visible="true">Problem</column> <column id="3" visible="true" prefix="$" align="right" total="true">Charge Amount</column> </Columns> </Report> </Reporting>

Reporting Dashboard - Customizing Columns

See Also