insert a jasper report ,upload a jrxml file,execute then get xml error

gpanzl · April 20, 2015, 7:09am

hello
please help me , i install ,and all worked ,but insert a jasper report ,upload a jrxml file,execute then get xml error. but check xml file , at “lineNumber: 109; columnNumber: 56;” cant find error ,there is no a text mark.

error code:

Error: An error occured during report execution.
The report could not be executed: Could not execute report: org.xml.sax.SAXParseException; lineNumber: 109; columnNumber: 56; The end-tag for element type “text” must end with a ‘>’ delimiter.
To get help please contact an administrator.
Details
net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: Could not execute report: org.xml.sax.SAXParseException; lineNumber: 109; columnNumber: 56; The end-tag for element type “text” must end with a ‘>’ delimiter. at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:218) at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:119) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exeucteReport(ReportExportServlet.java:527) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doExportReport(ReportExportServlet.java:407) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReport(ReportExportServlet.java:333) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReportViaSession(ReportExportServlet.java:326) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doGet(ReportExportServlet.java:164) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$53043ab4.CGLIB$doGet$2() at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$53043ab4$$FastClassByGuice$$dc3d2be3.invoke() at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:66) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$53043ab4.doGet() at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$53043ab4.CGLIB$service$17() at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$53043ab4$$FastClassByGuice$$dc3d2be3.invoke() at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:110) at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) at net.datenwerke.rs.core.server.reportexport.ReportExportServlet$$EnhancerByGuice$$53043ab4.service() at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263) at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178) at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62) at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89) at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163) at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118) at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.IllegalArgumentException: Could not execute report: org.xml.sax.SAXParseException; lineNumber: 109; columnNumber: 56; The end-tag for element type “text” must end with a ‘>’ delimiter. at net.datenwerke.rs.base.service.reportengines.jasper.JasperReportEngine.executeReport(JasperReportEngine.java:309) at net.datenwerke.rs.base.service.reportengines.jasper.JasperReportEngine.doExecute(JasperReportEngine.java:117) at net.datenwerke.rs.core.service.reportmanager.engine.ReportEngine.execute(ReportEngine.java:127) at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:186) … 50 more Caused by: net.sf.jasperreports.engine.JRException: org.xml.sax.SAXParseException; lineNumber: 109; columnNumber: 56; The end-tag for element type “text” must end with a ‘>’ delimiter. at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:300) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:283) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:272) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:246) at net.datenwerke.rs.base.service.reportengines.jasper.JasperReportEngine.executeReport(JasperReportEngine.java:155) … 53 more Caused by: org.xml.sax.SAXParseException; lineNumber: 109; columnNumber: 56; The end-tag for element type “text” must end with a ‘>’ delimiter. at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source) at org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source) at org.apache.xerces.impl.XMLScanner.reportFatalError(Unknown Source) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at org.apache.commons.digester.Digester.parse(Digester.java:1892) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:296) … 57 more

jrxml file:

<?xml version="1.0" encoding="UTF-8"?>

		</staticText>
		<textField pattern="yyy-M-d">
			<reportElement x="98" y="94" width="100" height="26" uuid="efef9fc3-4f9b-483a-9eba-e607c2234b9a"/>
			<textFieldExpression><![CDATA[$P{dateWeek}]]></textFieldExpression>
		</textField>
		<textField>
			<reportElement x="1" y="94" width="85" height="30" uuid="130f8657-fb55-43e5-9c41-a50ffa5b5082"/>
			<textFieldExpression><![CDATA[CONCATENATE("第",WEEKNUM($P{dateWeek}).toString(),"周")]]></textFieldExpression>
		</textField>
	</band>
