buzz-dee
-
Posts
10 -
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 buzz-dee
-
-
I can't find any information in that thread about a return value, that I can pass back to the main report. Can I access a subdataset field from a e.g. a list directly in the main report?
-
I have a subreport with a variable $V{euroAllCommission} (Calculation: None, Increment type: None, Reset type: None) with the following expression:
$V{euroOriginCommission} != null && $V{euroCommission} != null
? $V{euroOriginCommission} + $V{euroCommission}
: $V{euroOriginCommission} != null
? $V{euroOriginCommission}
: $V{euroCommission} != null
? $V{euroCommission}
: null
The subreport is set to return the variable "euroAllCommission" to the main report variable "euroFollowOnCommission" (Calculation: None, Increment type: None, Reset type: Report) with "Calculation type: Nothing". The subreport complies fine. but if I want to compile the main report with the containing subreport I get the following error.:
net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Source variable euroAllCommission not found for return value euroFollowOnCommission.
at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:467)
at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$18(ReportControler.java:442)
at com.jaspersoft.studio.editor.preview.view.control.ReportControler$4.run(ReportControler.java:334)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Caused by: net.sf.jasperreports.engine.JRException: Source variable euroAllCommission not found for return value euroFollowOnCommission.
at net.sf.jasperreports.engine.fill.FillReturnValues.checkReturnValues(FillReturnValues.java:281)
at net.sf.jasperreports.engine.fill.JRFillSubreport.validateReport(JRFillSubreport.java:952)
at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:421)
at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:307)
at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:259)
at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:456)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2067)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:788)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:298)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:152)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:963)
at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:120)
at java.lang.Thread.run(Unknown Source)
How can I get the subreport return value to the main report?
-
I updated my question, please see again.
-
Is there a variable nesting depth limit in iReport, Jaspersoft Studio etc.?
I have text field with the following content.:
( $F{tckopf_R_ART}.equals( "1" ) && $V{euroFollowOnCommission} != null )? $V{charterEuroWorth} + $V{euroFollowOnCommission}: ( $F{tckopf_R_ART}.equals( "2" ) && $V{euroFollowOnCommission} != null )? $V{charterEuroWorth} + $V{euroFollowOnCommission}: ( $F{tckopf_R_ART}.equals( "1" ) && $V{euroFollowOnCommission} == null )? $V{charterEuroWorth}: ( $F{tckopf_R_ART}.equals( "2" ) && $V{euroFollowOnCommission} == null )? $V{charterEuroWorth}: null[/code]
where are "charterEuroWorth" and "euroFollowOnCommission" variables are sum calculazions from 2 different subperiods.
If I put above code to a new variable in the main report, I get "null" in the text field on the main report. I need to put it in variable in the main report, because also need to calculate the sum value from the above code for every record in the main report.
I don't know how, I can achieve it. Maybe there is a problem with the variable properties? Please let me know, if you need further information.
How can I calculate the sum value from the above code for every record in the main report?
-
Already tried that, that does not solve the problem.
-
Already tried that, that does not solve the problem.
-
I have a main report with 3 subreports in the detail band of the main report. I return a value from one subreport to the main report. I also need this return value in the 2 other subreports, so I pass the value to the subreports as parameter.
The problem that the value is null in the subreports. If I use the value on a text field that "Evalution Time" is set to "Auto" in the main report, I can use the value.
How can I also pass / use the value in the subreports?
-
I know that it is possible to get a return value from a subreport to the main report in iReport. Also there are subdatasets which can also have an own SQL query like a subreport. As I understand a subdataset can only be used with list, charts etc., but I don't know how to access the subdataset fields, variables and parameters in the main dataset/report.
Is it also possible to get a return value from a subdataset? If not, how is it possible to access values from the subdataset?
-
The file extension is .log and not .txt
REturning a sum variable from subreport
in Products
Posted