From Bright Pattern Documentation
Contents
- Introduction
- Configuring Jaspersoft Studio
- Prerequisites
- Downloading Libraries and Localization Resources
- Importing Libraries
- Creating a Data Adapter
- Importing Localization Resources
- Customizing JRXML Report Templates
- Downloading Report Templates
- Importing and Modifying Report Templates
- Previewing and Saving Modified Report Templates
- Uploading Modified Report Templates
- Customizing BPXML Report Templates
Custom Reporting Tutorial
BPXML Syntax and Samples
You can create a custom BPXML report template and use it to export CSV data. This section explains the syntax and structure of BPXML report templates.
Syntax
The top level "BPcsvReport" element contains optional "parameters" and "queryString" sub-elements.
"queryString" is a common SQL statement, and it can contain some parameters.
Parameter Types
The following is the full set of supported parameters:
- "agent" – agent selector
- "agentlist" – agent multiple selector
- "end_time"
- "service" – service selector
- "servicelist" – service multiple selector
- "start_time"
- "team” – team selector
- "teamlist" – team multiple selector
- "timeframe" subtypes:
- "start"
- "end" (only one pair per report) – start and end dates selector
- "string" - an arbitrary string value
Sample BPXML Report
<?xml version="1.0" encoding="UTF-8"?> <BPcsvReport version="1.0" resourceBundle="com.brightpattern.reports.oob_reports"> <parameters> <parameter name="start_time" type="timeframe" subtype="start"/> <parameter name="end_time" type="timeframe" subtype="end"/> <parameter name="login_id" type="agent" /> </parameters> <queryString> <![CDATA[ SELECT start_time, first_name, last_name, num_calls_in, num_calls_answered, team_name FROM agent_performance WHERE start_time > $P{start_time} AND login_id=$P{login_id} ]]> </queryString> </BPcsvReport>
"agentlist" Usage Sample
<?xml version="1.0" encoding="UTF-8"?> <BPcsvReport version="1.0" resourceBundle="com.brightpattern.reports.oob_reports"> <parameters> <parameter name="start_time" type="timeframe" subtype="start"/> <parameter name="end_time" type="timeframe" subtype="end"/> <parameter name="login_id" type="agentlist" /> </parameters> <queryString> <![CDATA[ SELECT start_time, first_name, last_name, num_calls_in, num_calls_answered, team_name FROM agent_performance WHERE start_time > $P{start_time} AND login_id IN ($P{login_id})
]] </queryString> </BPcsvReport>