Jump to content

buzz-dee

Members
  • 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

  1. 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?

  2. 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?

  3. 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?

  4. 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?


×
×
  • Create New...