SQL Problem can't select sum()?????????????

[2004 IR Help]

By: tomuno - tomuno

SQL Problem can't select sum()?????????????

2005-03-17 01:45

oracle9i

ireport4.0 jasperreorts0.6.1 jdk1.4

 

select sum(ren) from mytable

 

errors:

 

org.xml.sax.SAXParseException:?Attribute?value?"SUM(REN)"?of?type?NMTOKEN?must?be?a?name?token. ????at?org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown?Source) ????at?org.apache.xerces.util.ErrorHandlerWrapper.error(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.dtd.XMLDTDValidator.validateDTDattribute(Unknown?Source) ????at?org.apache.xerces.impl.dtd.XMLDTDValidator.addDTDDefaultAttrsAndValidate(Unknown?Source) ????at?org.apache.xerces.impl.dtd.XMLDTDValidator.handleStartElement(Unknown?Source) ????at?org.apache.xerces.impl.dtd.XMLDTDValidator.emptyElement(Unknown?Source) ????at?org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(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.DTDConfiguration.parse(Unknown?Source) ????at?org.apache.xerces.parsers.XMLParser.parse(Unknown?Source) ????at?org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown?Source) ????at?org.apache.commons.digester.Digester.parse(Digester.java:1514) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:400) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:384) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:338) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:322) ????at?net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:128) ????at?it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:336) ????at?java.lang.Thread.run(Thread.java:536) org.xml.sax.SAXParseException:?Attribute?value?"SUM(REN)"?of?type?NMTOKEN?must?be?a?name?token. ????at?org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown?Source) ????at?org.apache.commons.digester.Digester.parse(Digester.java:1514) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:400) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:384) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:338) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:322) ????at?net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:128) ????at?it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:336) ????at?java.lang.Thread.run(Thread.java:536) NESTED?BY?: net.sf.jasperreports.engine.JRException:?Attribute?value?"SUM(REN)"?of?type?NMTOKEN?must?be?a?name?token. ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:404) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:384) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:338) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:322) ????at?net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:128) ????at?it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:336) ????at?java.lang.Thread.run(Thread.java:536) Caused?by:?org.xml.sax.SAXParseException:?Attribute?value?"SUM(REN)"?of?type?NMTOKEN?must?be?a?name?token. ????at?org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown?Source) ????at?org.apache.commons.digester.Digester.parse(Digester.java:1514) ????at?net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:400) ????...?6?more

 

 

can't select?????????????

 

 

 

 

By: Tobias Gaekle - ike987

RE: SQL Problem can't select sum()???????????

2005-03-17 01:56

Define an alias that can be used as report field name.

 

select sum(ren) AS mySum from mytable

 

 

 

 

By: tomuno - tomuno

RE: SQL Problem can't select sum()?????????????

2005-03-17 16:20

thanks you