</title>
<pageFooter>
	<band height="25" splitType="Stretch">
		<frame>
			<reportElement mode="Opaque" x="-21" y="1" width="843" height="24" forecolor="#D0B48E" backcolor="#F2EBDF" uuid="f2324113-3563-4f48-b688-ed82b3098434"/>
			<textField evaluationTime="Report">
				<reportElement style="Column header" x="783" y="1" width="40" height="20" forecolor="#736343" uuid="9f676d3f-1486-4a48-96ce-fa0a2b7a1577"/>
				<textElement verticalAlignment="Middle">
					<font size="10" isBold="false"/>
				</textElement>
				<textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement style="Column header" x="703" y="1" width="80" height="20" forecolor="#736343" uuid="7415bd49-92ea-42ab-bbad-d370dba3cd03"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="10" isBold="false"/>
				</textElement>
				<textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
			</textField>
			<textField pattern="EEEEE dd MMMMM yyyy">
				<reportElement x="22" y="1" width="197" height="20" forecolor="#736343" uuid="8bf88488-fb5e-4676-a772-33cfbcf173cd"/>
				<textElement verticalAlignment="Middle">
					<font size="10" isBold="false"/>
				</textElement>
				<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
		</frame>
	</band>
</pageFooter>
<summary>
	<band height="200" splitType="Stretch">
		<property name="local_mesure_unitheight" value="pixel"/>
		<componentElement>
			<reportElement x="0" y="0" width="800" height="200" uuid="18303360-601a-4163-8211-6c50073a56eb"/>
			<jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components [url=http://jasperreports.sourceforge.net/xsd/components.xsd>]http://jasperreports.sourceforge.net/xsd/components.xsd">[/url]
				<datasetRun subDataset="tableDataset" uuid="6093954b-18e6-444d-92b8-096f4361edde">
					<datasetParameter name="dateWeek">
						<datasetParameterExpression><![CDATA[$P{dateWeek}]]></datasetParameterExpression>
					</datasetParameter>
					<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				</datasetRun>
				<jr:columnGroup width="800" uuid="58501418-4e9f-4af1-98a7-bd8e56720c16">
					<jr:groupHeader groupName="name">
						<jr:cell style="Table_CH" height="25">
							<textField>
								<reportElement style="Detail" x="0" y="0" width="800" height="25" uuid="10b50ffd-0ae2-4807-ad2e-5aff4206678f"/>
								<textFieldExpression><![CDATA[CONCATENATE("姓名：",$F{name})]]></textFieldExpression>
							</textField>
						</jr:cell>
					</jr:groupHeader>
					<jr:groupFooter groupName="name">
						<jr:cell style="Table_CH" height="25">
							<box>
								<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
								<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
								<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
								<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
							</box>
							<textField isBlankWhenNull="false">
								<reportElement style="Detail" mode="Transparent" x="0" y="0" width="800" height="25" forecolor="#000000" backcolor="#FFFFFF" uuid="0efdfbc3-e76a-4cd8-b11d-90aa1efb9ed8"/>
								<box>
									<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
									<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
									<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
									<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
								</box>
								<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" markup="none">
									<font isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false"/>
								</textElement>
								<textFieldExpression><![CDATA[CONCATENATE("工作数量:",$V{name_COUNT}.toString())]]></textFieldExpression>
							</textField>
						</jr:cell>
					</jr:groupFooter>
					<jr:column width="72" uuid="bd35d1ae-8f1e-4f4e-838f-cbc4c65a9f98">
						<jr:tableHeader style="Table_TH" height="30"/>
						<jr:tableFooter style="Table_TH" height="30"/>
						<jr:columnHeader style="Table_CH" height="30">
							<staticText>
								<reportElement key="" style="SubTitle" x="0" y="0" width="72" height="30" forecolor="#736343" uuid="7c0492fe-54c4-4ff1-b2a9-6fca68387c80"/>
								<box leftPadding="2"/>
								<textElement>
									<font size="14" isBold="true"/>
								</textElement>
								<text><![CDATA[工作名称]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table_CH" height="30"/>
						<jr:detailCell style="Table_TD" height="30">
							<textField>
								<reportElement style="Detail" x="0" y="0" width="72" height="30" uuid="d57d9070-67ea-4c24-899a-3a03611d01c2"/>
								<box leftPadding="2"/>
								<textElement>
									<font size="12"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{workName}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="72" uuid="1cbeb1f1-eb32-4ed5-b04e-8f856bfb44fe">
						<jr:tableHeader style="Table_TH" height="30"/>
						<jr:tableFooter style="Table_TH" height="30"/>
						<jr:columnHeader style="Table_CH" height="30">
							<staticText>
								<reportElement key="" style="SubTitle" x="0" y="0" width="72" height="30" forecolor="#736343" uuid="3518c6b0-ffe2-4700-b0e6-5582dae49143"/>
								<box leftPadding="2"/>
								<textElement>
									<font size="14" isBold="true"/>
								</textElement>
								<text><![CDATA[工作地点]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table_CH" height="30"/>
						<jr:detailCell style="Table_TD" height="30">
							<textField>
								<reportElement style="Detail" x="0" y="0" width="72" height="30" uuid="d8aa9786-6811-4a5a-bc77-9a416958341c"/>
								<box leftPadding="2"/>
								<textElement>
									<font size="12"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{workPlace}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="72" uuid="364d8229-d292-4e8b-b246-4094e0a4bf15">
						<jr:tableHeader style="Table_TH" height="30"/>
						<jr:tableFooter style="Table_TH" height="30"/>
						<jr:columnHeader style="Table_CH" height="30">
							<staticText>
								<reportElement key="" style="SubTitle" x="0" y="0" width="72" height="30" forecolor="#736343" uuid="f637b44b-ff73-42f9-9fc9-db8e0ac20aad"/>
								<box leftPadding="2"/>
								<textElement>
									<font size="14" isBold="true"/>
								</textElement>
								<text><![CDATA[工作类型]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table_CH" height="30"/>
						<jr:detailCell style="Table_TD" height="30">
							<textField>
								<reportElement style="Detail" x="0" y="0" width="72" height="30" uuid="5f113483-4648-414f-86f3-7da0d2e84458"/>
								<box leftPadding="2"/>
								<textElement>
									<font size="12"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{workType}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="72" uuid="985488cd-05eb-4733-8f89-b9d3ca417ce9">
						<jr:tableHeader style="Table_TH" height="30"/>
						<jr:tableFooter style="Table_TH" height="30"/>
						<jr:columnHeader style="Table_CH" height="30">
							<staticText>
								<reportElement key="" style="SubTitle" x="0" y="0" width="72" height="30" forecolor="#736343" uuid="da53481c-4eb3-4649-858f-bb3d5e90e750"/>
								<box leftPadding="2"/>
								<textElement>
									<font size="14" isBold="true"/>
								</textElement>
								<text><![CDATA[项目编号]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table_CH" height="30"/>
						<jr:detailCell style="Table_TD" height="30">
							<textField>
								<reportElement style="Detail" x="0" y="0" width="72" height="30" uuid="5e537c4f-712d-4134-af7c-49d1850ba29f"/>
								<box leftPadding="2"/>
								<textElement>
									<font size="12"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{projectNo}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="72" uuid="d247c6eb-8983-4da0-8641-ba39058cf145">
						<jr:tableHeader style="Table_TH" height="30"/>
						<jr:tableFooter style="Table_TH" height="30"/>
						<jr:columnHeader style="Table_CH" height="30">
							<staticText>
								<reportElement key="" style="SubTitle" x="0" y="0" width="72" height="30" forecolor="#736343" uuid="20a22db4-3c7a-458e-9571-6b164a67ee78"/>
								<box leftPadding="2"/>
								<textElement>
									<font size="14" isBold="true"/>
								</textElement>
								<text><![CDATA[项目状态]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table_CH" height="30"/>
						<jr:detailCell style="Table_TD" height="30">
							<textField>
								<reportElement style="Detail" x="0" y="0" width="72" height="30" uuid="83fe6ec1-6054-4b01-adb0-ea672711ebc4"/>
								<box leftPadding="2"/>
								<textElement>
									<font size="12"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{projectStatus}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="72" uuid="226417ad-78d6-4176-afc3-fb367c32abdd">
						<jr:tableHeader style="Table_TH" height="30"/>
						<jr:tableFooter style="Table_TH" height="30"/>
						<jr:columnHeader style="Table_CH" height="30">
							<staticText>
								<reportElement key="" style="SubTitle" x="0" y="0" width="72" height="30" forecolor="#736343" uuid="07221319-e789-45a3-8c4f-41e53f9fd663"/>
								<box leftPadding="2"/>
								<textElement>
									<font size="14" isBold="true"/>
								</textElement>
								<text><![CDATA[项目名称]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table_CH" height="30"/>
						<jr:detailCell style="Table_TD" height="30">
							<textField>
								<reportElement style="Detail" x="0" y="0" width="72" height="30" uuid="4c552ddd-9065-49b6-b941-b3923077c69c"/>
								<box leftPadding="2"/>
								<textElement>
									<font size="12"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{projectName}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="72" uuid="ce4eb71e-ed63-4882-b3e3-fabd574a8ff9">
						<jr:tableHeader style="Table_TH" height="30"/>
						<jr:tableFooter style="Table_TH" height="30"/>
						<jr:columnHeader style="Table_CH" height="30">
							<staticText>
								<reportElement key="" style="SubTitle" x="0" y="0" width="72" height="30" forecolor="#736343" uuid="8165bef3-83b6-4b4e-abee-1d23386f9e8f"/>
								<box leftPadding="2"/>
								<textElement>
									<font size="14" isBold="true"/>
								</textElement>
								<text><![CDATA[开始时间]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table_CH" height="30"/>
						<jr:detailCell style="Table_TD" height="30">
							<textField pattern="yyyy-M-dd">
								<reportElement style="Detail" x="0" y="0" width="72" height="30" uuid="82081fcd-0c04-4a03-ade9-f9d06801d6b2"/>
								<box leftPadding="2"/>
								<textElement>
									<font size="12"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{startDate}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="72" uuid="cdab7c1a-b43a-4c21-a8b9-c1756ac4c2cf">
						<jr:tableHeader style="Table_TH" height="30"/>
						<jr:tableFooter style="Table_TH" height="30"/>
						<jr:columnHeader style="Table_CH" height="30">
							<staticText>
								<reportElement key="" style="SubTitle" x="0" y="0" width="72" height="30" forecolor="#736343" uuid="544103ef-3d74-4b2d-ad6a-172bdc84612d"/>
								<box leftPadding="2"/>
								<textElement>
									<font size="14" isBold="true"/>
								</textElement>
								<text><![CDATA[结束时间]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table_CH" height="30"/>
						<jr:detailCell style="Table_TD" height="30">
							<textField pattern="yyyy-M-dd">
								<reportElement style="Detail" x="0" y="0" width="72" height="30" uuid="6bdb9232-54f1-4ee4-8b3d-2ba5b847a8d4"/>
								<box leftPadding="2"/>
								<textElement>
									<font size="12"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{endDate}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="124" uuid="03c30817-d64b-420e-b5f2-57330c36d9e5">
						<jr:tableHeader style="Table_TH" height="30"/>
						<jr:tableFooter style="Table_TH" height="30"/>
						<jr:columnHeader style="Table_CH" height="30">
							<staticText>
								<reportElement key="" style="SubTitle" x="0" y="0" width="124" height="30" forecolor="#736343" uuid="ede4895e-ac57-48ad-8d90-58900793cd23"/>
								<box leftPadding="2"/>
								<textElement>
									<font size="14" isBold="true"/>
								</textElement>
								<text><![CDATA[工作描述]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table_CH" height="30"/>
						<jr:detailCell style="Table_TD" height="30">
							<textField>
								<reportElement style="Detail" x="0" y="0" width="124" height="30" uuid="664e632f-15c1-49a6-98ea-ab2142f368c0"/>
								<box leftPadding="2"/>
								<textElement>
									<font size="12"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{workDescription}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="100" uuid="53f8dd42-0ab2-4053-982f-30c804f63256">
						<jr:tableHeader style="Table_TH" height="30"/>
						<jr:tableFooter style="Table_TH" height="30"/>
						<jr:columnHeader style="Table_CH" height="30">
							<staticText>
								<reportElement key="" style="SubTitle" x="0" y="0" width="100" height="30" forecolor="#736343" uuid="a531d307-e4ab-479c-be8c-e9ad44679082"/>
								<box leftPadding="2"/>
								<textElement>
									<font size="14" isBold="true"/>
								</textElement>
								<text><![CDATA[工作文件]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table_CH" height="30"/>
						<jr:detailCell style="Table_TD" height="30">
							<textField>
								<reportElement style="Detail" x="0" y="0" width="100" height="30" uuid="6fa13f0b-f8c1-42a0-883d-a0a611b0040a"/>
								<box leftPadding="2"/>
								<textElement>
									<font size="12"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{workFile}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
				</jr:columnGroup>
			</jr:table>
		</componentElement>
	</band>
</summary>

Guest · April 20, 2015, 2:39pm

Hi,

my guess would be that somewhere in your system the character encoding is wrong/gets messed up.
Can you try again with a very simple test report that contains just a static text with some chinese characters?

If this also does not work, download the jrxml-file from reportserver and check if its still valid.

Cheers,
Thorsten

gpanzl · April 21, 2015, 4:35am

Many thanks for your reply!!

my system is win7 english with mulit language pack(zh-cn) installed, local not unicode app display language gbk.

and I checked this jrxml file (generated by jasper studio,jasper studio compile it corrected and show right final report ) with oracle xdk , it is well formed and valided.

I must use chinese character for report.

How should i do?

Arno_Mittelbach · April 21, 2015, 7:11am

Could you try to upload the report (or better, a simple test report) to ReportServer and then download it from ReportServer (button download jrxml on report management page). Then compare
the two jrxml files (original and downloaded). If something changed then this indicates that somewhere (e.g. in the database) the character encoding gets messed up.

Cheers
-Arno

gpanzl · April 21, 2015, 9:30am

Thanks.

I tested.

compare the original jrxml with the jrxml (uploaded on server), found the chinese character all changed, from utf-8 to the code that I can’t recognize. Why this happened?

past one line compare result

original jrxml

original jrxml hexcode

3c 74 65 78 74 3e 3c 21 5b 43 44 41 54 41 5b e8 bf 90 e8 90 a5 e6 94 af e6 92 91 e4 b8 ad e5 bf 83 e9 a1 b9 e7 9b ae e5 b7 a5 e4 bd 9c e5 91 a8 e6 8a a5 5d 5d 3e 3c 2f 74 65 78 74 3e

jrxml on server

jrxml on server hexcode

3c 74 65 78 74 3e 3c 21 5b 43 44 41 54 41 5b e6 9d a9 e6 84 af e6 83 80 e9 8f 80 ee 88 9b e6 8b ba e6 b6 93 ee 85 9e e7 b8 be e6 a4 a4 e5 9c ad e6 b4 b0 e5 ae b8 e3 83 a4 e7 b6 94 e9 8d 9b e3 84 a6 e5 a7 a4 5d 5d 3e 3c 2f 74 65 78 74 3e

wish it’s useful.

Cheers

Guest · April 21, 2015, 9:47am

Hi,

please take a look at this thread:

http://forum.reportserver.net/viewtopic.php?id=156

I think this is the same issue, so please try the suggestions there and see if it helps.

Cheers,
Thorsten

gpanzl · April 22, 2015, 5:52am

I changered persistence.xml

set

I restart reportserver and mysql, then delete report and upload jrxml again ,but still get “The report could not be executed: Could not execute report: org.xml.sax.SAXParseException; lineNumber: 111; columnNumber: 56; The end-tag for element type “text” must end with a ‘>’ delimiter.”

I download the archive jrxml , I found the chinese character still changed.

maybe the change happened in the uploading process???

Guest · April 23, 2015, 10:18am

Did you also modify the default encoding in the /etc/main/main.cf configfile and verify that the file.encoding=UTF8 system property is set?

gpanzl · April 24, 2015, 1:21am

when i install ,i already set “ UTF-8 ”.

If file.encoding=UTF8 has diffenert with UTF-8 , and what is the syntax of “file.encoding=UTF8”?

Guest · April 24, 2015, 5:20am

Hi gpanzl,

the file.encoding is a java/tomcat setting.
On windows you can just set it in the tomcat manager
http://blog.jamesbayley.com/2013/09/09/tomcat-7-on-windows-is-not-utf-8-by-default/
on linux it might depend on your distribution - for ubuntu its JAVA_OPTS in /etc/default/tomcat7

Cheers,
Thorsten

gpanzl · April 27, 2015, 9:11am

thanks Thorsten J. Krause , the chinese character didnt change.

but i get another error:

Error: An error occured during report execution.
The report could not be executed: Could not execute report: Errors were encountered when compiling report expressions class file: 1. The method TODAY() is undefined for the type aaa_1430125343599_717957 value = TODAY( ); //$JR_EXPR_ID=0$ <—> 2. The method WEEKNUM(Date) is undefined for the type aaa_1430125343599_717957 value = CONCATENATE(“第”,WEEKNUM(((java.util.Date)parameter_dateWeek.getValue())).toString(),“周”); //$JR_EXPR_ID=12$ <-----> 3. The method TODAY() is undefined for the type aaa_1430125343599_717957 value = TODAY( ); //$JR_EXPR_ID=0$ <—> 4. The method WEEKNUM(Date) is undefined for the type aaa_1430125343599_717957 value = CONCATENATE(“第”,WEEKNUM(((java.util.Date)parameter_dateWeek.getValue())).toString(),“周”); //$JR_EXPR_ID=12$ <-----> 5. The method TODAY() is undefined for the type aaa_1430125343599_717957 value = TODAY( ); //$JR_EXPR_ID=0$ <—> 6. The method WEEKNUM(Date) is undefined for the type aaa_1430125343599_717957 value = CONCATENATE(“第”,WEEKNUM(((java.util.Date)parameter_dateWeek.getValue())).toString(),“周”); //$JR_EXPR_ID=12$ <-----> 6 errors 1. The method CONCATENATE(String, String) is undefined for the type aaa_tableDataset_1430125343599_717957 value = CONCATENATE(“姓名：”,((java.lang.String)field_name.getValue())); //$JR_EXPR_ID=11$ <---------> 2. The method CONCATENATE(String, String) is undefined for the type aaa_tableDataset_1430125343599_717957 value = CONCATENATE(“工作数量:”,((java.lang.Integer)variable_name_COUNT.getValue()).toString()); //$JR_EXPR_ID=12$ <---------> 3. The method CONCATENATE(String, String) is undefined for the type aaa_tableDataset_1430125343599_717957 value = CONCATENATE(“姓名：”,((java.lang.String)field_name.getOldValue())); //$JR_EXPR_ID=11$ <---------> 4. The method CONCATENATE(String, String) is undefined for the type aaa_tableDataset_1430125343599_717957 value = CONCATENATE(“工作数量:”,((java.lang.Integer)variable_name_COUNT.getOldValue()).toString()); //$JR_EXPR_ID=12$ <---------> 5. The method CONCATENATE(String, String) is undefined for the type aaa_tableDataset_1430125343599_717957 value = CONCATENATE(“姓名：”,((java.lang.String)field_name.getValue())); //$JR_EXPR_ID=11$ <---------> 6. The method CONCATENATE(String, String) is undefined for the type aaa_tableDataset_1430125343599_717957 value = CONCATENATE(“工作数量:”,((java.lang.Integer)variable_name_COUNT.getEstimatedValue()).toString()); //$JR_EXPR_ID=12$ <---------> 6 errors
To get help please contact an administrator.

if reportserver didnt support the expressions in jasperstudio?

Arno_Mittelbach · April 27, 2015, 6:04pm

Hi,

in order to use the jasperreports functions (like TODAY etc.) you’ll need to add jasperreports-functions-6.0.3.jar (http://sourceforge.net/projects/jasperreports/files/jasperreports/JasperReports%206.0.3/), as well as joda-time-2.7.jar (https://github.com/JodaOrg/joda-time/releases) to the WEB-INF/libs directory and restart ReportServer.

Cheers
-Arno

gpanzl · May 4, 2015, 6:12am

Hi. Thanks for Arno Mittelbach

Jasperreports functions is ok! But the parameter in the jrxml cant work. Should i change to reportserver parameter？

Arno_Mittelbach · May 4, 2015, 6:48am

Hi, I am not quite sure what you mean. Could you elaborate?

Arno

gpanzl · May 5, 2015, 4:13am

I set a parameter to be used as a prompt, when a report is executed, Jaspersoft server asks for the value of the parameter with web page。Then i use the parameter with SQL Query for filter records .

But i didnt get web page for input the parameter value with jrxml.

Arno_Mittelbach · May 5, 2015, 7:56am

You need to declare the parameter in ReportServer. Have a look at the administration guide for further information on parameters.

Cheers
-Arno