medium_grade

I am having some trouble opening JRXML files that I have created in iReport after saving them. Both iReport and my local JasperServer give me the following error: Error loading the report template Message: net.sf.jasperreports.engine.JRException: com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Invalid byte 1 of 1-byte UTF-8 sequence. Level: SEVERE Stack Trace: com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Invalid byte 1 of 1-byte UTF-8 sequence. net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:247) net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:226) net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:214) com.jaspersoft.ireport.designer.JrxmlLoader.reloadJasperDesign(JrxmlLoader.java:80) com.jaspersoft.ireport.designer.JrxmlVisualView.run(JrxmlVisualView.java:485) org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561) org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986) Invalid byte 1 of 1-byte UTF-8 sequence. com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.invalidByte(Unknown Source) com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.read(Unknown Source) com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.load(Unknown Source) com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.scanLiteral(Unknown Source) com.sun.org.apache.xerces.internal.impl.XMLScanner.scanAttributeValue(Unknown Source) com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanAttribute(Unknown Source) com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source) com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source) com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source) com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source) com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source) com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source) com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) org.apache.commons.digester.Digester.parse(Digester.java:1647) net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:239) net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:226) net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:214) com.jaspersoft.ireport.designer.JrxmlLoader.reloadJasperDesign(JrxmlLoader.java:80) com.jaspersoft.ireport.designer.JrxmlVisualView.run(JrxmlVisualView.java:485) org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561) org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986) The only way I can fix this is by changing the encoding on the first line from "UTF-8" to"ISO-8859-1". I can't seem to figure a way around this. Can someone help me?

That was it! Thanks!

Hello, I am brand new to Jasper Reports and I need a little help in setting up input controls for report paramters. I have setup the following parameters within the report: from_date, to_date. The query for the report is as follows: SELECT * FROM v_OE_Invoice_Headers WHERE INVOICEDATE between '$P{from_date}' and '$P{to_date}' ORDER BY INVOICEDATE; For the report, I have setup two input controls. One in which the Parameter Name is from_date and the other for which the Parameter Name is to_date. When I run the report, the server prompts me for these input fields, but then throws the following error: com.jaspersoft.jasperserver.api.JSExceptionWrapper: Error preparing statement for executing the report query : SELECT * FROM v_OE_Invoice_Headers WHERE INVOICEDATE between '?' and '?' ORDER BY INVOICEDATE; com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query : SELECT * FROM v_OE_Invoice_Headers WHERE INVOICEDATE between '?' and '?' ORDER BY INVOICEDATE; Is there a step I am missing in all of this?

Worked like a charm! Thanks!

I am interested in using JasperReports to satisfy numerous reporting needs that my company has. I am not a Java developer, so most of what is described with regards to how Jasper/Tomcat/JDBC work is very new to me. I am trying to setup my JasperServer to use the Microsoft MS SQL JDBC driver. I have placed the sqljdbc.jar file in the comon/lib directly of the apache-tomcat root. When I try to create a new datasource, the test always fails (without giving me a reason why). When a check under Managage --> Analysis Properties, I do not see the MSSQL Server driver listed under JdbcDrivers. Am I doing something wrong? How do I properly install this driver?