philt

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.

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@58ba4b net.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

Here is my xml code but I do not have anything showing up in my problems window.

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_Email FROM `feed` feed INNER JOIN `Demographics` Demographics ON feed.`MMID` = Demographics.`MMID` GROUP BY feed_MMID

Okay I bought the book and tried for hours to get this working. I have a report called trig1 which attaches to a mysql table and I am checking for rows with a value of '1' in a 'Trigger' field. SELECT feed.`Question` AS feed_Question, feed.`Answer` AS feed_Answer, feed.`Trigger` AS feed_Trigger, feed.`MMID` AS feed_MMID FROM `feed` feed WHERE feed.`Trigger` = 1 GROUP BY feed_MMID The subreport has a parrameter called EXTID SELECT Demographics.`MMID` AS Demographics_MMID, Demographics.`First` AS Demographics_First, Demographics.`Last` AS Demographics_Last, Demographics.`Email` AS Demographics_Email, Demographics.`Phone` AS Demographics_Phone FROM `Demographics` Demographics WHERE Demographics.`MMID` =$P{EXTID} Each report returns data by itself when I manually pass it a parameter. but put the two togeather and when you press preview it thinks and then comes back to the design window no explanation