philt Posted January 23, 2012 Share Posted January 23, 2012 I have a fairly simple report and when I run the query it returns data but when I go to preveiw the report it just goes to a blank screen thinks for 20 seconds or so and returns back to desighn view. I have this a lot but have not figured out a pattern accept I might be causing an issue with groups by something I am doing wrong. here is the query..SELECT feed.`MMID` AS feed_MMID, feed.`Question` AS feed_Question, feed.`Answer` AS feed_Answer, feed.`Trigger` AS feed_Trigger, Demographics.`MMID` AS Demographics_MMID, Demographics.`First` AS Demographics_First, Demographics.`Last` AS Demographics_Last, Demographics.`Phone` AS Demographics_Phone, Demographics.`Email` AS Demographics_EmailFROM `feed` feed INNER JOIN `Demographics` Demographics ON feed.`MMID` = Demographics.`MMID`GROUP BY feed_MMID Link to comment Share on other sites More sharing options...
mwatkinson Posted January 25, 2012 Share Posted January 25, 2012 I would need to see your report XML (in the designer click the XML tab between designer and preview) to better understand the issue.Is there an error occuring at all in the IReport console from the iReport output tab? Link to comment Share on other sites More sharing options...
synchro Posted January 26, 2012 Share Posted January 26, 2012 I've got the same thing happening. My query works fine, the report runs (and asks me for input values), it waits for a bit, then flips back to design view. My JDBC connection works fine when I test it, and nothing is shown in the 'report problems' window. In the IDE log console I get various different things: Charset used: UTF-8!!!!Prop3: net.sf.jasperreports.xpath.executer.factory: net.sf.jasperreports.engine.util.xml.JaxenXPathExecuterFactoryMissing resouce key: language.sqlMissing resouce key: language.SQLMissing resouce key: language.xPathMissing resouce key: language.XPathMissing resouce key: language.mdxMissing resouce key: language.MDXMissing resouce key: language.ejbqlMissing resouce key: language.EJBQLMissing resouce key: language.xmla-mdxMissing resouce key: language.xpath2Missing resouce key: language.jsonMissing resouce key: language.JSONMissing resouce key: language.plsqlMissing resouce key: language.HiveQLMissing resouce key: language.sqlMissing resouce key: language.SQLMissing resouce key: language.xPathMissing resouce key: language.XPathMissing resouce key: language.mdxMissing resouce key: language.MDXMissing resouce key: language.ejbqlMissing resouce key: language.EJBQLMissing resouce key: language.xmla-mdxMissing resouce key: language.xpath2Missing resouce key: language.jsonMissing resouce key: language.JSONMissing resouce key: language.plsqlMissing resouce key: language.HiveQLMissing resouce key: language.sqlMissing resouce key: language.SQLMissing resouce key: language.xPathMissing resouce key: language.XPathMissing resouce key: language.mdxMissing resouce key: language.MDXMissing resouce key: language.ejbqlMissing resouce key: language.EJBQLMissing resouce key: language.xmla-mdxMissing resouce key: language.xpath2Missing resouce key: language.jsonMissing resouce key: language.JSONMissing resouce key: language.plsqlMissing resouce key: language.HiveQLProp3: net.sf.jasperreports.xpath.executer.factory: net.sf.jasperreports.engine.util.xml.JaxenXPathExecuterFactory I'm running iReport 4.5 on OS X. Link to comment Share on other sites More sharing options...
philt Posted January 27, 2012 Author Share Posted January 27, 2012 Here is my xml code but I do not have anything showing up in my problems window. Link to comment Share on other sites More sharing options...
philt Posted January 28, 2012 Author Share Posted January 28, 2012 Okay I just found the report output window and found this information in it maybe it will help. Compiling to file... H:Ireportshratriggers.jasper Errors compiling H:Ireportshratriggers.jasper! Compilation exceptions: com.jaspersoft.ireport.designer.compiler.ErrorsCollector@58ba4bnet.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file:org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed:calculator_hratriggers_1327766868592_219424: 171: unexpected token: HRA @ line 171, column 22.1 error at net.sf.jasperreports.compilers.JRGroovyCompiler.compileUnits(JRGroovyCompiler.java:100) at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:188) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:212) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:128) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:516) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)Caused by: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed:calculator_hratriggers_1327766868592_219424: 171: unexpected token: HRA @ line 171, column 22.1 error at org.codehaus.groovy.control.ErrorCollector.failIfErrors(ErrorCollector.java:296) at org.codehaus.groovy.control.ErrorCollector.addFatalError(ErrorCollector.java:143) at org.codehaus.groovy.control.ErrorCollector.addError(ErrorCollector.java:113) at org.codehaus.groovy.control.ErrorCollector.addError(ErrorCollector.java:125) at org.codehaus.groovy.control.SourceUnit.addError(SourceUnit.java:337) at org.codehaus.groovy.antlr.AntlrParserPlugin.transformCSTIntoAST(AntlrParserPlugin.java:104) at org.codehaus.groovy.antlr.AntlrParserPlugin.parseCST(AntlrParserPlugin.java:71) at org.codehaus.groovy.control.SourceUnit.parse(SourceUnit.java:236) at org.codehaus.groovy.control.CompilationUnit$1.call(CompilationUnit.java:158) at org.codehaus.groovy.control.CompilationUnit.applyToSourceUnits(CompilationUnit.java:814) at org.codehaus.groovy.control.CompilationUnit.doPhaseOperation(CompilationUnit.java:511) at org.codehaus.groovy.control.CompilationUnit.processPhaseOperations(CompilationUnit.java:487) at org.codehaus.groovy.control.CompilationUnit.compile(CompilationUnit.java:464) at net.sf.jasperreports.compilers.JRGroovyCompiler.compileUnits(JRGroovyCompiler.java:96) ... 6 more Link to comment Share on other sites More sharing options...
philt Posted January 28, 2012 Author Share Posted January 28, 2012 The issue with this report has been found I used a text box as a title instead of the static text label. I found this after I switched the report language to Java. Link to comment Share on other sites More sharing options...
lschofield Posted March 8, 2013 Share Posted March 8, 2013 I'm having this as well, seems to be pointing to some resource file missing or not being in the right place. Comment below seems unrelated. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now