[Error when opening JRXML files on Windows...]

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?

 

[Input Controls and Parameters]

That was it! Thanks!

[Input Controls and Parameters]

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?

[Installing MS SQL Server JDBC driver on Windows]

Worked like a charm! Thanks!

[Installing MS SQL Server JDBC driver on Windows]

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?