CharleyDC5

An answer would be really appreciated. Thank you very much Post Edited by CharleyDC5 at 05/01/2009 12:24

Hi C-Box, Thanks for the info. Do you have the URL where I could download the source code ? Maybe you could share your standalone massive compiler version here as an attachment ? Thank you very much Charles

Hi folks, Is there a way to compile a bunch of reports at the same time without having to open them all once ? (Just like the old massive compiler we had in iReport 2.0.4) Version used : 3.5.0-nb Thank you very much Charles M.

Hi folks, I hope you are doing fine. Does anyone here knows if there is a way to implement the old massive compiler plugin into the new iReport environment ? If not, is there another tool we can use to compile a big set of reports and subreports ? Thank you very much Charles

Just tried it and it doesn't work :( Well, it was already set to : "Relative to band height". Any other possible solution ? Thank you very much Sivaaa for your help Charles

Attachments doesn't work. You can find them here : http://www.charlesmorin.info/ireport_screenshot1.jpg http://www.charlesmorin.info/ireport_screenshot2.jpg Thanks Charles M.

Sorry for the last reply... I just wanted to create a new discussion in the iReport Discussion/Help section. I can't delete it so.. maybe Administrator could delete it .. Thank you ! Charles M.

Hi folks, Hope you are doing fine. Here is my problem : I work on a report containing a crosstab. That crosstab is populated by a SQL query runned in a dataset. Everything's perfect, but I only have one tiny problem, which is quite annoying. I am unable to hide/remove a full blank line in my crosstab (see the screenshot for more information). Some will probably say : Why are you adding a blank record in your query results ? Answer : Well, this is a specific situation. I will try to make it easy to understand. Here we go : For instance you have a list of laptops in a crosstab. You will need a row group on the serial number, and a column group on the laptops brands. Let's say you want to list all laptops in a region, for every location/office. • Office A only has HP and Dell laptops • Office B only has HP and Lenovo laptops The problem : You want to show all laptop brands, even if a location doesn't have that laptop brand. (see the second screenshot/image for more information). To achieve it, I add a NULL record in my SQL temp table, representing laptop brands that are missing in the office. Example : Office A has a NULL record with the Lenovo brand, and Office B has a NULL record with the Dell brand. This is the only way I found to always print all the columns in the crosstab. Otherwise, the crosstab wasn't showing the NULL columns since it is not available in the SQL query results (raw data). I just want to hide that null row and eliminate the spacer it creates. Every field in the crosstab details has Remove Line When Blank checked. As you can see, the line has nothing printed. Now, I just need to hide it for esthetic purpose. Thank you in advance for help Charles M.

Hi folks, Hope you are doing fine. Here is my problem : I work on a report containing a crosstab. That crosstab is populated by a SQL query runned in a dataset. Everything's perfect, but I only have one tiny problem, which is quite annoying. I am unable to hide/remove a full blank line in my crosstab (see the screenshot for more information). Some will probably say : Why are you adding a blank record in your query results ? Answer : Well, this is a specific situation. I will try to make it easy to understand. Here we go : For instance you have a list of laptops in a crosstab. You will need a row group on the serial number, and a column group on the laptops brands. Let's say you want to list all laptops in a region, for every location/office. • Office A only has HP and Dell laptops • Office B only has HP and Lenovo laptops The problem : You want to show all laptop brands, even if a location doesn't have that laptop brand. (see the second screenshot/image for more information). To achieve it, I add a NULL record in my SQL temp table, representing laptop brands that are missing in the office. Example : Office A has a NULL record with the Lenovo brand, and Office B has a NULL record with the Dell brand. This is the only way I found to always print all the columns in the crosstab. Otherwise, the crosstab wasn't showing the NULL columns since it is not available in the SQL query results (raw data). I just want to hide that null row and eliminate the spacer it creates. Every field in the crosstab details has Remove Line When Blank checked. As you can see, the line has nothing printed. Now, I just need to hide it for esthetic purpose. Thank you in advance for help Charles M.

emillerphx Wrote: OK, unfolding here. I got in there an noticed that my $-signs were showing up as blocks... looking at the pattern some weird character was defined. I changed it to a $ and now everything looks good. Yeah I had the same problem. You just need to re-do the pattern operation on your currency field and the $ signs will come back to normal. Probably the pattern changed in the new IDE.

I'm glad it fixed the problem for you guys !! I find it very hard to troubleshoot that kind of error. I think we must have a debugger tool in the next version of iReport-nb. It is not that bad when the report only has 50 XML lines, but when you have a crosstab and 3 subreports, this is really a pain to fix. Probably the new NetBeans IDE version has a new version of the SAX Parser, which is handling some more UTF8 sequences. Theodor, Giulio ? Any idea ? Thank you guys Charles M.

For you information, The only way I have found to fix the problem is to install the following plugin from the Tools > Plugins menu : XML and Schema Version : 1.0.1 By installing this plugin, the version of the IDE changed to 1.2.3. Is it a common problem from the 1.0.2 IDE version ?

It really looks like a problem in my XML code... Do you guys know a validator where I could put my code and then see what happen with it ? I wish iReport had a debug mode :( Thank you VERY MUCH for help Charles M.

Hi guys, I just started using the new iReport 3.1.1nb and I must say it is really good ! I just had a major/severe problem with my report, and I am quite disappointed about that... Here we go : Error loading the report template Message: net.sf.jasperreports.engine.JRException: org.xml.sax.SAXParseException: Invalid byte 1 of 1-byte UTF-8 sequence. Level: SEVERE Stack Trace: org.xml.sax.SAXParseException: Invalid byte 1 of 1-byte UTF-8 sequence. net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:243) 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.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source) com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(Unknown Source) com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source) com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source) com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(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) 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) It happened at a random time when I opened a specific report after closing iReport for a simple reboot. Since my report XML file is quite big, it is really hard for me to find the wrong code line in all those XML codes. Please help ! Thank you Charles M.

Hi there, Did you find a solution to your problem ? I'm experiencing the same problem right now and looking forward to find a solution in order to fix it. You got PMed ! 'Later Charles M.

Hi all, Actually I have a problem which is quite annoying in iReport... My jrxml report has 3 sections : Page header, detail & footer. It is a kind of letter which is dynamically generated, depending on some filters filled by the client. The report is generating a contract for an employee. In the page header section, I have the enterprise logo. In the detail section, I got all information about the employee, followed by an horizontal line, in order to separate from the contract conditions listed right after. Those conditions are dynamically generated from a SQL variable (Concatenate variable with all the condition paragraphes inside). Each condition represents a paragraph in the detail band. Is there a way to set the page footer to "static" or something like that ? For example, if I have only two little paragraphs in a contract, my page footer will NOT be overridden because the report will not need another detail band page. If I have 15 paragraphs (so I need more than one detail band page), the page footer is overridden.. It looks like it is just floating here as a layer... But I just can't find any configuration to fix my problem.. SEE THE ATTACHMENT FOR DEMONSTRATION : [file name=pageFooterProblem.jpg size=197294] Thank you very much for help Have a good day Post edited by: CharleyDC5, at: 2008/03/31 18:29 Post edited by: CharleyDC5, at: 2008/03/31 18:31

Admins : Delete this thread please Sorry Post edited by: CharleyDC5, at: 2008/03/31 18:53 Post edited by: CharleyDC5, at: 2008/03/31 18:54 Post edited by: CharleyDC5, at: 2008/03/31 18:54