<?xml version="1.0" encoding="UTF-8"?>
<document version="9" show-margin="true" margin="36 36 36 36" null-string="&lt;NA&gt;">
  <datasource type="jdbc" driver-class="org.hsqldb.jdbcDriver" connection-url="jdbc:hsqldb:hsql://demo.reportmill.com/world" username="guest" query="SELECT cy.NAME as City, cy.POPULATION , co.NAME as Country from CITY cy, COUNTRY co where cy.COUNTRYCODE=co.CODE ORDER BY cy.POPULATION DESC" default-dataset-name="CITIES" />
  <page width="792" height="612">
    <graph x="45" y="45" width="703" height="464" name="CITIES" type="bar" list-key="CITIES" key0="this[0].POPULATION" key1="this[1].POPULATION" key2="this[2].POPULATION" key="COUNTRY" topn="total.POPULATION" topn-order="descend" topn-count="6" colors="#5064cd #50af64 #cd5050">
      <stroke type="harvard-rule" outerwidth="2" positions="1" />
      <text x="5" y="5" width="612" height="50" asize="-~-,--~">
        <font name="Arial Bold" size="24" />
        <string>Most Populous Countries&#10;</string>
        <font name="Arial Italic" size="14" />
        <string>(population of 3 largest cities shown)</string>
        <font name="Arial Bold" size="24" />
        <string>&#10;</string>
      </text>
      <graph-area x="32" y="52" width="641" height="357" asize="-~-,-~-" items-layout="Stacked">
        <stroke />
        <fill color="#ffffff" />
        <value-axis>
          <font name="Arial Bold" size="11" />
        </value-axis>
        <label-axis item-key="@COUNTRY@">
          <font name="Arial Bold" size="11" />
        </label-axis>
        <series position="middle">
          <stroke />
          <fill color="#c3c3c3" />
          <string>@this[0].CITY@</string>
        </series>
        <series position="middle">
          <stroke />
          <fill color="#c3c3c3" />
          <string>@this[1].CITY@</string>
        </series>
        <series position="middle">
          <stroke />
          <fill color="#c3c3c3" />
          <string>@this[2].CITY@</string>
        </series>
        <scene3d depth="119" yaw="20.19" pitch="8.488" focal-length="1224" />
      </graph-area>
      <sort key="total.POPULATION" order="descend" />
    </graph>
  </page>
</document>
