Helix SwarmHelix Swarm

JobChanges.rptdesign

  • //
  • guest/
  • perforce_software/
  • p4todb/
  • examples/
  • birt/
  • JobChanges.rptdesign #2
  • View
  • Commits
  • Open Download .zip Download (18 KB) 
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21" id="1">
  3.     <property name="createdBy">Eclipse BIRT Designer Version 2.5.2.v20100208 Build &lt;2.5.2.v20100210-0630></property>
  4.     <property name="units">in</property>
  5.     <property name="iconFile">/templates/blank_report.gif</property>
  6.     <property name="bidiLayoutOrientation">ltr</property>
  7.     <parameters>
  8.         <scalar-parameter name="since_param" id="61">
  9.             <text-property name="helpText">ex. 2009-11-21 13:40:00</text-property>
  10.             <text-property name="promptText">Since</text-property>
  11.             <property name="valueType">static</property>
  12.             <property name="isRequired">false</property>
  13.             <property name="dataType">string</property>
  14.             <property name="distinct">true</property>
  15.             <simple-property-list name="defaultValue">
  16.                 <value type="constant">1970-01-01 00:00:00</value>
  17.             </simple-property-list>
  18.             <property name="paramType">simple</property>
  19.             <property name="controlType">text-box</property>
  20.             <structure name="format">
  21.                 <property name="category">Unformatted</property>
  22.             </structure>
  23.         </scalar-parameter>
  24.     </parameters>
  25.     <data-sources>
  26.         <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="7">
  27.             <list-property name="privateDriverProperties">
  28.                 <ex-property>
  29.                     <name>contentBidiFormatStr</name>
  30.                     <value>ILYNN</value>
  31.                 </ex-property>
  32.                 <ex-property>
  33.                     <name>metadataBidiFormatStr</name>
  34.                     <value>ILYNN</value>
  35.                 </ex-property>
  36.             </list-property>
  37.             <property name="odaDriverClass">JDBC_DRIVER</property>
  38.             <property name="odaURL">jdbc:uri</property>
  39.             <property name="odaUser">user</property>
  40.             <encrypted-property name="odaPassword" encryptionID="base64">cGFzc3dvcmQ=</encrypted-property>
  41.         </oda-data-source>
  42.     </data-sources>
  43.     <data-sets>
  44.         <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Data Set" id="8">
  45.             <list-property name="columnHints">
  46.                 <structure>
  47.                     <property name="columnName">job</property>
  48.                     <text-property name="displayName">job</text-property>
  49.                 </structure>
  50.                 <structure>
  51.                     <property name="columnName">change</property>
  52.                     <text-property name="displayName">change</text-property>
  53.                 </structure>
  54.                 <structure>
  55.                     <property name="columnName">date</property>
  56.                     <text-property name="displayName">date</text-property>
  57.                 </structure>
  58.                 <structure>
  59.                     <property name="columnName">user</property>
  60.                     <text-property name="displayName">user</text-property>
  61.                 </structure>
  62.                 <structure>
  63.                     <property name="columnName">desc</property>
  64.                     <text-property name="displayName">desc</text-property>
  65.                 </structure>
  66.             </list-property>
  67.             <list-property name="parameters">
  68.                 <structure>
  69.                     <property name="name">since_date</property>
  70.                     <property name="paramName">since_param</property>
  71.                     <property name="dataType">string</property>
  72.                     <property name="position">1</property>
  73.                     <property name="isInput">true</property>
  74.                     <property name="isOutput">false</property>
  75.                 </structure>
  76.             </list-property>
  77.             <structure name="cachedMetaData">
  78.                 <list-property name="resultSet">
  79.                     <structure>
  80.                         <property name="position">1</property>
  81.                         <property name="name">job</property>
  82.                         <property name="dataType">string</property>
  83.                     </structure>
  84.                     <structure>
  85.                         <property name="position">2</property>
  86.                         <property name="name">change</property>
  87.                         <property name="dataType">integer</property>
  88.                     </structure>
  89.                     <structure>
  90.                         <property name="position">3</property>
  91.                         <property name="name">date</property>
  92.                         <property name="dataType">date-time</property>
  93.                     </structure>
  94.                     <structure>
  95.                         <property name="position">4</property>
  96.                         <property name="name">user</property>
  97.                         <property name="dataType">string</property>
  98.                     </structure>
  99.                     <structure>
  100.                         <property name="position">5</property>
  101.                         <property name="name">desc</property>
  102.                         <property name="dataType">string</property>
  103.                     </structure>
  104.                 </list-property>
  105.             </structure>
  106.             <property name="dataSource">Data Source</property>
  107.             <list-property name="resultSet">
  108.                 <structure>
  109.                     <property name="position">1</property>
  110.                     <property name="name">job</property>
  111.                     <property name="nativeName">job</property>
  112.                     <property name="dataType">string</property>
  113.                     <property name="nativeDataType">12</property>
  114.                 </structure>
  115.                 <structure>
  116.                     <property name="position">2</property>
  117.                     <property name="name">change</property>
  118.                     <property name="nativeName">change</property>
  119.                     <property name="dataType">integer</property>
  120.                     <property name="nativeDataType">4</property>
  121.                 </structure>
  122.                 <structure>
  123.                     <property name="position">3</property>
  124.                     <property name="name">date</property>
  125.                     <property name="nativeName">date</property>
  126.                     <property name="dataType">date-time</property>
  127.                     <property name="nativeDataType">93</property>
  128.                 </structure>
  129.                 <structure>
  130.                     <property name="position">4</property>
  131.                     <property name="name">user</property>
  132.                     <property name="nativeName">user</property>
  133.                     <property name="dataType">string</property>
  134.                     <property name="nativeDataType">12</property>
  135.                 </structure>
  136.                 <structure>
  137.                     <property name="position">5</property>
  138.                     <property name="name">desc</property>
  139.                     <property name="nativeName">desc</property>
  140.                     <property name="dataType">string</property>
  141.                     <property name="nativeDataType">12</property>
  142.                 </structure>
  143.             </list-property>
  144.             <xml-property name="queryText"><![CDATA[select f.job, c.change, c.date, c.user, c.desc
  145. from perforce.fix f, perforce.change c
  146. where f.change = c.change
  147. and f.date > ?
  148. order by f.job, c.change DESC;]]></xml-property>
  149.         </oda-data-set>
  150.     </data-sets>
  151.     <styles>
  152.         <style name="report" id="4">
  153.             <property name="fontFamily">sans-serif</property>
  154.             <property name="fontSize">10pt</property>
  155.         </style>
  156.         <style name="crosstab" id="5">
  157.             <property name="borderBottomColor">#CCCCCC</property>
  158.             <property name="borderBottomStyle">solid</property>
  159.             <property name="borderBottomWidth">1pt</property>
  160.             <property name="borderLeftColor">#CCCCCC</property>
  161.             <property name="borderLeftStyle">solid</property>
  162.             <property name="borderLeftWidth">1pt</property>
  163.             <property name="borderRightColor">#CCCCCC</property>
  164.             <property name="borderRightStyle">solid</property>
  165.             <property name="borderRightWidth">1pt</property>
  166.             <property name="borderTopColor">#CCCCCC</property>
  167.             <property name="borderTopStyle">solid</property>
  168.             <property name="borderTopWidth">1pt</property>
  169.         </style>
  170.         <style name="crosstab-cell" id="6">
  171.             <property name="borderBottomColor">#CCCCCC</property>
  172.             <property name="borderBottomStyle">solid</property>
  173.             <property name="borderBottomWidth">1pt</property>
  174.             <property name="borderLeftColor">#CCCCCC</property>
  175.             <property name="borderLeftStyle">solid</property>
  176.             <property name="borderLeftWidth">1pt</property>
  177.             <property name="borderRightColor">#CCCCCC</property>
  178.             <property name="borderRightStyle">solid</property>
  179.             <property name="borderRightWidth">1pt</property>
  180.             <property name="borderTopColor">#CCCCCC</property>
  181.             <property name="borderTopStyle">solid</property>
  182.             <property name="borderTopWidth">1pt</property>
  183.         </style>
  184.     </styles>
  185.     <page-setup>
  186.         <simple-master-page name="Simple MasterPage" id="2">
  187.             <page-footer>
  188.                 <text id="3">
  189.                     <property name="contentType">html</property>
  190.                     <text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
  191.                 </text>
  192.             </page-footer>
  193.         </simple-master-page>
  194.     </page-setup>
  195.     <body>
  196.         <text id="60">
  197.             <property name="contentType">html</property>
  198.             <text-property name="content"><![CDATA[<CENTER><B><span style="font-size: larger">
  199. Job Changes
  200. </B></span><BR>
  201. <FONT size="small">For internal use only</FONT><BR><BR>
  202. Report generated on <VALUE-OF>new Date( )</VALUE-OF>
  203. </CENTER><BR><BR>]]></text-property>
  204.         </text>
  205.         <table id="9">
  206.             <property name="width">7.930555555555555in</property>
  207.             <property name="dataSet">Data Set</property>
  208.             <list-property name="boundDataColumns">
  209.                 <structure>
  210.                     <property name="name">job</property>
  211.                     <expression name="expression">dataSetRow["job"]</expression>
  212.                     <property name="dataType">string</property>
  213.                 </structure>
  214.                 <structure>
  215.                     <property name="name">change</property>
  216.                     <expression name="expression">dataSetRow["change"]</expression>
  217.                     <property name="dataType">integer</property>
  218.                 </structure>
  219.                 <structure>
  220.                     <property name="name">date</property>
  221.                     <expression name="expression">dataSetRow["date"]</expression>
  222.                     <property name="dataType">date-time</property>
  223.                 </structure>
  224.                 <structure>
  225.                     <property name="name">user</property>
  226.                     <expression name="expression">dataSetRow["user"]</expression>
  227.                     <property name="dataType">string</property>
  228.                 </structure>
  229.                 <structure>
  230.                     <property name="name">desc</property>
  231.                     <expression name="expression">dataSetRow["desc"]</expression>
  232.                     <property name="dataType">string</property>
  233.                 </structure>
  234.             </list-property>
  235.             <column id="28">
  236.                 <property name="width">1.1388888888888888in</property>
  237.             </column>
  238.             <column id="29">
  239.                 <property name="width">1.1388888888888888in</property>
  240.             </column>
  241.             <column id="30">
  242.                 <property name="width">1.8333333333333333in</property>
  243.             </column>
  244.             <column id="31">
  245.                 <property name="width">1.2222222222222223in</property>
  246.             </column>
  247.             <column id="32">
  248.                 <property name="width">2.5972222222222223in</property>
  249.             </column>
  250.             <header>
  251.                 <row id="10">
  252.                     <cell id="11">
  253.                         <label id="33">
  254.                             <property name="backgroundColor">#529EB5</property>
  255.                             <property name="fontWeight">bold</property>
  256.                             <property name="textAlign">center</property>
  257.                             <text-property name="text">Job</text-property>
  258.                         </label>
  259.                     </cell>
  260.                     <cell id="12">
  261.                         <label id="37">
  262.                             <property name="backgroundColor">#529EB5</property>
  263.                             <property name="fontWeight">bold</property>
  264.                             <property name="textAlign">center</property>
  265.                             <text-property name="text">Change</text-property>
  266.                         </label>
  267.                     </cell>
  268.                     <cell id="13">
  269.                         <label id="39">
  270.                             <property name="backgroundColor">#529EB5</property>
  271.                             <property name="fontWeight">bold</property>
  272.                             <property name="textAlign">center</property>
  273.                             <text-property name="text">Change Date</text-property>
  274.                         </label>
  275.                     </cell>
  276.                     <cell id="14">
  277.                         <label id="42">
  278.                             <property name="backgroundColor">#529EB5</property>
  279.                             <property name="fontWeight">bold</property>
  280.                             <property name="textAlign">center</property>
  281.                             <text-property name="text">User</text-property>
  282.                         </label>
  283.                     </cell>
  284.                     <cell id="15">
  285.                         <label id="44">
  286.                             <property name="backgroundColor">#529EB5</property>
  287.                             <property name="fontWeight">bold</property>
  288.                             <property name="textAlign">center</property>
  289.                             <text-property name="text">Description</text-property>
  290.                         </label>
  291.                     </cell>
  292.                 </row>
  293.             </header>
  294.             <group id="46">
  295.                 <property name="groupName">job_group</property>
  296.                 <property name="interval">none</property>
  297.                 <property name="sortDirection">desc</property>
  298.                 <expression name="keyExpr" type="javascript">row["job"]</expression>
  299.                 <structure name="toc">
  300.                     <expression name="expressionValue" type="javascript">row["job"]</expression>
  301.                 </structure>
  302.                 <property name="repeatHeader">true</property>
  303.                 <property name="hideDetail">false</property>
  304.                 <property name="pageBreakAfter">auto</property>
  305.                 <property name="pageBreakBefore">auto</property>
  306.                 <property name="pageBreakInside">auto</property>
  307.                 <header>
  308.                     <row id="47">
  309.                         <cell id="48">
  310.                             <data id="59">
  311.                                 <property name="textAlign">center</property>
  312.                                 <property name="resultSetColumn">job</property>
  313.                             </data>
  314.                         </cell>
  315.                         <cell id="49"/>
  316.                         <cell id="50"/>
  317.                         <cell id="51"/>
  318.                         <cell id="52"/>
  319.                     </row>
  320.                 </header>
  321.                 <footer>
  322.                     <row id="53">
  323.                         <cell id="54"/>
  324.                         <cell id="55"/>
  325.                         <cell id="56"/>
  326.                         <cell id="57"/>
  327.                         <cell id="58"/>
  328.                     </row>
  329.                 </footer>
  330.             </group>
  331.             <detail>
  332.                 <row id="16">
  333.                     <cell id="17"/>
  334.                     <cell id="18">
  335.                         <data id="38">
  336.                             <property name="textAlign">center</property>
  337.                             <property name="resultSetColumn">change</property>
  338.                         </data>
  339.                     </cell>
  340.                     <cell id="19">
  341.                         <data id="40">
  342.                             <property name="paddingLeft">1pt</property>
  343.                             <property name="textAlign">center</property>
  344.                             <property name="resultSetColumn">date</property>
  345.                         </data>
  346.                     </cell>
  347.                     <cell id="20">
  348.                         <data id="43">
  349.                             <property name="textAlign">center</property>
  350.                             <property name="resultSetColumn">user</property>
  351.                         </data>
  352.                     </cell>
  353.                     <cell id="21">
  354.                         <data id="45">
  355.                             <property name="textAlign">left</property>
  356.                             <property name="resultSetColumn">desc</property>
  357.                         </data>
  358.                     </cell>
  359.                 </row>
  360.             </detail>
  361.             <footer>
  362.                 <row id="22">
  363.                     <cell id="23"/>
  364.                     <cell id="24"/>
  365.                     <cell id="25"/>
  366.                     <cell id="26"/>
  367.                     <cell id="27"/>
  368.                 </row>
  369.             </footer>
  370.         </table>
  371.     </body>
  372. </report>
# Change User Description Committed
#2 7760 jkovisto Added charts to some reports.
Minor formatting changes in others.
ModsPastWeek reworked... into something perhaps more useful. «		 15 years ago
#1 7575 jkovisto Initial revision for BIRT report examples 15 years ago