dizou

Ok, so how would I create a drill down that will work in iReport?

I have two reports: Summary and Detail. They are both located in the same directory and I am trying to do this stuff in iReport 5.0.1. I am trying to make a field in my Summary report so that I can click on it and it will run and show the detail report. The field is: $F{reason_id}. In the Summary report I created a hyperlink in one of my fields like so: Hyperlink target: Self Hyperlink type: ReportExecution In my Link parameters I have the parameters: _report: detail reason_id: $F{reason_id} start_date: $P{start_date} end_date: $P{end_date} When I click Preview in my summary report, I enter all my parameters, then I get this error: Error filling print... Error evaluating expression : Source text : detail net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : detail at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:203) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:591) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:559) at net.sf.jasperreports.engine.fill.JRFillHyperlinkHelper.evaluateHyperlinkParameters(JRFillHyperlinkHelper.java:82) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:504) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:431) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:259) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:459) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2044) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:778) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:288) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:151) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:909) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: groovy.lang.MissingPropertyException: No such property: nrt_detail for class: Sample_1362063546538_723686 at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.unwrap(ScriptBytecodeAdapter.java:49) at org.codehaus.groovy.runtime.callsite.GetEffectivePogoPropertySite.getProperty(GetEffectivePogoPropertySite.java:86) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callGroovyObjectGetProperty(AbstractCallSite.java:239) at Sample_1362063546538_723686.evaluate(calculator_Sample_1362063546538_723686:229) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:190) ... 20 more Print not filled. Try to use an EmptyDataSource... What is going on here and how do I fix it?

Thanks!

I figured it out, see my edit.

I am using iReport 5.0.1. I created a date parameter and am using it in my query: When I preview the report, I enter my date parameter: After I enter all the parameters and run the report, I get this error: Error filling print... Error executing SQL statement for : Sample net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Sample at com.jaspersoft.jrx.query.PlSqlQueryExecuter.createDatasource(PlSqlQueryExecuter.java:143) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1086) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:667) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1258) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "Feb" at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254) at com.jaspersoft.jrx.query.PlSqlQueryExecuter.createDatasource(PlSqlQueryExecuter.java:136) ... 12 more Print not filled. Try to use an EmptyDataSource... What is going on here, and how do I fix this? Thanks! Edit: I figured it out. I had to change the $P!{start_date} to $P{start_date}

I have Jasperserver setup and I am currently using it to generate and view my reports. I have a website built using Django. I would like to use this website ot run and generate reports. How would I go about integrating these two? Thanks!

I had something backwards in my hosts file. Thanks!

@mrcaffeine I added the installation.log file in my /opt/jasperreports-server-5.0.1/ directory. Do you want the bitrock_installer.log file as well?

I downloaded the Jasper Reports Server installer for Linux. I am on CentOS 6. When I run the installer, at the very end I get this error: I opened the bitrock_installer.log file in my /tmp directory and this was at the verry end: What's going on here? Can I ignore this error? If not, how do I fix it? Thanks! Edit: So I found that this may be realted to my hostname not set correctly. I originally had my /etc/hosts file like this: The installation failed with this. I then changed my /etc/hosts file to this: and the installation still failed with the same error mesasge.