[Nmrshiftdb-devel] CVS: nmrshiftdb/src/reports monthly_report_1.jasper, NONE, 1.1 monthly_report_1.
Brought to you by:
steinbeck
Menu
▾
▴
[Nmrshiftdb-devel] CVS: nmrshiftdb/src/reports monthly_report_1.jasper, NONE, 1.1 monthly_report_1.jrxml, NONE, 1.1 monthly_report_2.jasper, NONE, 1.1 monthly_report_2.jrxml, NONE, 1.1 yearly_report_2.jasper, NONE, 1.1 yearly_report_2.jrxml, NONE, 1.1 yearly_report_1.jasper, 1.4, 1.5 yearly_report_1.jrxml, 1.4, 1.5
|
From: Stefan K. <sh...@us...> - 2006-11-24 13:48:48
|
Update of /cvsroot/nmrshiftdb/nmrshiftdb/src/reports In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv21503/src/reports Modified Files: yearly_report_1.jasper yearly_report_1.jrxml Added Files: monthly_report_1.jasper monthly_report_1.jrxml monthly_report_2.jasper monthly_report_2.jrxml yearly_report_2.jasper yearly_report_2.jrxml Log Message: more reports --- NEW FILE: monthly_report_1.jasper --- ¬í leftMarginB pageHeightI printOrderI backgroundt importsSett pageFooterq pageHeaderq sr leftBorderq reportFontq topPaddingq expressionq parameterst Z expressionq expressionq resetGroupq sq sr uq sq sq sq sr sq sq pq sq GROUP_FREQt nmrshiftdbxsr PAGE_COUNTpq sq ppppppppppppppppppppppppppppppppppppt pppppppppppppppppppppppppppppppppppp sq loadFactorI field_SELF field_49_D field_YEAR field_50_D field_NAME initParams initFields PAGE_COUNT Exceptions SourceFile *´ *´ °¹¼ÇÊÕØ ã æ#ñ$ô(ÿ)- .23 7)8,<7=:AEBHFSGVKaLdPoQrU}VZ[_`d§eªiµj¸nÃoÆsÑtÔxßyâ}í~ðûþ %(36AD O¡R¥]¦`ªk«n¯y°|´µ¹º¾£Æ *´ --- NEW FILE: monthly_report_1.jrxml --- <?xml version="1.0" encoding="UTF-8"?> <!-- Created using an evaluation version of JasperAssistant (http://www.jasperassistant.com) --> <!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="Unnamed" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="30" bottomMargin="30"> <property name="com.jasperassistant.designer.Grid" value="true"/> <property name="com.jasperassistant.designer.SnapToGrid" value="true"/> <property name="com.jasperassistant.designer.GridWidth" value="12"/> <property name="com.jasperassistant.designer.GridHeight" value="12"/> <property name="com.jasperassistant.designer.DataSource" value="nmrshiftdb"/> <parameter name="HEADER" class="java.lang.String"/> <queryString> <![CDATA[select YEAR(DATE) as YEAR, MONTH(DATE) as MONTH, AFFILIATION_1, AFFILIATION_2, MACHINE.NAME as NAME, count(*) as C, sum(WISHED_SPECTRUM like "%13C%" or WISHED_SPECTRUM like "%variable temperature%" or WISHED_SPECTRUM like "%ID sel. NOE%" or WISHED_SPECTRUM like "%solvent suppression%" or WISHED_SPECTRUM like "%standard spectrum%") as 1_D, sum(WISHED_SPECTRUM like "%H,H-COSY%" or WISHED_SPECTRUM like "%NOESY%" or WISHED_SPECTRUM like "%HMQC%" or WISHED_SPECTRUM like "%HMBC%") as 2_D, sum(OTHER_WISHED_SPECTRUM!="") as SPECIAL, sum(OTHER_NUCLEI!="") as HETERO, sum(PROCESS="self") as SELF, sum(PROCESS="robot") as ROBOT, sum(PROCESS="worker") as OPERATOR from (SAMPLE join TURBINE_USER using (USER_ID)) join MACHINE on MACHINE.MACHINE_ID=SAMPLE.MACHINE group by YEAR, MONTH, AFFILIATION_1, AFFILIATION_2, MACHINE.NAME;]]> </queryString> <field name="1_D" class="java.lang.Integer"/> <field name="2_D" class="java.lang.Long"/> <field name="AFFILIATION_2" class="java.lang.String"/> <field name="AFFILIATION_1" class="java.lang.String"/> <field name="HETERO" class="java.lang.Long"/> <field name="SPECIAL" class="java.lang.Long"/> <field name="NAME" class="java.lang.String"/> <field name="YEAR" class="java.lang.Long"/> <field name="C" class="java.lang.Integer"/> <field name="OPERATOR" class="java.lang.Integer"/> <field name="ROBOT" class="java.lang.Integer"/> <field name="SELF" class="java.lang.Integer"/> <field name="MONTH" class="java.lang.Integer"/> <variable name="GRP_AFFILIATION_2_Sum" class="java.lang.Integer" resetType="Group" resetGroup="GRP_AFFILIATION_2" calculation="Sum"> <variableExpression><![CDATA[$F{C}]]></variableExpression> </variable> <variable name="GRP_AFFILIATION_1_Sum" class="java.lang.Integer" resetType="Group" resetGroup="GRP_AFFILIATION_1" calculation="Sum"> <variableExpression><![CDATA[$F{C}]]></variableExpression> </variable> <variable name="GRP_YEAR_Sum" class="java.lang.Integer" resetType="Group" resetGroup="GRP_YEAR" calculation="Sum"> <variableExpression><![CDATA[$F{C}]]></variableExpression> </variable> <variable name="TOTAL_Sum" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[$F{C}]]></variableExpression> </variable> <variable name="GRP_MONTH_Sum" class="java.lang.Integer" resetType="Group" resetGroup="GRP_MONTH" calculation="Sum"> <variableExpression><![CDATA[$F{C}]]></variableExpression> </variable> <group name="GRP_YEAR"> <groupExpression><![CDATA[$F{YEAR}]]></groupExpression> <groupHeader> <band height="34"> <line> <reportElement x="3" y="0" width="550" height="2"/> <graphicElement pen="4Point"/> </line> <textField> <reportElement x="24" y="12" width="80" height="20"/> <textElement textAlignment="Left"/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{YEAR}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="12" width="23" height="20"/> <textElement/> <text><![CDATA[Year]]></text> </staticText> </band> </groupHeader> <groupFooter> <band height="25"> <textField> <reportElement x="144" y="0" width="80" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{GRP_YEAR_Sum}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="0" width="88" height="20"/> <textElement/> <text><![CDATA[Measurements in]]></text> </staticText> <textField> <reportElement x="96" y="0" width="37" height="20"/> <textElement textAlignment="Left"/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{YEAR}]]></textFieldExpression> </textField> <staticText> <reportElement x="132" y="0" width="13" height="25"/> <textElement/> <text><![CDATA[:]]></text> </staticText> </band> </groupFooter> </group> <group name="GRP_MONTH"> <groupExpression><![CDATA[$F{MONTH}]]></groupExpression> <groupHeader> <band height="22"> <staticText> <reportElement x="60" y="0" width="37" height="20"/> <textElement/> <text><![CDATA[Month:]]></text> </staticText> <textField> <reportElement x="96" y="0" width="80" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{MONTH}]]></textFieldExpression> </textField> </band> </groupHeader> <groupFooter> <band height="28"> <staticText> <reportElement x="60" y="0" width="88" height="20"/> <textElement/> <text><![CDATA[Measurements in]]></text> </staticText> <textField> <reportElement x="180" y="0" width="37" height="20"/> <textElement textAlignment="Left"/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{YEAR}]]></textFieldExpression> </textField> <staticText> <reportElement x="216" y="0" width="13" height="25"/> <textElement/> <text><![CDATA[:]]></text> </staticText> <textField> <reportElement x="228" y="0" width="80" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{GRP_MONTH_Sum}]]></textFieldExpression> </textField> <textField> <reportElement x="156" y="0" width="13" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{MONTH}]]></textFieldExpression> </textField> <staticText> <reportElement x="168" y="0" width="13" height="20"/> <textElement/> <text><![CDATA[/]]></text> </staticText> </band> </groupFooter> </group> <group name="GRP_AFFILIATION_1"> <groupExpression><![CDATA[$F{AFFILIATION_1}]]></groupExpression> <groupHeader> <band height="36"> <rectangle> <reportElement x="117" y="1" width="436" height="34" backcolor="#E5E5E5"/> <graphicElement pen="None"/> </rectangle> <textField> <reportElement x="120" y="12" width="330" height="22"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{AFFILIATION_1}]]></textFieldExpression> </textField> </band> </groupHeader> <groupFooter> <band height="31"> <textField> <reportElement x="117" y="11" width="80" height="13"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{GRP_AFFILIATION_1_Sum}]]></textFieldExpression> </textField> <staticText> <reportElement x="117" y="-1" width="86" height="15"/> <textElement/> <text><![CDATA[Measurements of]]></text> </staticText> <textField> <reportElement x="213" y="-1" width="330" height="14"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{AFFILIATION_1}]]></textFieldExpression> </textField> </band> </groupFooter> </group> <group name="GRP_AFFILIATION_2"> <groupExpression><![CDATA[$F{AFFILIATION_2}]]></groupExpression> <groupHeader> <band height="32"> <textField> <reportElement x="120" y="10" width="330" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{AFFILIATION_2}]]></textFieldExpression> </textField> </band> </groupHeader> <groupFooter> <band height="56"> <textField> <reportElement x="117" y="23" width="80" height="14"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{GRP_AFFILIATION_2_Sum}]]></textFieldExpression> </textField> <textField> <reportElement x="213" y="11" width="330" height="14"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{AFFILIATION_2}]]></textFieldExpression> </textField> <staticText> <reportElement x="117" y="11" width="86" height="15"/> <textElement/> <text><![CDATA[Measurements of]]></text> </staticText> <line> <reportElement x="117" y="48" width="436" height="1"/> <graphicElement pen="4Point"/> </line> </band> </groupFooter> </group> <group name="GROUP_FREQ"> <groupExpression><![CDATA[$F{NAME}]]></groupExpression> <groupHeader> <band height="73"> <textField> <reportElement x="228" y="0" width="85" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{NAME}]]></textFieldExpression> </textField> <staticText> <reportElement x="180" y="0" width="43" height="20"/> <textElement/> <text><![CDATA[Machine:]]></text> </staticText> <staticText> <reportElement x="180" y="24" width="19" height="20"/> <textElement/> <text><![CDATA[1D:]]></text> </staticText> <textField> <reportElement x="204" y="24" width="25" height="18"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{1_D}]]></textFieldExpression> </textField> <staticText> <reportElement x="252" y="24" width="18" height="20"/> <textElement/> <text><![CDATA[2D:]]></text> </staticText> <textField> <reportElement x="276" y="24" width="25" height="20"/> <textElement/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{2_D}]]></textFieldExpression> </textField> <staticText> <reportElement x="324" y="24" width="40" height="20"/> <textElement/> <text><![CDATA[Special:]]></text> </staticText> <textField> <reportElement x="372" y="24" width="25" height="20"/> <textElement/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{SPECIAL}]]></textFieldExpression> </textField> <staticText> <reportElement x="420" y="24" width="37" height="20"/> <textElement/> <text><![CDATA[Hetero:]]></text> </staticText> <textField> <reportElement x="468" y="24" width="25" height="20"/> <textElement/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{HETERO}]]></textFieldExpression> </textField> <line> <reportElement x="177" y="0" width="376" height="1"/> <graphicElement/> </line> <staticText> <reportElement x="180" y="48" width="157" height="20"/> <textElement/> <text><![CDATA[Measurement mode: Operator]]></text> </staticText> <textField> <reportElement x="336" y="48" width="13" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{OPERATOR}]]></textFieldExpression> </textField> <staticText> <reportElement x="348" y="48" width="97" height="20"/> <textElement/> <text><![CDATA[ , sample changer]]></text> </staticText> <textField> <reportElement x="444" y="48" width="13" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{ROBOT}]]></textFieldExpression> </textField> <staticText> <reportElement x="456" y="48" width="37" height="20"/> <textElement/> <text><![CDATA[ , self]]></text> </staticText> <textField> <reportElement x="492" y="48" width="25" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{SELF}]]></textFieldExpression> </textField> </band> </groupHeader> <groupFooter> <band height="33"> <textField> <reportElement x="177" y="11" width="80" height="13"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{C}]]></textFieldExpression> </textField> <staticText> <reportElement x="177" y="-1" width="320" height="13"/> <textElement/> <text><![CDATA[Measurements with this machine:]]></text> </staticText> </band> </groupFooter> </group> <pageHeader> <band height="23"> <rectangle> <reportElement x="1" y="0" width="555" height="23" backcolor="#BFBFBF"/> <graphicElement pen="None"/> </rectangle> <textField> <reportElement x="1" y="1" width="416" height="20"/> <textElement> <font size="16" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{HEADER}]]></textFieldExpression> </textField> </band> </pageHeader> <pageFooter> <band height="22"> <staticText> <reportElement x="276" y="0" width="25" height="19"/> <textElement/> <text><![CDATA[Page]]></text> </staticText> <textField> <reportElement x="300" y="0" width="80" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> </textField> </band> </pageFooter> <lastPageFooter> <band height="26"> <staticText> <reportElement x="0" y="0" width="93" height="20"/> <textElement/> <text><![CDATA[All measurements:]]></text> </staticText> <textField> <reportElement x="96" y="0" width="80" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{TOTAL_Sum}]]></textFieldExpression> </textField> </band> </lastPageFooter> </jasperReport> --- NEW FILE: monthly_report_2.jasper --- ¬í leftMarginB pageHeightI printOrderI backgroundt importsSett pageFooterq pageHeaderq sr leftBorderq reportFontq topPaddingq expressionq parameterst Z expressionq expressionq resetGroupq sq sr uq sq sq sq GROUP_FREQt nmrshiftdbxsr PAGE_COUNTpq sq sr loadFactorI field_YEAR field_50_D field_SELF field_NAME field_49_D initParams initFields PAGE_COUNT Exceptions SourceFile *´ # &$1%4)?*B.M/P3[4^8i9l=w>zB CGHL¡M¤Q¯Y *´ ïðô#õ&ù1ú4þ?ÿBMP[ ^ ilwz !¡"¤&¯. *´ ÄÅÉ#Ê&Î1Ï4Ó?ÔBØMÙPÝ[Þ^âiãlçwèzì íñòö¡÷¤û¯ --- NEW FILE: monthly_report_2.jrxml --- <?xml version="1.0" encoding="UTF-8"?> <!-- Created using an evaluation version of JasperAssistant (http://www.jasperassistant.com) --> <!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="Unnamed" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="30" bottomMargin="30"> <property name="com.jasperassistant.designer.Grid" value="true"/> <property name="com.jasperassistant.designer.SnapToGrid" value="true"/> <property name="com.jasperassistant.designer.GridWidth" value="12"/> <property name="com.jasperassistant.designer.GridHeight" value="12"/> <property name="com.jasperassistant.designer.DataSource" value="nmrshiftdb"/> <parameter name="HEADER" class="java.lang.String"/> <queryString> <![CDATA[select YEAR(DATE) as YEAR, MONTH(DATE) as MONTH, MACHINE.NAME as NAME, count(*) as C, sum(WISHED_SPECTRUM like "%13C%" or WISHED_SPECTRUM like "%variable temperature%" or WISHED_SPECTRUM like "%ID sel. NOE%" or WISHED_SPECTRUM like "%solvent suppression%" or WISHED_SPECTRUM like "%standard spectrum%") as 1_D, sum(WISHED_SPECTRUM like "%H,H-COSY%" or WISHED_SPECTRUM like "%NOESY%" or WISHED_SPECTRUM like "%HMQC%" or WISHED_SPECTRUM like "%HMBC%") as 2_D, sum(OTHER_WISHED_SPECTRUM!="") as SPECIAL, sum(OTHER_NUCLEI!="") as HETERO, sum(PROCESS="self") as SELF, sum(PROCESS="robot") as ROBOT, sum(PROCESS="worker") as OPERATOR from (SAMPLE join TURBINE_USER using (USER_ID)) join MACHINE on MACHINE.MACHINE_ID=SAMPLE.MACHINE group by YEAR, MONTH, MACHINE.NAME;]]> </queryString> <field name="1_D" class="java.lang.Integer"/> <field name="2_D" class="java.lang.Long"/> <field name="HETERO" class="java.lang.Long"/> <field name="SPECIAL" class="java.lang.Long"/> <field name="NAME" class="java.lang.String"/> <field name="YEAR" class="java.lang.Long"/> <field name="C" class="java.lang.Integer"/> <field name="OPERATOR" class="java.lang.Integer"/> <field name="SELF" class="java.lang.Integer"/> <field name="ROBOT" class="java.lang.Integer"/> <field name="MONTH" class="java.lang.Integer"/> <variable name="GRP_YEAR_Sum" class="java.lang.Integer" resetType="Group" resetGroup="GRP_YEAR" calculation="Sum"> <variableExpression><![CDATA[$F{C}]]></variableExpression> </variable> <variable name="TOTAL_Sum" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[$F{C}]]></variableExpression> </variable> <variable name="GRP_MONTH_Sum" class="java.lang.Integer" resetType="Group" resetGroup="GRP_MONTH" calculation="Sum"> <variableExpression><![CDATA[$F{C}]]></variableExpression> </variable> <group name="GRP_YEAR"> <groupExpression><![CDATA[$F{YEAR}]]></groupExpression> <groupHeader> <band height="34"> <line> <reportElement x="3" y="0" width="550" height="2"/> <graphicElement pen="4Point"/> </line> <textField> <reportElement x="24" y="12" width="80" height="20"/> <textElement textAlignment="Left"/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{YEAR}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="12" width="23" height="20"/> <textElement/> <text><![CDATA[Year]]></text> </staticText> </band> </groupHeader> <groupFooter> <band height="25"> <textField> <reportElement x="144" y="0" width="80" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{GRP_YEAR_Sum}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="0" width="88" height="20"/> <textElement/> <text><![CDATA[Measurements in]]></text> </staticText> <textField> <reportElement x="96" y="0" width="37" height="20"/> <textElement textAlignment="Left"/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{YEAR}]]></textFieldExpression> </textField> <staticText> <reportElement x="132" y="0" width="13" height="25"/> <textElement/> <text><![CDATA[:]]></text> </staticText> </band> </groupFooter> </group> <group name="GRP_MONTH"> <groupExpression><![CDATA[$F{MONTH}]]></groupExpression> <groupHeader> <band height="26"> <textField> <reportElement x="96" y="0" width="80" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{MONTH}]]></textFieldExpression> </textField> <staticText> <reportElement x="60" y="0" width="37" height="20"/> <textElement/> <text><![CDATA[Month:]]></text> </staticText> </band> </groupHeader> <groupFooter> <band height="31"> <textField> <reportElement x="228" y="0" width="80" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{GRP_MONTH_Sum}]]></textFieldExpression> </textField> <staticText> <reportElement x="60" y="0" width="88" height="20"/> <textElement/> <text><![CDATA[Measurements in]]></text> </staticText> <textField> <reportElement x="180" y="0" width="37" height="20"/> <textElement textAlignment="Left"/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{YEAR}]]></textFieldExpression> </textField> <staticText> <reportElement x="168" y="0" width="13" height="20"/> <textElement/> <text><![CDATA[/]]></text> </staticText> <textField> <reportElement x="156" y="0" width="13" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{MONTH}]]></textFieldExpression> </textField> <line> <reportElement x="60" y="24" width="493" height="2"/> <graphicElement pen="4Point"/> </line> </band> </groupFooter> </group> <group name="GROUP_FREQ"> <groupExpression><![CDATA[$F{NAME}]]></groupExpression> <groupHeader> <band height="73"> <textField> <reportElement x="228" y="0" width="85" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{NAME}]]></textFieldExpression> </textField> <staticText> <reportElement x="120" y="0" width="109" height="20"/> <textElement/> <text><![CDATA[Machine:]]></text> </staticText> <staticText> <reportElement x="120" y="24" width="19" height="20"/> <textElement/> <text><![CDATA[1D:]]></text> </staticText> <textField> <reportElement x="144" y="24" width="25" height="18"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{1_D}]]></textFieldExpression> </textField> <staticText> <reportElement x="192" y="24" width="18" height="20"/> <textElement/> <text><![CDATA[2D:]]></text> </staticText> <textField> <reportElement x="216" y="24" width="25" height="20"/> <textElement/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{2_D}]]></textFieldExpression> </textField> <staticText> <reportElement x="264" y="24" width="40" height="20"/> <textElement/> <text><![CDATA[Special:]]></text> </staticText> <textField> <reportElement x="312" y="24" width="25" height="20"/> <textElement/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{SPECIAL}]]></textFieldExpression> </textField> <staticText> <reportElement x="360" y="24" width="37" height="20"/> <textElement/> <text><![CDATA[Hetero:]]></text> </staticText> <textField> <reportElement x="408" y="24" width="25" height="20"/> <textElement/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{HETERO}]]></textFieldExpression> </textField> <line> <reportElement x="120" y="0" width="435" height="1"/> <graphicElement/> </line> <textField> <reportElement x="432" y="48" width="25" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{SELF}]]></textFieldExpression> </textField> <staticText> <reportElement x="288" y="48" width="97" height="20"/> <textElement/> <text><![CDATA[ , sample changer]]></text> </staticText> <staticText> <reportElement x="120" y="48" width="157" height="20"/> <textElement/> <text><![CDATA[Measurement mode: Operator]]></text> </staticText> <staticText> <reportElement x="396" y="48" width="37" height="20"/> <textElement/> <text><![CDATA[ , self]]></text> </staticText> <textField> <reportElement x="276" y="48" width="13" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{OPERATOR}]]></textFieldExpression> </textField> <textField> <reportElement x="384" y="48" width="13" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{ROBOT}]]></textFieldExpression> </textField> </band> </groupHeader> <groupFooter> <band height="33"> <textField> <reportElement x="120" y="12" width="80" height="13"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{C}]]></textFieldExpression> </textField> <staticText> <reportElement x="120" y="0" width="320" height="13"/> <textElement/> <text><![CDATA[Measurements in this mode:]]></text> </staticText> </band> </groupFooter> </group> <pageHeader> <band height="23"> <rectangle> <reportElement x="1" y="0" width="555" height="23" backcolor="#BFBFBF"/> <graphicElement pen="None"/> </rectangle> <textField> <reportElement x="1" y="1" width="416" height="20"/> <textElement> <font size="16" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{HEADER}]]></textFieldExpression> </textField> </band> </pageHeader> <pageFooter> <band height="22"> <staticText> <reportElement x="276" y="0" width="25" height="19"/> <textElement/> <text><![CDATA[Page]]></text> </staticText> <textField> <reportElement x="300" y="0" width="80" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> </textField> </band> </pageFooter> <lastPageFooter> <band height="26"> <staticText> <reportElement x="0" y="0" width="93" height="20"/> <textElement/> <text><![CDATA[All measurements:]]></text> </staticText> <textField> <reportElement x="96" y="0" width="80" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{TOTAL_Sum}]]></textFieldExpression> </textField> </band> </lastPageFooter> </jasperReport> --- NEW FILE: yearly_report_2.jasper --- ¬í leftMarginB pageHeightI printOrderI backgroundt importsSett pageFooterq pageHeaderq sr leftBorderq reportFontq topPaddingq expressionq parameterst sr Z expressionq expressionq resetGroupq sq sr uq sq GROUP_FREQt nmrshiftdbxsr PAGE_COUNTpq sq sr loadFactorI field_YEAR field_50_D field_SELF field_NAME field_49_D initParams initFields PAGE_COUNT Exceptions SourceFile *´ Ý àëîùü ##+ *´ ËÌÐ#Ø *´ xy}# --- NEW FILE: yearly_report_2.jrxml --- <?xml version="1.0" encoding="UTF-8"?> <!-- Created using an evaluation version of JasperAssistant (http://www.jasperassistant.com) --> <!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="Unnamed" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="30" bottomMargin="30"> <property name="com.jasperassistant.designer.Grid" value="true"/> <property name="com.jasperassistant.designer.SnapToGrid" value="true"/> <property name="com.jasperassistant.designer.GridWidth" value="12"/> <property name="com.jasperassistant.designer.GridHeight" value="12"/> <property name="com.jasperassistant.designer.DataSource" value="nmrshiftdb"/> <parameter name="HEADER" class="java.lang.String"/> <queryString> <![CDATA[select YEAR(DATE) as YEAR, MACHINE.NAME as NAME, count(*) as C, sum(WISHED_SPECTRUM like "%13C%" or WISHED_SPECTRUM like "%variable temperature%" or WISHED_SPECTRUM like "%ID sel. NOE%" or WISHED_SPECTRUM like "%solvent suppression%" or WISHED_SPECTRUM like "%standard spectrum%") as 1_D, sum(WISHED_SPECTRUM like "%H,H-COSY%" or WISHED_SPECTRUM like "%NOESY%" or WISHED_SPECTRUM like "%HMQC%" or WISHED_SPECTRUM like "%HMBC%") as 2_D, sum(OTHER_WISHED_SPECTRUM!="") as SPECIAL, sum(OTHER_NUCLEI!="") as HETERO, sum(PROCESS="self") as SELF, sum(PROCESS="robot") as ROBOT, sum(PROCESS="worker") as OPERATOR from (SAMPLE join TURBINE_USER using (USER_ID)) join MACHINE on MACHINE.MACHINE_ID=SAMPLE.MACHINE group by YEAR, MACHINE.NAME;]]> </queryString> <field name="1_D" class="java.lang.Integer"/> <field name="2_D" class="java.lang.Long"/> <field name="HETERO" class="java.lang.Long"/> <field name="SPECIAL" class="java.lang.Long"/> <field name="NAME" class="java.lang.String"/> <field name="YEAR" class="java.lang.Long"/> <field name="C" class="java.lang.Integer"/> <field name="OPERATOR" class="java.lang.Integer"/> <field name="SELF" class="java.lang.Integer"/> <field name="ROBOT" class="java.lang.Integer"/> <variable name="GRP_YEAR_Sum" class="java.lang.Integer" resetType="Group" resetGroup="GRP_YEAR" calculation="Sum"> <variableExpression><![CDATA[$F{C}]]></variableExpression> </variable> <variable name="TOTAL_Sum" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[$F{C}]]></variableExpression> </variable> <group name="GRP_YEAR"> <groupExpression><![CDATA[$F{YEAR}]]></groupExpression> <groupHeader> <band height="34"> <line> <reportElement x="3" y="0" width="550" height="2"/> <graphicElement pen="4Point"/> </line> <textField> <reportElement x="24" y="12" width="80" height="20"/> <textElement textAlignment="Left"/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{YEAR}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="12" width="23" height="20"/> <textElement/> <text><![CDATA[Year]]></text> </staticText> </band> </groupHeader> <groupFooter> <band height="25"> <textField> <reportElement x="144" y="0" width="80" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{GRP_YEAR_Sum}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="0" width="88" height="20"/> <textElement/> <text><![CDATA[Measurements in]]></text> </staticText> <textField> <reportElement x="96" y="0" width="37" height="20"/> <textElement textAlignment="Left"/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{YEAR}]]></textFieldExpression> </textField> <staticText> <reportElement x="132" y="0" width="13" height="25"/> <textElement/> <text><![CDATA[:]]></text> </staticText> </band> </groupFooter> </group> <group name="GROUP_FREQ"> <groupExpression><![CDATA[$F{NAME}]]></groupExpression> <groupHeader> <band height="73"> <textField> <reportElement x="228" y="0" width="85" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{NAME}]]></textFieldExpression> </textField> <staticText> <reportElement x="120" y="0" width="109" height="20"/> <textElement/> <text><![CDATA[Machine:]]></text> </staticText> <staticText> <reportElement x="120" y="24" width="19" height="20"/> <textElement/> <text><![CDATA[1D:]]></text> </staticText> <textField> <reportElement x="144" y="24" width="25" height="18"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{1_D}]]></textFieldExpression> </textField> <staticText> <reportElement x="192" y="24" width="18" height="20"/> <textElement/> <text><![CDATA[2D:]]></text> </staticText> <textField> <reportElement x="216" y="24" width="25" height="20"/> <textElement/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{2_D}]]></textFieldExpression> </textField> <staticText> <reportElement x="264" y="24" width="40" height="20"/> <textElement/> <text><![CDATA[Special:]]></text> </staticText> <textField> <reportElement x="312" y="24" width="25" height="20"/> <textElement/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{SPECIAL}]]></textFieldExpression> </textField> <staticText> <reportElement x="360" y="24" width="37" height="20"/> <textElement/> <text><![CDATA[Hetero:]]></text> </staticText> <textField> <reportElement x="408" y="24" width="25" height="20"/> <textElement/> <textFieldExpression class="java.lang.Long"><![CDATA[$F{HETERO}]]></textFieldExpression> </textField> <line> <reportElement x="120" y="0" width="435" height="1"/> <graphicElement/> </line> <textField> <reportElement x="432" y="48" width="25" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{SELF}]]></textFieldExpression> </textField> <staticText> <reportElement x="288" y="48" width="97" height="20"/> <textElement/> <text><![CDATA[ , sample changer]]></text> </staticText> <staticText> <reportElement x="120" y="48" width="157" height="20"/> <textElement/> <text><![CDATA[Measurement mode: Operator]]></text> </staticText> <staticText> <reportElement x="396" y="48" width="37" height="20"/> <textElement/> <text><![CDATA[ , self]]></text> </staticText> <textField> <reportElement x="276" y="48" width="13" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{OPERATOR}]]></textFieldExpression> </textField> <textField> <reportElement x="384" y="48" width="13" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{ROBOT}]]></textFieldExpression> </textField> </band> </groupHeader> <groupFooter> <band height="33"> <textField> <reportElement x="120" y="12" width="80" height="13"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{C}]]></textFieldExpression> </textField> <staticText> <reportElement x="120" y="0" width="320" height="13"/> <textElement/> <text><![CDATA[Measurements in this mode:]]></text> </staticText> </band> </groupFooter> </group> <pageHeader> <band height="23"> <rectangle> <reportElement x="1" y="0" width="555" height="23" backcolor="#BFBFBF"/> <graphicElement pen="None"/> </rectangle> <textField> <reportElement x="1" y="1" width="416" height="20"/> <textElement> <font size="16" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{HEADER}]]></textFieldExpression> </textField> </band> </pageHeader> <pageFooter> <band height="22"> <staticText> <reportElement x="276" y="0" width="25" height="19"/> <textElement/> <text><![CDATA[Page]]></text> </staticText> <textField> <reportElement x="300" y="0" width="80" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> </textField> </band> </pageFooter> <lastPageFooter> <band height="26"> <staticText> <reportElement x="0" y="0" width="93" height="20"/> <textElement/> <text><![CDATA[All measurements:]]></text> </staticText> <textField> <reportElement x="96" y="0" width="80" height="20"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{TOTAL_Sum}]]></textFieldExpression> </textField> </band> </lastPageFooter> </jasperReport> Index: yearly_report_1.jasper =================================================================== RCS file: /cvsroot/nmrshiftdb/nmrshiftdb/src/reports/yearly_report_1.jasper,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -r1.4 -r1.5 Binary files /tmp/cvsHXLmME and /tmp/cvsdUlJyg differ Index: yearly_report_1.jrxml =================================================================== RCS file: /cvsroot/nmrshiftdb/nmrshiftdb/src/reports/yearly_report_1.jrxml,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -r1.4 -r1.5 *** yearly_report_1.jrxml 24 Nov 2006 09:20:40 -0000 1.4 --- yearly_report_1.jrxml 24 Nov 2006 13:48:44 -0000 1.5 *************** *** 11,15 **** <parameter name="HEADER" class="java.lang.String"/> <queryString> ! <![CDATA[select YEAR(DATE) as YEAR, AFFILIATION_1, AFFILIATION_2, MACHINE.NAME as NAME, count(*) as C, sum(WISHED_SPECTRUM like "%13C%" or WISHED_SPECTRUM like "%variable temperature%" or WISHED_SPECTRUM like "%ID sel. NOE%" or WISHED_SPECTRUM like "%solvent suppression%" or WISHED_SPECTRUM like "%standard spectrum%") as 1_D, sum(WISHED_SPECTRUM like "%H,H-COSY%" or WISHED_SPECTRUM like "%NOESY%" or WISHED_SPECTRUM like "%HMQC%" or WISHED_SPECTRUM like "%HMBC%") as 2_D, sum(OTHER_WISHED_SPECTRUM!="") as SPECIAL, sum(OTHER_NUCLEI!="") as HETERO from (SAMPLE join TURBINE_USER using (USER_ID)) join MACHINE on MACHINE.MACHINE_ID=SAMPLE.MACHINE group by YEAR, AFFILIATION_1, AFFILIATION_2, MACHINE.NAME;]]> </queryString> <field name="1_D" class="java.lang.Integer"/> --- 11,15 ---- <parameter name="HEADER" class="java.lang.String"/> <queryString> ! <![CDATA[select YEAR(DATE) as YEAR, AFFILIATION_1, AFFILIATION_2, MACHINE.NAME as NAME, count(*) as C, sum(WISHED_SPECTRUM like "%13C%" or WISHED_SPECTRUM like "%variable temperature%" or WISHED_SPECTRUM like "%ID sel. NOE%" or WISHED_SPECTRUM like "%solvent suppression%" or WISHED_SPECTRUM like "%standard spectrum%") as 1_D, sum(WISHED_SPECTRUM like "%H,H-COSY%" or WISHED_SPECTRUM like "%NOESY%" or WISHED_SPECTRUM like "%HMQC%" or WISHED_SPECTRUM like "%HMBC%") as 2_D, sum(OTHER_WISHED_SPECTRUM!="") as SPECIAL, sum(OTHER_NUCLEI!="") as HETERO, sum(PROCESS="self") as SELF, sum(PROCESS="robot") as ROBOT, sum(PROCESS="worker") as OPERATOR from (SAMPLE join TURBINE_USER using (USER_ID)) join MACHINE on MACHINE.MACHINE_ID=SAMPLE.MACHINE group by YEAR, AFFILIATION_1, AFFILIATION_2, MACHINE.NAME;]]> </queryString> <field name="1_D" class="java.lang.Integer"/> *************** *** 22,25 **** --- 22,28 ---- <field name="YEAR" class="java.lang.Long"/> <field name="C" class="java.lang.Integer"/> + <field name="OPERATOR" class="java.lang.Integer"/> + <field name="ROBOT" class="java.lang.Integer"/> + <field name="SELF" class="java.lang.Integer"/> <variable name="GRP_AFFILIATION_2_Sum" class="java.lang.Integer" resetType="Group" resetGroup="GRP_AFFILIATION_2" calculation="Sum"> <variableExpression><![CDATA[$F{C}]]></variableExpression> *************** *** 152,156 **** <groupExpression><![CDATA[$F{NAME}]]></groupExpression> <groupHeader> ! <band height="51"> <textField> <reportElement x="168" y="0" width="85" height="20"/> --- 155,159 ---- <groupExpression><![CDATA[$F{NAME}]]></groupExpression> <groupHeader> ! <band height="73"> <textField> <reportElement x="168" y="0" width="85" height="20"/> *************** *** 207,210 **** --- 210,243 ---- <graphicElement/> </line> + <staticText> + <reportElement x="120" y="48" width="157" height="20"/> + <textElement/> + <text><![CDATA[Measurement mode: Operator]]></text> + </staticText> + <textField> + <reportElement x="276" y="48" width="13" height="20"/> + <textElement/> + <textFieldExpression class="java.lang.Integer"><![CDATA[$F{OPERATOR}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="288" y="48" width="97" height="20"/> + <textElement/> + <text><![CDATA[ , sample changer]]></text> + </staticText> + <textField> + <reportElement x="384" y="48" width="13" height="20"/> + <textElement/> + <textFieldExpression class="java.lang.Integer"><![CDATA[$F{ROBOT}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="396" y="48" width="37" height="20"/> + <textElement/> + <text><![CDATA[ , self]]></text> + </staticText> + <textField> + <reportElement x="432" y="48" width="25" height="20"/> + <textElement/> + <textFieldExpression class="java.lang.Integer"><![CDATA[$F{SELF}]]></textFieldExpression> + </textField> </band> </groupHeader> |
