Typical Templates

Data Source Objects

Every example given in this article is using one of the following data source objects:

  • manager, an instance of the Manager class
  • managers, an enumeration of instances of the Manager class
  • contracts, an enumeration of instances of the Contract class
  • clients, an enumeration of instances of the Client class

The Manager, Contract, and Client classes are defined as follows.

Templates

Single-Row Template

Template Example

Single_Row_Template_ExampleName: «[manager.Name]»
Age: «[manager.Age]»

You can download the template file of this example from here.

Report Example

Single_Row_Report_ExampleName: John Smith
Age: 37

In-Paragraph List Template

Template Example

We provide support for the following clients: «foreach [in clients]»«[IndexOf() != 0 ? “, " : “"]»«[Name]»«/foreach»

You can download the template file of this example from here.

Report Example

We provide support for the following clients: A Company, B Ltd., C & D, E Corp., F & Partners, G & Co., H Group, I & Sons, J Ent.

Bulleted List Template

Template Example

We provide support for the following clients:
    * <<foreach [in clients]>><<[Name]>>
<</foreach>>

You can download the template file of this example from here.

Report Example

We provide support for the following clients:
    * A Company
    * B Ltd.
    * C & D
    * E Corp.
    * F & Partners
    * G & Co.
    * H Group
    * I & Sons
    * J Ent.

Numbered List Template

Template Example

We provide support for the following clients:
    1. <<foreach [in clients]>><<[Name]>>
<</foreach>>

You can download the template file of this example from here.

Report Example

We provide support for the following clients:
    1. A Company
    2. B Ltd.
    3. C & D
    4. E Corp.
    5. F & Partners
    6. G & Co.
    7. H Group
    8. I & Sons
    9. J Ent.

Multicolored Numbered List Template

Template Example

We provide support for the following clients:
    1. <<foreach [in clients]>><<if [IndexOf() % 2 == 0]>><<[Name]>>
    2. <<else>><<[Name]>>
<</if>><</foreach>>

You can download the template file of this example from here.

Report Example

We provide support for the following clients:
    1. A Company
    2. B Ltd.
    3. C & D
    4. E Corp.
    5. F & Partners
    6. G & Co.
    7. H Group
    8. I & Sons
    9. J Ent.

Common List Template

Template Example

«foreach [in managers]»
Common_List_Template_Example2
«[Name()]»
<</foreach>>

You can download the template file of this example from here.

Report Example

Single_Row_Report_Example1
John Smith
Single_Row_Report_Example
Tony Anderson
Single_Row_Report_Example
July James

In-Table List Template

Template Example

ManagerContract Price
 <<foreach [in managers]>><<[Name()]>> 
 <<[Contracts().sum(c => c.Price())]>><</foreach>> 
 Total: 
 <<[sum(m => m.Contracts().sum(c => c.Price()))]>> 

You can download the template file of this example from here.

Report Example

ManagerContract Price
 John Smith 
 2300000 
 Tony Anderson 
 1200000 
 July James 
 800000 
 Total: 
 4300000 

In-Table List Template with Running (Progressive) Total

Template Example

<<var [total = 0.0]>>

ClientTotal Contract Price
<<foreach [in contracts]>><<[getClient().getName()]>><<var [total = total + getPrice()]>><<[total]>><</foreach>>

Report Example

ClientTotal Contract Price
A Company1200000
B Ltd.1950000
C & D2300000
E Corp.2950000
F & Partners3500000
G & Co.3850000
H Group4100000
I & Sons4200000
J Ent.4300000

In-Table List Template with Highlighted Rows

Template Example

ClientContract Price
<<foreach [in contracts]>><<if [Price() >= 1000000]>><<[Client().Name()]>><<[Price()]>>
<<else>><<[Client().Name()]>><<[Price()]>><</if>><</foreach>>
Total:<<[sum(c => c.Price())]>>

Report Example

ClientContract Price
A Company1200000
B Ltd.750000
C & D350000
E Corp.650000
F & Partners550000
G & Co.350000
H Group250000
I & Sons100000
J Ent.100000
Total:4300000

In-Table List Template with Alternate Content

Template Example

ClientContract Price
«if [!Any()]»No data
«else»«foreach [in contracts]»«[Client.Name]»«[Price]»«/foreach»
Total:«[Sum(c => c.Price)]»«/if»

You can download the template file of this example from here.

Report Example 1

ClientContract Price
No data

Report Example 2

ClientContract Price
A Company1200000
B Ltd.750000
C & D350000
E Corp.650000
F & Partners550000
G & Co.350000
H Group250000
I & Sons100000
J Ent.100000
Total:4300000

Common Master-Detail Template

Template Example

«foreach [in managers]»
Common_List_Template_Example2
«[Name()]»
Clients: «foreach [in Contracts() ]»«[indexOf() != 0 ? “, " : “"]»«[Client().Name()]»«/foreach»
<</foreach>>

You can download the template file of this example from here.

Report Example

Single_Row_Report_Example
John Smith
Clients: A Company, B Ltd., C & D
Single_Row_Report_Example
Tony Anderson
Clients: E Corp., F & Partners
Single_Row_Report_Example
July James
Clients: G & Co., H Group, I & Sons, J Ent.

In-Table Master-Detail Template

Template Example

Manager/ClientContract Price
 <<foreach [in managers]>><<[Name()]>> 
 <<[Contracts().sum(c => c.Price())]>> 
 <<foreach [in Contracts()]>> <<[Client().Name()]>> 
 <<[Price()]>><</foreach>><</foreach>> 
 Total: 
 <<[sum(m => m.Contracts().sum(c => c.Price()))]>> 

You can download the template file of this example from here.

Report Example

Manager/ClientContract Price
 John Smith 
 2300000 
 A Company 
 1200000 
 B Ltd. 
 750000</p><p>
 C & D 
 350000</p><p>
 Tony Anderson 
 1200000</p><p>
 E Corp. 
 650000</p><p>
 F & Partners 
 550000</p><p>
 July James 
 800000</p><p>
 G & Co. 
 350000</p><p>
 H Group 
 250000</p><p>
 I & Sons 
 100000</p><p>
 J Ent. 
 100000</p><p>
 Total: 
 4300000</p><p>

Pie Chart Template

You can download the template file of this example from here.

Template Example

Pie_Chart_Template_Example2

Initial Chart Series Data

Pie_Chart_Series_Data2

Report Example

Pie_Chart_Report_Example

Scatter Chart Template

You can download the template file of this example from here.

Template Example

Scatter_Chart_Template_Example2

Initial Chart Series Data

Scatter_Chart_Series_Data2

Report Example

Scatter_Chart_Report_Example

Bubble Chart Template

You can download the template file of this example from here.

Template Example

Bubble_Chart_Template_Example2

Initial Chart Series Data

Bubble_Chart_Series_Data2

Report Example

Bubble_Chart_Report_Example

In-Table Template with Filtering, Grouping, and Ordering

You can download the template file of this example from here.

Template Example

ManagerContract Price
 <<foreach [in contracts
.Where(c => c.Date().Year() == 2015)
.GroupBy(c => c.Manager())
.OrderBy(g => g.key.Name())]>>
<<[key.Name()]>> 
«[sum(c => c.Price())]»«/foreach»

Report Example

ManagerContract Price
John Smith2300000
July James800000
Tony Anderson1200000

Chart Template with Filtering, Grouping, and Ordering

You can download the template file of this example from here.

Template Example

Chart_Template_Example2

Report Example

Chart_Report_Example