jkoorts

In my sql string there were carriage returns and tabs. This screwed up my query in ireport. I copied a tab and carriage return statement into jrxml (not ireport) then loaded the file in ireport and ireport corrupted it. For instance: Select * from Mytable,othertable Where Column1 = column2 Order by Column1 Take the jrxml file and load it with ireport. save the doc. now open the jrxml file with notepad. sql part will be screwed

Thanks mate! I checked the jasper report book again, and yes they did use the summary tag in their example, but no where does it say that you need to put charts in summary. thanks a lot again. jacques

hi there, I run this query (simplified for this question) select month, count from pool From this query i get 12 records. one for each month. This displays fine in my barchart, but for some reason i get 12 charts for the same chart? I dont use the grouping cause i dont need it, as the query is already aggregated in a 'group by' clause. I just want to put the 12 records in 1 chart and thats the end of it. Attached is my jrxml file. thanks for any help [file name=VolumeReport.jrxml size=10653]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/VolumeReport.jrxml[/file]

hi ok, i got it working. the trick is not to use ireport to test this. well that was the trick for me, i found ireport too riddled with bugs. the trick is to test it from a java app. see jasperreports doc on how to 1. compile a jrxml file 2. fill a report Remember to add your customizer class to your java apps classpath. Attached is the customizer jar, the jrxml and the java app. its not neat i know, its just a scratch app i used to get the stuff working. [file name=JasperReport.zip size=3871]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/JasperReport.zip[/file]

hi there, All i want to do is run a Postgresql function in my jrxml file, to get the recordset back. The function returns a cursor back. Does Jasper support cursors? If not what are my other options? Also what would the syntax be to run the query from jasper? Would "select myfunction()" do? hope someone can help, as im up against the wall here. Here my function: create or replace FUNCTION foo() RETURNS refcursor AS 'DECLARE ref refcursor; BEGIN OPEN ref FOR SELECT * FROM datefill; RETURN ref; END; ' LANGUAGE 'plpgsql'; cheers jacques Post edited by: jkoorts, at: 2006/09/22 13:49

------------ |..........| |..........| |..........| |..........| |..........| |.1.of.20000 ------------

So make sure you put that pagecount variable quite a bit left of the right side of the document. ------------ | | | | | | | | | | | 1 of 20000 ------------ if jasperreports could stretch horizontally, then we could have set it to stretch horizontally to the left. Can we have this feature pretty please?

there is a problem (bug) with that tips and tricks. if the pagecount gets to big (13453453533) the text could possibly not fit the field - so it wont be displayed. to have that working JasperReports needs to add the feature that fields can be automatically stretched HORIZONTALLY!

hi, after 1 year i see this feature still has not been implemented. please can we have this implemented in the next release. at the moment im also putting all variables into one variable and making the field width big enough.

yeah sorry, i updated this in the bug forum. i saw that my sql was not entirely correct. you are right about my mistake. i got it working yesterday. thanks jacques

ahh i saw ireport does not like tabs and carriage returns in the [[data]] field its still a bug tho ;)

after 3 hours i have this to say. I FOUND A SQL BUG. I'm sure of it. select entry.date, entry.msisdn, entry.content from entry where entry.date >= '1 january 2006' and entry.date <= '1 january 2007' WORKS!!!!! select entry.date, entry.msisdn, entry.content from entry where entry.date >= $P{dateFrom} and entry.date <= '1 january 2007' WORKS!!!!! select entry.date, entry.msisdn, entry.content from entry where entry.date >= $P{dateFrom} and entry.date <= $P{dateTo} DOES NOT WORK!!!!! Yes dateTo does get populated with a value. I displayed it in the report and it showed 1 january 2007. Here some code snippets. hashMap.put("dateFrom",new String("1 January 2006")); hashMap.put("dateTo",new String("1 January 2007")); <parameter name="network" class="java.lang.String"/> <parameter name="dateFrom" class="java.lang.String"/> <parameter name="dateTo" class="java.lang.String"/> <parameter name="MSISDN" class="java.lang.String"/> <queryString> <![CDATA[select entry.date, entry.msisdn, entry.content from entry where entry.date >= $P{dateFrom} and entry.date <= $P{dateTo} ]]>

