<?xml version="1.0" encoding="UTF-8"?>
<action-sequence> 
  <name>jfreereport-reports-test-1.xaction</name>
  <title>JFreeReport HTML Example</title>
  <version>1</version>
  <logging-level>debug</logging-level>
  <documentation> 
    <author>Marc Batchelor</author>  
    <description><![CDATA[
			This is an example of an HTML report produced by JFreeReport. 
<p/>			It shows the actual headcount cost, budgeted headcount cost, and variance for every position, department and region
<p/>			It demostrates using colors and styles for headers and groupings. It also shows sub-totals.
		]]></description>  
    <icon>/style/icons/jfree1.png</icon>  
    <help>just testing...</help>  
    <result-type>report</result-type> 
  </documentation>

  <inputs> 
    <output-type type="string"> 
      <default-value>html</default-value>  
      <sources> 
        <request>type</request> 
      </sources> 
    </output-type>  
    <REGION type="string"> 
      <sources> 
        <session>REGION</session> 
      </sources> 
    </REGION>  
    <DEPARTMENT type="string"> 
      <sources> 
        <session>DEPARTMENT</session> 
      </sources> 
    </DEPARTMENT>  
    <POSITIONTITLE type="string">
      <sources>
        <session>POSITIONTITLE</session>
      </sources>
    </POSITIONTITLE>
  </inputs>

  <outputs> 
    <!-- an output stream will be provided by default --> 
  </outputs>

  <resources> 
    <!-- use this section to identify any files that the component needs to execute the report -->  
    <report-definition> 
      <solution-file> 
        <location>JFreeQuadrantForRegion.xml</location>  
        <mime-type>text/xml</mime-type> 
      </solution-file> 
    </report-definition> 
  </resources>
  
  <actions> 
    <action-definition> 
      <component-name>JFreeReportComponent</component-name>
      <action-type>report</action-type>
      <action-inputs> 
        <output-type type="string"/>  
        <REGION type="string"/>  
        <DEPARTMENT type="string"/>  
        <POSITIONTITLE type="string"/>
      </action-inputs>
      <action-resources> 
        <report-definition type="resource"/> 
      </action-resources>
      <component-definition> 
        <live>false</live>  
        <jndi>SampleData</jndi>  
        <source>sql</source>  
        <query><![CDATA[select   QUADRANT_ACTUALS.REGION,   QUADRANT_ACTUALS.DEPARTMENT,   QUADRANT_ACTUALS.POSITIONTITLE,   QUADRANT_ACTUALS.ACTUAL,   QUADRANT_ACTUALS.BUDGET,   QUADRANT_ACTUALS.VARIANCE  from QUADRANT_ACTUALS where QUADRANT_ACTUALS.REGION in ( '{REGION}' ) and QUADRANT_ACTUALS.DEPARTMENT in ( '{DEPARTMENT}' ) and  QUADRANT_ACTUALS.POSITIONTITLE in ( '{POSITIONTITLE}' ) order by QUADRANT_ACTUALS.REGION, QUADRANT_ACTUALS.DEPARTMENT]]></query> 
      </component-definition> 
    </action-definition>
 
  </actions> 
</action-sequence>