Pentaho 1.1 and Later XML Examples

These examples apply to 1.1 and later of Pentaho.

Line, Bar, and Area Chart Data Collector Example

<expression class="org.pentaho.plugin.jfreereport.reportcharts.CategorySetCollectorFunction" name="chartDataSource">
 <properties>
  <property name="categoryColumn">CUSTOMERNAME</property>
  <property name="seriesName[0]">Customer Sales</property>
  <property name="seriesName[1]">Customer Margin</property>
  <!-- <property name="seriesName[n]">Series Name</property> -->
  <property name="valueColumn[0]">Total Sales</property>
  <property name="valueColumn[1]">Margin</property>
  <!-- <property name="valueColumn[n]">Column Name</property>  -->
  <property name="summaryOnly">false</property>
  <!-- <property name="group">Customer_Type</property> --><!--  Only use if summaryOnly=true -->
 </properties>
</expression>

Pie Chart Data Collector

<expression class="org.pentaho.plugin.jfreereport.reportcharts.PieSetCollectorFunction" name="ChartDataSource">
  <properties>
     <property name="group">RegionGroup</property><!--  Only use if summaryOnly=true -->
     <property name="seriesColumn">REGION</property>
     <property name="valueColumn">RegionBudget</property>
     <property name="summaryOnly">true</property>
  </properties>
</expression>