Jump to content

CharleyDC5

Members
 View Profile  See their activity

  • Posts

    43

  • Joined

  • Last visited

 Content Type 

Forum

Downloads

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Events

Profiles

Posts posted by CharleyDC5

    Massive compiler

    in Products

    Posted

    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

    Massive compiler

    in Products

    Posted

    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.

    Massive compiler for iReport-nb 3.1.2

    in Products

    Posted

    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

    How to remove a blank line in a iReport crosstab?

    in Products

    Posted

    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.

    ERROR : Invalid byte 1 of 1-byte UTF-8 sequence

    in Products

    Posted

    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.

    ERROR : Invalid byte 1 of 1-byte UTF-8 sequence

    in Products

    Posted

    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.

    ERROR : Invalid byte 1 of 1-byte UTF-8 sequence

    in Products

    Posted

    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.

    ERROR : Invalid byte 1 of 1-byte UTF-8 sequence

    in Products

    Posted

    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.

    iReport page footer problem

    in Products

    Posted

    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

×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore