Loading...
Helix SwarmHelix Swarm
Loading...

ChangesByMonth.rptdesign

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