<?xml version="1.0" standalone="yes"?>

<rml:report keep-page-count="Yes" cache-all-properties="Yes" style="" xmlns:rml="http://www.elixirtech.com/ElixirReport/RML">
  <rml:metadata version="2" location="/ElixirSamples/Report/Grouping/GroupOnDate-Quarter-Drilldown.rml">
  </rml:metadata><rml:function-definitions xml:space="preserve" language="javascript">var calendar = java.util.Calendar.getInstance();

function getQuarter(date)
{
 calendar.setTime(date);
 month = calendar.get(java.util.Calendar.MONTH);
 if (month &gt;=0 &amp;&amp; month &lt; 3)
      return "Q1";
 else if (month &gt;= 3 &amp;&amp; month &lt; 6)
      return "Q2";
 else if (month &gt;=6 &amp;&amp; month &lt; 9)
      return "Q3";
 else
      return "Q4";
}</rml:function-definitions>
  <rml:layout-master-set>
    <rml:page-setup name="Default" paper="iso-a4" page-width="11905" page-height="16837" orientation="Portrait" horizontal-page-count="1" margin-top="1440" margin-left="1440" margin-bottom="1440" margin-right="1440" column-count="1" column-spacing="0" row-spacing="0" column-layout="Down Then Across">
    </rml:page-setup>
  </rml:layout-master-set>
  <rml:parameters>
  </rml:parameters>
  <rml:datasources>
    <rml:datasource name="Default" datasource-name="/ElixirSamples/Report/Grouping/datasource/StringNumberDate.ds" tabulate="Yes">
      <rml:parameters>
      </rml:parameters>
    </rml:datasource>
  </rml:datasources>
  <rml:styles>
    <rml:style name="detail">
      <rml:item name="Common.KeepTogether" value="Yes">
      </rml:item>
      <rml:item name="RawElement.Growable" value="Yes">
      </rml:item>
      <rml:item name="RawElement.Shrinkable" value="Yes">
      </rml:item>
    </rml:style>
    <rml:style name="field">
      <rml:item name="TextElement.FontSize" value="240">
      </rml:item>
      <rml:item name="Grid.AutoWrap" value="Yes">
      </rml:item>
      <rml:item name="RawElement.Growable" value="Yes">
      </rml:item>
      <rml:item name="TextElement.FontName" value="Serif">
      </rml:item>
      <rml:item name="RawElement.Shrinkable" value="Yes">
      </rml:item>
    </rml:style>
    <rml:style name="field.literal" base-name="field">
      <rml:item name="RawElement.Growable" value="No">
      </rml:item>
      <rml:item name="RawElement.Shrinkable" value="No">
      </rml:item>
    </rml:style>
    <rml:style name="group-footer">
      <rml:item name="RawElement.Growable" value="Yes">
      </rml:item>
      <rml:item name="RawElement.Shrinkable" value="Yes">
      </rml:item>
    </rml:style>
    <rml:style name="group-header">
      <rml:item name="RawElement.Growable" value="Yes">
      </rml:item>
      <rml:item name="RawElement.Shrinkable" value="Yes">
      </rml:item>
    </rml:style>
    <rml:style name="page.label">
      <rml:item name="TextElement.FontSize" value="240">
      </rml:item>
      <rml:item name="TextElement.FontUnderline" value="No">
      </rml:item>
      <rml:item name="TextElement.FontName" value="Serif">
      </rml:item>
      <rml:item name="TextElement.FontBold" value="Yes">
      </rml:item>
      <rml:item name="TextElement.FontColor" value="Black">
      </rml:item>
      <rml:item name="TextElement.FontItalic" value="No">
      </rml:item>
    </rml:style>
    <rml:style name="page.text">
      <rml:item name="TextElement.FontSize" value="240">
      </rml:item>
      <rml:item name="TextElement.FontUnderline" value="No">
      </rml:item>
      <rml:item name="TextElement.FontName" value="Serif">
      </rml:item>
      <rml:item name="TextElement.FontBold" value="No">
      </rml:item>
      <rml:item name="TextElement.FontColor" value="Black">
      </rml:item>
      <rml:item name="TextElement.FontItalic" value="No">
      </rml:item>
    </rml:style>
    <rml:style name="rect">
      <rml:item name="RawElement.BorderStyle" value="Solid">
      </rml:item>
      <rml:item name="Rectangle.BorderTop" value="Yes">
      </rml:item>
      <rml:item name="RawElement.BorderColor" value="rgb(0,0,0)">
      </rml:item>
      <rml:item name="Rectangle.BorderBottom" value="Yes">
      </rml:item>
      <rml:item name="Common.BackgroundColor" value="rgb(255,255,255)">
      </rml:item>
      <rml:item name="Rectangle.BorderRight" value="Yes">
      </rml:item>
      <rml:item name="Rectangle.BorderLeft" value="Yes">
      </rml:item>
    </rml:style>
    <rml:style name="section.label">
      <rml:item name="TextElement.FontSize" value="400">
      </rml:item>
      <rml:item name="TextElement.FontUnderline" value="No">
      </rml:item>
      <rml:item name="TextElement.FontName" value="Serif">
      </rml:item>
      <rml:item name="TextElement.FontBold" value="Yes">
      </rml:item>
      <rml:item name="TextElement.FontColor" value="Black">
      </rml:item>
      <rml:item name="TextElement.FontItalic" value="No">
      </rml:item>
    </rml:style>
    <rml:style name="section.text">
      <rml:item name="TextElement.FontSize" value="400">
      </rml:item>
      <rml:item name="TextElement.FontUnderline" value="No">
      </rml:item>
      <rml:item name="TextElement.FontName" value="Serif">
      </rml:item>
      <rml:item name="TextElement.FontBold" value="No">
      </rml:item>
      <rml:item name="TextElement.FontColor" value="Black">
      </rml:item>
      <rml:item name="TextElement.FontItalic" value="No">
      </rml:item>
    </rml:style>
    <rml:style name="simple.label">
      <rml:item name="RawElement.BorderStyle" value="Solid">
      </rml:item>
      <rml:item name="RawElement.BorderColor" value="rgb(0,0,0)">
      </rml:item>
      <rml:item name="TextElement.FontSize" value="280">
      </rml:item>
      <rml:item name="RawElement.PaddingRight" value="100">
      </rml:item>
      <rml:item name="RawElement.PaddingTop" value="100">
      </rml:item>
      <rml:item name="RawElement.BorderWidth" value="20">
      </rml:item>
      <rml:item name="Rectangle.BorderBottom" value="Yes">
      </rml:item>
      <rml:item name="TextElement.FontBold" value="Yes">
      </rml:item>
      <rml:item name="RawElement.PaddingLeft" value="100">
      </rml:item>
      <rml:item name="Rectangle.BorderRight" value="Yes">
      </rml:item>
      <rml:item name="TextElement.FontColor" value="rgb(255,255,255)">
      </rml:item>
      <rml:item name="TextElement.FontItalic" value="No">
      </rml:item>
      <rml:item name="RawModelElement.RenderIf" value="">
      </rml:item>
      <rml:item name="Rectangle.BorderTop" value="Yes">
      </rml:item>
      <rml:item name="RawElement.Growable" value="Yes">
      </rml:item>
      <rml:item name="Common.BackgroundColor" value="rgb(0,102,0)">
      </rml:item>
      <rml:item name="TextElement.FontName" value="Serif">
      </rml:item>
      <rml:item name="Rectangle.BorderLeft" value="Yes">
      </rml:item>
      <rml:item name="RawElement.PaddingBottom" value="100">
      </rml:item>
    </rml:style>
    <rml:style name="simple.text">
      <rml:item name="RawElement.BorderStyle" value="Solid">
      </rml:item>
      <rml:item name="RawElement.BorderColor" value="rgb(0,0,0)">
      </rml:item>
      <rml:item name="TextElement.FontSize" value="240">
      </rml:item>
      <rml:item name="RawElement.BorderWidth" value="20">
      </rml:item>
      <rml:item name="Rectangle.BorderBottom" value="Yes">
      </rml:item>
      <rml:item name="TextElement.FontBold" value="No">
      </rml:item>
      <rml:item name="Rectangle.BorderRight" value="Yes">
      </rml:item>
      <rml:item name="TextElement.FontItalic" value="No">
      </rml:item>
      <rml:item name="Rectangle.BorderTop" value="Yes">
      </rml:item>
      <rml:item name="RawElement.Growable" value="Yes">
      </rml:item>
      <rml:item name="TextElement.FontName" value="Serif">
      </rml:item>
      <rml:item name="RawElement.Shrinkable" value="No">
      </rml:item>
      <rml:item name="Rectangle.BorderLeft" value="Yes">
      </rml:item>
    </rml:style>
    <rml:style name="sub-report">
      <rml:item name="RawElement.Growable" value="Yes">
      </rml:item>
      <rml:item name="RawElement.Shrinkable" value="Yes">
      </rml:item>
    </rml:style>
    <rml:style name="table">
      <rml:item name="RawElement.Growable" value="Yes">
      </rml:item>
      <rml:item name="RawElement.Shrinkable" value="Yes">
      </rml:item>
    </rml:style>
  </rml:styles>
  <rml:stylesheets>
  </rml:stylesheets>
  <rml:sections>
    <rml:section name="Section 1" page-setup-ref="Default" data-source="Default" border-style="None" border-color="Black" show-header="Yes" show-footer="No" show-page-header="No" show-page-footer="Yes" keep-blank-pages="No" reset-page-count="No" style="">
      <rml:watermark report="" section="" enabled="No">
        <rml:parameters>
        </rml:parameters>
      </rml:watermark>
      <rml:section-header table-of-contents="No" can-grow="Yes" can-shrink="Yes" height="4780" fill="No" style="Default"><rml:control-source xml:space="preserve" type="Literal" running-value="No"></rml:control-source>
        <rml:field name="Sorting" left="0" top="0" width="9025" height="1158" style="section.label"><rml:control-source xml:space="preserve" type="Literal" running-value="No">Group On Date : Quarter</rml:control-source>
        </rml:field>
        <rml:chart datasource="" datarange="Group" left="0" top="1158" width="9024" height="3640" style="">
          <rml:document><cml:chart category="Column-Category" type="Column-3D" xmlns:cml="http://www.elixirtech.com/CML"><cml:category inverted="No" retain-key-order="No"><cml:title anchor="North"><cml:font font-family="SansSerif" font-color="Black" font-size="240"></cml:font><cml:control-source xml:space="preserve" type="Literal" running-value="No"></cml:control-source></cml:title><cml:legend anchor="East"><cml:font font-family="SansSerif" font-color="Black" font-size="200"></cml:font><cml:control-source xml:space="preserve" type="Literal" running-value="No"></cml:control-source></cml:legend><cml:key-source xml:space="preserve" type="Script" running-value="No">=getQuarter(Date);</cml:key-source><cml:value-sources><cml:control-source xml:space="preserve" type="Operation" field="Date" operation="Count" running-value="No" range="All" display-name="Total Number of Records"></cml:control-source></cml:value-sources><cml:category-ui><cml:key-axis><cml:label xml:space="preserve"><cml:font font-family="SansSerif" font-color="Black" font-size="240"></cml:font></cml:label><cml:tick show-tick-marks="Yes"><cml:font font-family="SansSerif" font-color="Black" font-size="200"></cml:font><cml:format type="None" min-integer-digits="0" max-integer-digits="0" min-fraction-digits="0" max-fraction-digits="0" grouping-used="No" grouping-size="0" decimal-separator-always-shown="No" date-format="Short" time-format="Short"></cml:format></cml:tick></cml:key-axis><cml:value-axis><cml:label xml:space="preserve"><cml:font font-family="SansSerif" font-color="Black" font-size="240"></cml:font></cml:label><cml:tick show-tick-marks="Yes"><cml:font font-family="SansSerif" font-color="Black" font-size="200"></cml:font><cml:format type="None" min-integer-digits="0" max-integer-digits="0" min-fraction-digits="0" max-fraction-digits="0" grouping-used="No" grouping-size="0" decimal-separator-always-shown="No" date-format="Short" time-format="Short"></cml:format></cml:tick></cml:value-axis><cml:value visible="No"><cml:font font-family="SansSerif" font-color="Black" font-size="200"></cml:font><cml:format type="None" min-integer-digits="0" max-integer-digits="0" min-fraction-digits="0" max-fraction-digits="0" grouping-used="No" grouping-size="0" decimal-separator-always-shown="No" date-format="Short" time-format="Short"></cml:format></cml:value><cml:parameters></cml:parameters></cml:category-ui></cml:category><cml:on-configure xml:space="preserve" language="javascript"></cml:on-configure></cml:chart>
          </rml:document>
        </rml:chart>
        <rml:ruler>
        </rml:ruler>
      </rml:section-header>
      <rml:section-footer table-of-contents="No" can-grow="Yes" can-shrink="Yes" height="0" style="">
        <rml:ruler>
        </rml:ruler>
      </rml:section-footer>
      <rml:page-header height="0" style="">
        <rml:ruler>
        </rml:ruler>
      </rml:page-header>
      <rml:page-footer height="460" style="">
        <rml:hbox left="0" top="0" width="9025" height="460" fill="Yes" style="">
          <rml:cell weight="100" left="0" top="0" width="4512" height="460" style="">
            <rml:field name="Date" left="0" top="0" width="4512" height="460" style="page.text">
              <rml:format type="Date/Time" min-integer-digits="1" max-integer-digits="12" min-fraction-digits="2" max-fraction-digits="2" grouping-used="Yes" grouping-size="3" decimal-separator-always-shown="Yes" date-format="Full" time-format="Short">
              </rml:format><rml:control-source xml:space="preserve" type="Script" field="Date" running-value="No">new java.util.Date()</rml:control-source>
            </rml:field>
          </rml:cell>
          <rml:cell weight="100" left="4512" top="0" width="4513" height="460" style="">
            <rml:field text-align="Right" name="Page" left="4512" top="0" width="4513" height="460" style="page.text"><rml:control-source xml:space="preserve" type="Script" field="Page" running-value="No">"${#} of ${##}"</rml:control-source>
            </rml:field>
          </rml:cell>
        </rml:hbox>
        <rml:ruler>
        </rml:ruler>
      </rml:page-footer>
      <rml:detail table-of-contents="No" can-grow="Yes" can-shrink="Yes" height="1520" fill="No" style="Default"><rml:on-render-begin xml:space="preserve" language="javascript">count++;</rml:on-render-begin><rml:control-source xml:space="preserve" type="Literal" running-value="No"></rml:control-source>
        <rml:vbox left="0" top="0" width="9025" height="1520" fill="Yes" style="">
          <rml:cell weight="100" left="0" top="0" width="9025" height="542">
            <rml:hbox left="0" top="0" width="9025" height="542" fill="Yes" style=""><rml:render-if xml:space="preserve" language="javascript">count==1;</rml:render-if>
              <rml:cell weight="100" left="0" top="0" width="4512" height="542" style="">
                <rml:field font-size="280" font-bold="Yes" name="Date" fill="Yes" left="0" top="0" width="4512" height="542" background-color="rgb(204,255,204)" can-shrink="Yes" padding-left="100" padding-right="100" padding-top="100" padding-bottom="100" style="simple.text"><rml:control-source xml:space="preserve" type="Script" running-value="No">=getQuarter(Date);</rml:control-source>
                </rml:field>
              </rml:cell>
              <rml:cell weight="100" left="4512" top="0" width="4513" height="542" style="">
                <rml:field text-align="Right" font-size="280" font-bold="Yes" font-italic="Yes" name="Total Records" fill="Yes" left="4512" top="0" width="4513" height="542" border-style="Solid" background-color="rgb(255,255,153)" padding-left="100" padding-right="100" padding-top="100" padding-bottom="100" style=""><rml:control-source xml:space="preserve" type="Script" running-value="No">="Total Number of Records: " + Data.getCount("Date").getValueOverGroup()</rml:control-source>
                </rml:field>
              </rml:cell>
            </rml:hbox>
          </rml:cell>
          <rml:cell weight="100" left="0" top="542" width="9025" height="543" style=""><rml:render-if xml:space="preserve" language="javascript"></rml:render-if>
            <rml:hbox visible="Yes" left="0" top="542" width="9025" height="543" fill="Yes" style=""><rml:render-if xml:space="preserve" language="javascript">count==1;</rml:render-if>
              <rml:cell weight="100" left="0" top="542" width="3008" height="543" fill="Yes" style="">
                <rml:field hide-duplicates="No" text-align="Center" name="Date" left="0" top="542" width="3008" height="543" can-shrink="No" style="simple.label"><rml:render-if xml:space="preserve" language="javascript">count==1;</rml:render-if><rml:control-source xml:space="preserve" type="Literal" field="Date" running-value="No">Date</rml:control-source>
                </rml:field>
              </rml:cell>
              <rml:cell weight="100" left="3008" top="542" width="3008" height="543" fill="Yes" style="">
                <rml:field hide-duplicates="No" text-align="Center" name="Number" left="3008" top="542" width="3008" height="543" can-shrink="No" style="simple.label"><rml:control-source xml:space="preserve" type="Literal" field="Number" running-value="No">Number</rml:control-source>
                </rml:field>
              </rml:cell>
              <rml:cell weight="100" left="6016" top="542" width="3009" height="543" fill="Yes" style="">
                <rml:field hide-duplicates="No" text-align="Center" name="String" left="6016" top="542" width="3009" height="543" can-shrink="No" style="simple.label"><rml:control-source xml:space="preserve" type="Literal" field="String" running-value="No">String</rml:control-source>
                </rml:field>
              </rml:cell>
            </rml:hbox>
          </rml:cell>
          <rml:cell weight="80" left="0" top="1085" width="9025" height="435" style="">
            <rml:hbox visible="Yes" left="0" top="1085" width="9025" height="435" fill="Yes" style="">
              <rml:cell weight="100" left="0" top="1085" width="3008" height="435" fill="Yes" style="">
                <rml:field text-align="Center" name="Date" left="0" top="1085" width="3008" height="435" style="simple.text">
                  <rml:format type="Date/Time" min-integer-digits="1" max-integer-digits="12" min-fraction-digits="2" max-fraction-digits="2" grouping-used="Yes" grouping-size="3" decimal-separator-always-shown="Yes" date-format="Long" time-format="None">
                  </rml:format><rml:control-source xml:space="preserve" type="Field" field="Date" running-value="No">Date</rml:control-source>
                </rml:field>
              </rml:cell>
              <rml:cell weight="100" left="3008" top="1085" width="3008" height="435" fill="Yes" style="">
                <rml:field text-align="Center" name="Number" left="3008" top="1085" width="3008" height="435" style="simple.text">
                  <rml:format type="Number" min-integer-digits="1" max-integer-digits="12" min-fraction-digits="0" max-fraction-digits="0" grouping-used="No" grouping-size="3" decimal-separator-always-shown="No" date-format="Short" time-format="Short">
                  </rml:format><rml:control-source xml:space="preserve" type="Field" field="Number" running-value="No">Number</rml:control-source>
                </rml:field>
              </rml:cell>
              <rml:cell weight="100" left="6016" top="1085" width="3009" height="435" fill="Yes" style="">
                <rml:field text-align="Center" name="String" left="6016" top="1085" width="3009" height="435" style="simple.text"><rml:control-source xml:space="preserve" type="Field" field="String" running-value="No">String</rml:control-source>
                </rml:field>
              </rml:cell>
            </rml:hbox>
          </rml:cell>
        </rml:vbox>
        <rml:ruler>
        </rml:ruler>
      </rml:detail>
      <rml:group field="Date" sort-order="Ascending" group-header-visible="Yes" group-footer-visible="Yes" group-on="Quarter" group-data="">
        <rml:group-header table-of-contents="Yes" height="580" style=""><rml:on-render-begin xml:space="preserve" language="javascript">count=0;</rml:on-render-begin><rml:control-source xml:space="preserve" type="Script" running-value="No">=getMonth(Date)</rml:control-source>
          <rml:hbox left="0" top="0" width="9025" height="580" fill="Yes" style="">
            <rml:cell weight="100" left="0" top="0" width="4512" height="580" style="">
              <rml:field font-size="280" font-bold="Yes" name="Date" fill="Yes" left="0" top="0" width="4512" height="580" background-color="rgb(204,255,204)" can-shrink="Yes" padding-left="100" padding-right="100" padding-top="100" padding-bottom="100" style="simple.text"><rml:control-source xml:space="preserve" type="Script" running-value="No">=getQuarter(Date);</rml:control-source>
              </rml:field>
            </rml:cell>
            <rml:cell weight="100" left="4512" top="0" width="4513" height="580" style="">
              <rml:field text-align="Right" font-size="280" font-bold="Yes" font-italic="Yes" name="Total Records" fill="Yes" left="4512" top="0" width="4513" height="580" border-style="Solid" background-color="rgb(255,255,153)" padding-left="100" padding-right="100" padding-top="100" padding-bottom="100" style=""><rml:control-source xml:space="preserve" type="Script" running-value="No">="Total Number of Records: " + Data.getCount("Date").getValueOverGroup()</rml:control-source>
              </rml:field>
            </rml:cell>
          </rml:hbox>
          <rml:ruler>
          </rml:ruler>
        </rml:group-header>
        <rml:group-footer table-of-contents="No" height="0" style="">
          <rml:ruler>
          </rml:ruler>
        </rml:group-footer>
      </rml:group>
      <rml:ruler>
      </rml:ruler>
    </rml:section>
  </rml:sections>
  <rml:sequence>
    <rml:section-invocation section="Section 1" enabled="Yes">
      <rml:parameters>
      </rml:parameters>
    </rml:section-invocation>
  </rml:sequence>
  <rml:rendering>
    <rml:render-details mime-type="application/x-glint">
      <rml:parameters><rml:param xml:space="preserve" key="Tree">No</rml:param>
      </rml:parameters>
    </rml:render-details>
    <rml:render-details mime-type="application/vnd.ms-excel">
      <rml:parameters><rml:param xml:space="preserve" key="Snap">No</rml:param><rml:param xml:space="preserve" key="Paged">No</rml:param>
      </rml:parameters>
    </rml:render-details>
    <rml:render-details mime-type="application/x-html-zip">
      <rml:parameters><rml:param xml:space="preserve" key="TreeNormalColor"></rml:param><rml:param xml:space="preserve" key="Streamed">No</rml:param><rml:param xml:space="preserve" key="Tree">Yes</rml:param><rml:param xml:space="preserve" key="SVGPassThrough">No</rml:param><rml:param xml:space="preserve" key="Paged">No</rml:param><rml:param xml:space="preserve" key="Sectioned">No</rml:param><rml:param xml:space="preserve" key="TreeHighlightColor">Yellow</rml:param><rml:param xml:space="preserve" key="SkipHeaders">No</rml:param>
      </rml:parameters>
    </rml:render-details>
    <rml:render-details mime-type="application/pdf">
      <rml:parameters><rml:param xml:space="preserve" key="RenderAsImage">No</rml:param><rml:param xml:space="preserve" key="OwnerPassword"></rml:param><rml:param xml:space="preserve" key="CJKMappingURL"></rml:param><rml:param xml:space="preserve" key="AllowFillIn">No</rml:param><rml:param xml:space="preserve" key="AllowAssembly">No</rml:param><rml:param xml:space="preserve" key="Encryption">No</rml:param><rml:param xml:space="preserve" key="AllowModifyContents">No</rml:param><rml:param xml:space="preserve" key="RenderAsImageDPI"></rml:param><rml:param xml:space="preserve" key="EncryptionStrength">128 bits</rml:param><rml:param xml:space="preserve" key="AllowScreenReaders">No</rml:param><rml:param xml:space="preserve" key="AllowModifyAnnotations">No</rml:param><rml:param xml:space="preserve" key="AllowCopy">No</rml:param><rml:param xml:space="preserve" key="AllowDegradedPrinting">No</rml:param><rml:param xml:space="preserve" key="AllowPrinting">No</rml:param><rml:param xml:space="preserve" key="UserPassword"></rml:param><rml:param xml:space="preserve" key="Greyscale">No</rml:param><rml:param xml:space="preserve" key="RenderTextAPI">Yes</rml:param>
      </rml:parameters>
    </rml:render-details>
  </rml:rendering></rml:report>