Hi, I see many people (including me have the same problem). Its very discouraging that there is no tutorial on how to do this. I went and bought the jasper reports book to see if that helps, but they skipped the customizer bit. somehow i wonder if this feature even works. I mean little help from Admin on any customizer posts. the books steers away from it, and there is no tut on the web. going over to jfreechart's website you also see no posts for it. I did get the nullpointer problems solved though. You need to jar your class, and then put it in your ireport's classpath (assuming you're testing it with ireport, which i do). I'm now getting the following error: Error filling print... Null 'key' argument. java.lang.IllegalArgumentException: Null 'key' argument. at org.jfree.data.DefaultKeyedValues.setValue(DefaultKeyedValues.java:225) So it looks like its at least looking at my class. I'll report back when i got this solved. Here a copy of my customizer class. import net.sf.jasperreports.engine.*; import org.jfree.chart.JFreeChart; public class customizemychart implements JRChartCustomizer{ public void customize(JFreeChart jfreechart,JRChart jasperChart) { jfreechart.setTitle("Setting the title of the chart im customizing!"); } }

Hi I see many newbies including me have to following problem that no one seems to be able to remark on let alone fix. What we do is we follow the JasperReports for developers book. What they instruct you to do in the first few pages is: 1. create a xml report template file EXACTLY as in the ebook 2. open build.xml and type EXACTLY <target name="viewDesignXML" description="Launches the design viewer"> <java classname="net.sf.jasperreports.view.JasperDesignViewer" fork="true"> <arg value="-XML"/> <arg value="-F${file.name}.jrxml"/> <classpath refid="classpath"/> </java> </target> 3. when running this ant script you should see the template displayed nicely. It did so we turned the page. 4. open a project and type EXACTLY the code JasperCompileManager.compileReportToFile("somefilename"); 5. open build.xml and type EXACTLY <target name="viewDesignXML" description="Launches the design viewer"> <java classname="net.sf.jasperreports.view.JasperDesignViewer" fork="true"> <arg value="-XML"/> <arg value="-F${file.name}.jrxml"/> <classpath refid="classpath"/> </java> </target> 6. Run the script and you should see the compiled template displayed nicely. IT DOES NOT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! We get this! Can ANYONE solve this!? I-Report can open my compiled template fine, but this thing called JasperDesignViewer cant!!1 Yes we all tried ISO 8859-1 and it gave THE SAME problem. org.apache.xerces.impl.io.MalformedByteSequenceException: Invalid byte 1 of 1-byte UTF-8 sequence. at org.apache.xerces.impl.io.UTF8Reader.invalidByte(Unknown Source) at org.apache.xerces.impl.io.UTF8Reader.read(Unknown Source) at org.apache.xerces.impl.XMLEntityScanner.load(Unknown Source) at org.apache.xerces.impl.XMLEntityScanner.skipString(Unknown Source) at org.apache.xerces.impl.XMLVersionDetector.determineDocVersion(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:1647) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:238) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:225) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:213) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:167) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:151) at net.sf.jasperreports.view.JRDesignViewer.loadReport(JRDesignViewer.java:531) at net.sf.jasperreports.view.JRDesignViewer.<init>(JRDesignViewer.java:155) at net.sf.jasperreports.view.JasperDesignViewer.<init>(JasperDesignViewer.java:51) at net.sf.jasperreports.view.JasperDesignViewer.viewReportDesign(JasperDesignViewer.java:177) at net.sf.jasperreports.view.JasperDesignViewer.main(JasperDesignViewer.java:152) NESTED BY : org.apache.xerces.impl.io.MalformedByteSequenceException: Invalid byte 1 of 1-byte UTF-8 sequence. at org.apache.xerces.impl.io.UTF8Reader.invalidByte(Unknown Source) at org.apache.xerces.impl.io.UTF8Reader.read(Unknown Source) at org.apache.xerces.impl.XMLEntityScanner.load(Unknown Source) at org.apache.xerces.impl.XMLEntityScanner.skipString(Unknown Source) at org.apache.xerces.impl.XMLVersionDetector.determineDocVersion(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:1647) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:238) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:225) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:213) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:167) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:151) at net.sf.jasperreports.view.JRDesignViewer.loadReport(JRDesignViewer.java:531) at net.sf.jasperreports.view.JRDesignViewer.<init>(JRDesignViewer.java:155) at net.sf.jasperreports.view.JasperDesignViewer.<init>(JasperDesignViewer.java:51) at net.sf.jasperreports.view.JasperDesignViewer.viewReportDesign(JasperDesignViewer.java:177) at net.sf.jasperreports.view.JasperDesignViewer.main(JasperDesignViewer.java:152) NESTED BY : net.sf.jasperreports.engine.JRException: Invalid byte 1 of 1-byte UTF-8 sequence. at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:246) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:225) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:213) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:167) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:151) at net.sf.jasperreports.view.JRDesignViewer.loadReport(JRDesignViewer.java:531) at net.sf.jasperreports.view.JRDesignViewer.<init>(JRDesignViewer.java:155) at net.sf.jasperreports.view.JasperDesignViewer.<init>(JasperDesignViewer.java:51) at net.sf.jasperreports.view.JasperDesignViewer.viewReportDesign(JasperDesignViewer.java:177) at net.sf.jasperreports.view.JasperDesignViewer.main(JasperDesignViewer.java:152) Caused by: org.apache.xerces.impl.io.MalformedByteSequenceException: Invalid byte 1 of 1-byte UTF-8 sequence. at org.apache.xerces.impl.io.UTF8Reader.invalidByte(Unknown Source) at org.apache.xerces.impl.io.UTF8Reader.read(Unknown Source) at org.apache.xerces.impl.XMLEntityScanner.load(Unknown Source) at org.apache.xerces.impl.XMLEntityScanner.skipString(Unknown Source) at org.apache.xerces.impl.XMLVersionDetector.determineDocVersion(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:1647) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:238) ... 9 more