jfreereport-reports-test-param3.xaction 2.44 KB
Newer Older
Thitichaipun Wutthisak committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73
<action-sequence>
	<name>jfreereport-reports-test-param3.xaction</name>
	<version>1</version>
	<title>JFreeReport HTML Example</title>	
    <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>
		<REGION type="string">
			<default-value/>
			<sources>
				<request>REGION</request> 
			</sources>
		</REGION>
		<DEPARTMENT type="string">
			<default-value/>
			<sources>
				<request>DEPARTMENT</request> 
			</sources>
		</DEPARTMENT>
	</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 -->
    	<parameter-template>
      		<solution-file>
        		<location>parameter_template.html</location>
        		<mime-type>text/xml</mime-type>
	      	</solution-file>
    	</parameter-template>
		<report-definition>
			<solution-file>
				<location>JFreeQuadrantForRegion.xml</location>
				<mime-type>text/xml</mime-type>
			</solution-file>
		</report-definition>
	</resources>
  
  <actions>
      <action-definition>

        <action-inputs>
          <output-type type="string"/>
          <REGION type="string"/>
		  <DEPARTMENT type="string"/>
        </action-inputs>
                
	<component-name>JFreeReportComponent</component-name>
        <action-type>report</action-type>
      	<component-definition>
          <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={PREPARE:REGION} and QUADRANT_ACTUALS.DEPARTMENT={PREPARE:DEPARTMENT} order by QUADRANT_ACTUALS.REGION, QUADRANT_ACTUALS.DEPARTMENT]]></query>
	      <xsl>parameter-template</xsl>
	      <output-type>html</output-type>
        </component-definition>
      </action-definition>
  </actions>
</action-sequence>