hondaman900

@hozawa, that doesn't seem to work. I have the same issue, where one field has a psecific text or another field is zero, then don't print. The following experssion prints all the time: !$F{expense_category}.equals("Home Rent") || $F{expense_amount}.compareTo(BigDecimal.ZERO) != 0 Suggestions?

Thanks for the reply. However, setting all the fields and labels in the details band to float position, still leaves a blank space when the print-when-experssion evaluation is false and therefore not displayed. The other fields don't close the gap.

I have a report using Free Layout where each field from the record is laid out on the page, and there is only one record per report, so the details band doesn't repeat over multiple records. I'm familiar with setting Print When Expression to hide a line item when a field is blank, but in this case, because all fields have their own layout positions, making a field not display when blank leaves a visible gap in my page. I want the other fields to move to close up the gap and reatain a grid without blank spaces. Does anyone have a solution for this? I'm using Jaspersoft Studio 6.6

Hi Gaby, Did you ever resolve this? I'm in the same boat where I have a variable displaying a correct number per row in a group, and another variable in the footer of the group set to simply sum the line variable with reset type group. The summary result is wrong and I've literally spent a week going over this and can't find the reason why it's giving a wrong answer. It's not a rounding or missing number, just a significantly different one. The correct result is -$50,166 and the missing 3,644 is not related to anything I can find. Any info on what you ended up doing to resolve this would be very helpful. Thanks in advance.

This worked for me after many hours not finding any hint of what could be causig this error - many thanks.

I found this post very helpful, but the total is not summing correctly if the subreports extend apst the page. I.e., I have 5 subreports, and if they all fit on the first page I get a correct result, but if they push into a new page, I don't get those that are on the next page summed into the grand total. I have adjusted the grand_total evaluation time parameter, but can't find one that waits until the report is completed to summ the result. Any suggestions?

I have a query that works well, but I get syntax errors when I try to add an ORDER BY clause to sort on a value column for each table before joining it. I know I can use the designer and subreport bands to achieve what I want, but the subreports introduce formatting (padding between sections) that I can't remove and can't have in the report, so handling the data in the Query allows for correct formatting and easier summing of the values in each section. Just need the line items ranked by value. Here's the query: SELECT "ASSETS & INVESTMENTS", "Monetary Assets" , ma.created_by_id, ma.monetary_asset_name, ma.monetary_asset_type, ma.monetary_asset_value Asset_Value, ma.monetary_statement_date FROM forge.monetary_assets as maWHERE ma.created_by_id = $P{user_id} AND ma.monetary_ownership_type = 'Yours' UNION ALLSELECT "ASSETS & INVESTMENTS", "Investments", il.created_by_id, il.investment_name, ia.investment_account_type, il.investment_sale_price_fmv Asset_Value, ia.investment_last_statement_date FROM forge.investment_line_items as ilJOIN forge.investment_accounts as iaON ia.id = il.investment_institution_name_idWHERE il.created_by_id = $P{user_id} AND ia.investment_ownership = 'Yours' UNION ALLSELECT "ASSETS & INVESTMENTS", "Real Estate", ra.created_by_id, ra.real_name, ra.real_type, ra.real_current_value Asset_Value, ra.real_last_appraisal_date FROM forge.real_property_assets as raWHERE ra.created_by_id = $P{user_id} AND ra.real_asset_ownership = 'Yours' UNION ALLSELECT "ASSETS & INVESTMENTS", "Personal Property", pa.created_by_id, pa.personal_name, pa.personal_type, pa.personal_current_value Asset_Value, pa.personal_last_appraised_date FROM forge.personal_property_assets as paWHERE pa.created_by_id = $P{user_id} AND pa.personal_ownership = 'Yours'UNION ALLSELECT "INSTALLMENT DEBT, MORTGAGES & OTHER LIABILITIES", "Mortgages & Real Estate Debt", ra.created_by_id, ra.real_name, ra.real_type, -ABS(ra.real_amount_owed) Asset_Value, ra.real_last_appraisal_date FROM forge.real_property_assets as raWHERE ra.created_by_id = $P{user_id} AND ra.real_asset_ownership = 'Yours' UNION ALLSELECT "INSTALLMENT DEBT, MORTGAGES & OTHER LIABILITIES", "Installments Debts Liabilities" , idl.created_by_id, idl.liability_name, idl.liability_paid_for, -ABS(idl.liability_account_balance) Asset_Value, idl.liability_last_payment_date FROM forge.installments_debts_liabilities as idlWHERE idl.created_by_id = $P{user_id} AND idl.liability_ownership = 'Yours' UNION ALLSELECT "INSTALLMENT DEBT, MORTGAGES & OTHER LIABILITIES", "Attorney Fees", af.created_by_id, af.attorney_name, af.attorney_bill_status, -ABS(af.attorney_amount) Asset_Value, af.attorney_payment_date FROM forge.attorney_fees as afWHERE af.created_by_id = $P{user_id} AND af.attorney_fee_ownership = 'Yours' [/code]That gives me a nice report, but I want to rank the line items per group in DESC order. I can add an ORDER BY Asset_Value DESC clause to the end of the query, and I do get all line items ranked by value, but the organization of the groups get's messed up. I need to rank by value within each group, maintaining the grouping. In straight SQL I could do this in each SELECT statement using TOP, but this gives a syntax error in Studio. Anyone have a solution to this please? Here's the report output from the above query: Thanks in advance

I had to install the full JasperSoft Studio v. 6.6 to get my reports done, but the issue still stands - why the error compiling reports to a compatability prior version?

I have JasperSoft Studios, a new install on a new laptio (v. 6.15). I set up the compatability configuration to compile to v. 6.6. In the settings I have it saving the jrxml files to version 6.5.1 only because there's no 6.6 option offered. I can't determine from the error how to fix the issue, but am guessing the issue is between the default version 6.5.1 and the compile version 6.6? I don't know how to resolve this as there is no 6.6 version available for the default workspace and I need to compile to 6.6 for backward compatability on this project. Any suggestions? When I compile my reports now I get an exception error: java.lang.RuntimeException: java.lang.NoClassDefFoundError: Could not initialize class net.sf.jasperreports.engine.DefaultJasperReportsContext at net.sf.jasperreports.eclipse.builder.JasperReportCompiler.compileReport(JasperReportCompiler.java:131) at net.sf.jasperreports.eclipse.builder.JasperReportsBuilder.compileJRXML(JasperReportsBuilder.java:212) at com.jaspersoft.studio.editor.action.CompileAction.actionCompile(CompileAction.java:154) at com.jaspersoft.studio.editor.action.CompileAction$1.run(CompileAction.java:98) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)Caused by: java.lang.NoClassDefFoundError: Could not initialize class net.sf.jasperreports.engine.DefaultJasperReportsContext at net.sf.jasperreports.engine.JasperCompileManager.getDefaultInstance(JasperCompileManager.java:200) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at net.sf.jasperreports.eclipse.builder.JasperReportCompiler.compileReport(JasperReportCompiler.java:106) ... 4 more[/code] This is my compatability properties screen: My JasperReports versions manager: The error console output I get when trying to compile the report:

Anyone...? I know it's been a long time, but my work on this project brings me back to the same issue. The source is `` <variable name="mon_total" class="java.math.BigDecimal"/> <variable name="liabilities_totals" class="java.math.BigDecimal"/> <variable name="net_worth" class="java.math.BigDecimal" resetType="Page" calculation="Sum"> <variableExpression><![CDATA[$V{mon_total}.subtract($V{liabilities_totals})]]></variableExpression> </variable>`` I can't figure out why this doesn't work?? Any suggestions???

Lisay_1's answer worked for me - thank you VERY much!! I ran into a subsequent timezone error that's apparently related to versions of the driver, giving the following error: The server time zone value 'PDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specific time zone value if you want to utilize time zone support.[/code]Simply follow the solution here: https://stackoverflow.com/questions/26515700/mysql-jdbc-driver-5-1-33-time-zone-issue[/code]Hope this helps someone else.

Simmtechnology is correct, also the correct way for Windows - this should be listed as an answer. Just Shift+Enter doesn't work in Windows.

I have subreports that return and display values in variables in the main report. I have a third variable that subtracts one variable from the other to give a result, but it always gives "null". I have tried all permutations of evaluation time for each variables, and can get the results from the subreports to display no problem but always get null when doing math on them. My subreports and variables are all in the summary band. The variable doing the math expression is the last item. The expression that always gives "null" is: $V{mon_total}.subtract($V{liabilities_totals})[/code]where $V{mon_total}[/code]and $V{liabilities_totals}[/code]are the variables that get and display the return values from thre sub reports. Any suggestions where to look next for a solution....?

As per Sudeeps answer above, I was able to put a narrow rectangle with light-gray background color behind my repeating fields (right-click on it, then Order -> Send To Back) , and in the Print When Expression dialog, use his $V{REPORT_COUNT}%2==0[/code]expression to have it appear only on even rows - brilliant. I tried the earlier suggestion using a frame, but in Jaspersoft Studio (6.6) the band becomes a container for the fields and then making the band visible only on even rows hides the entire set of odd rows, so that doesn't work. Hopes this helps the next person looking fort this.

Is there a reference document that lists available math expressions and their usage?

I have several subreports and I can return and display values from each subreport, but need to display a result that is the addition of the returned values in a single variable. My variable expression adding the individual variables is as follows: $V{monetary_sub_sum}.add($V{personal_sub_sum}).add($V{invest_sub_sum}).add($V{real_sub_sum})[/code]The problem is that this returns "null". No errors, just no result. Since the individual variables show the returned values and display them in the same band in my report as I want to show this cumulative value, I'm not sure where to go next to resolve this. I'm using Jaspersoft Studio 6.6 Any suggestions?

Maarten's answer is correct except for one small issue. The calculation type should be no calculation, not "system". Using "system" resturns "null" as the value. Also try placing your main report receiving variable in a different band to the subreport. Hope this helps.

I get net.sf.jasperreports.engine.JRRuntimeException: Subreport overflowed on a band that does not support overflow[/code]when I put one subreport in the header and one in the footer. Full error details: net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRRuntimeException: Subreport overflowed on a band that does not support overflow. at com.jaspersoft.studio.editor.preview.view.control.ReportController.fillReport(ReportController.java:536) at com.jaspersoft.studio.editor.preview.view.control.ReportController.access$17(ReportController.java:511) at com.jaspersoft.studio.editor.preview.view.control.ReportController$1.run(ReportController.java:429) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:56)Caused by: net.sf.jasperreports.engine.JRRuntimeException: Subreport overflowed on a band that does not support overflow. at net.sf.jasperreports.engine.fill.FillerSubreportParent.addPage(FillerSubreportParent.java:140) at net.sf.jasperreports.engine.fill.JRBaseFiller.addPageToParent(JRBaseFiller.java:1426) at net.sf.jasperreports.engine.fill.JRVerticalFiller.addPage(JRVerticalFiller.java:2184) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageBreak(JRVerticalFiller.java:2330) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBreak(JRVerticalFiller.java:2420) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:778) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:285) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:114) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:615) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:413) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:814) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:61) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)[/code]

I'm creating a main report with multiple subreports in Studio 6.6. I place each subreport in it's own details band. The subreports use the same dataset as the main report. However every time I try this I end up with multiple (hundreds of) pages of the same subreports (in Preview). In researching this issue I read elsewhere that if you put the subreports into the details section, then the main report repeats the subreports over for each record in the dataset, but that's not the results I see in the docs or tutorials on creating subreports. And when I do place the subreports in other sections of the main report, as the posts suggest, the other bands can't accommodate data run-on so it throws and error and that doesn't work. It seems that subreports should work in the details section of the main report. The individual subreports preview fine, but the main report renders hundreds of copies of the same pages. Any and all help is very much appreciated. Here's the source for my main report: <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.6.0.final using JasperReports Library version 6.6.0 --><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Master Your Assets" pageWidth="612" pageHeight="792" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="0bcccaeb-190d-436b-bcc1-49e5e712b56f"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="DS_SEP_PROP"/> <queryString language="SQL"> <![CDATA[select m.monetary_asset_name, m.monetary_asset_type, m.monetary_asset_value, p.personal_type, p.personal_name, p.personal_current_value, r.real_type, r.real_name, r.real_current_value from dstest.monetary_assets as m JOIN dstest.personal_property_assets as p ON m.created_by_id =p.created_by_idJOIN dstest.real_property_assets as r ON r.created_by_id = p.created_by_id]]> </queryString> <field name="monetary_asset_name" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="monetary_asset_name"/> <property name="com.jaspersoft.studio.field.tree.path" value="monetary_assets"/> </field> <field name="monetary_asset_type" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="monetary_asset_type"/> <property name="com.jaspersoft.studio.field.tree.path" value="monetary_assets"/> </field> <field name="monetary_asset_value" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.label" value="monetary_asset_value"/> <property name="com.jaspersoft.studio.field.tree.path" value="monetary_assets"/> </field> <field name="personal_type" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="personal_type"/> <property name="com.jaspersoft.studio.field.tree.path" value="personal_property_assets"/> </field> <field name="personal_name" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="personal_name"/> <property name="com.jaspersoft.studio.field.tree.path" value="personal_property_assets"/> </field> <field name="personal_current_value" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.label" value="personal_current_value"/> <property name="com.jaspersoft.studio.field.tree.path" value="personal_property_assets"/> </field> <field name="real_type" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="real_type"/> <property name="com.jaspersoft.studio.field.tree.path" value="real_property_assets"/> </field> <field name="real_name" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="real_name"/> <property name="com.jaspersoft.studio.field.tree.path" value="real_property_assets"/> </field> <field name="real_current_value" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.label" value="real_current_value"/> <property name="com.jaspersoft.studio.field.tree.path" value="real_property_assets"/> </field> <background> <band splitType="Stretch"/> </background> <title> <band height="108" splitType="Stretch"> <rectangle> <reportElement x="0" y="50" width="572" height="50" forecolor="rgba(0, 0, 0, 0.0)" backcolor="#36AAD1" uuid="04a4185b-cfdb-462c-aef2-43a0b1336c7b"/> </rectangle> <image> <reportElement x="0" y="40" width="572" height="50" uuid="ef2ac753-c9d2-48bd-a5ca-ca74d1ff5feb"/> <imageExpression><![CDATA["C:/Users/Stephen/Documents/Projects/DivSplit/largeLogoDropped2.png"]]></imageExpression> </image> <staticText> <reportElement x="0" y="0" width="572" height="50" uuid="bec23f9b-a42f-40f7-bb67-a7c583ecc834"/> <textElement verticalAlignment="Middle"> <font size="36" isBold="true"/> </textElement> <text><![CDATA[Your Assets Summary Statement]]></text> </staticText> </band> </title> <pageHeader> <band height="297"> <subreport overflowType="Stretch"> <reportElement stretchType="ElementGroupHeight" isPrintRepeatedValues="false" x="0" y="0" width="572" height="110" isPrintInFirstWholeBand="true" uuid="87e2a767-35e6-4ccb-aa43-e8bf5a0252a4"/> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression><![CDATA["monetary_sub.jasper"]]></subreportExpression> </subreport> </band> </pageHeader> <pageFooter> <band height="233"> <subreport> <reportElement positionType="Float" stretchType="ElementGroupHeight" x="0" y="10" width="572" height="163" uuid="32bafcd9-de14-4d2e-97e7-2f9ac9b9f59f"/> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression><![CDATA["personal_sub.jasper"]]></subreportExpression> </subreport> </band> </pageFooter></jasperReport>[/code]And here's the source for one of the subreports (the other is identical just diffreent table/records: <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.6.0.final using JasperReports Library version 6.6.0 --><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="monetary_sub" pageWidth="572" pageHeight="792" columnWidth="532" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="bb290549-1052-4b30-b357-f1f91a01ee62"> <property name="com.jaspersoft.studio.data.sql.tables"> <![CDATA[ZHN0ZXN0Lm1vbmV0YXJ5X2Fzc2V0cyBBUyAsMTE4LDI1NCxiM2FhNzY2OS1lY2E0LTQwNTEtYTQ2Mi1mZTU5ZGNkOTUzZGI7]]> </property> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="DS_SEP_PROP"/> <property name="com.jaspersoft.studio.unit." value="pixel"/> <property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/> <property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/> <property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/> <property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/> <queryString language="SQL"> <![CDATA[sELECT dstest.monetary_assets.monetary_asset_name, dstest.monetary_assets.monetary_asset_type, dstest.monetary_assets.monetary_asset_valueFROM dstest.monetary_assets]]> </queryString> <field name="monetary_asset_name" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="monetary_asset_name"/> <property name="com.jaspersoft.studio.field.tree.path" value="monetary_assets"/> </field> <field name="monetary_asset_type" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="monetary_asset_type"/> <property name="com.jaspersoft.studio.field.tree.path" value="monetary_assets"/> </field> <field name="monetary_asset_value" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.label" value="monetary_asset_value"/> <property name="com.jaspersoft.studio.field.tree.path" value="monetary_assets"/> </field> <variable name="monetary_total" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[$F{monetary_asset_value}]]></variableExpression> </variable> <columnHeader> <band height="23"> <staticText> <reportElement x="0" y="0" width="150" height="20" uuid="b86195e2-3969-4292-95f3-780559db3aab"/> <textElement verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[Asset Type]]></text> </staticText> <staticText> <reportElement x="150" y="0" width="190" height="20" uuid="4e45400a-7788-455c-a546-85595caafbea"/> <textElement verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[Asset Name]]></text> </staticText> <staticText> <reportElement x="340" y="0" width="192" height="20" uuid="72408582-ec57-44ff-8c55-7cef32d7acc9"/> <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[Current Value]]></text> </staticText> </band> </columnHeader> <detail> <band height="24" splitType="Stretch"> <textField> <reportElement x="0" y="0" width="150" height="20" uuid="bcc94e21-e109-4cec-9f98-544a849f43ca"/> <textFieldExpression><![CDATA[$F{monetary_asset_type}]]></textFieldExpression> </textField> <textField pattern="¤#,##0.###;¤(-#,##0.###)"> <reportElement x="342" y="0" width="190" height="20" uuid="6eccc86e-9ab5-4185-a727-2a85b580afd9"/> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA[$F{monetary_asset_value}]]></textFieldExpression> </textField> <textField> <reportElement x="150" y="2" width="192" height="20" uuid="4da71914-8d7e-42e0-9407-9d3a0e18ef07"/> <textFieldExpression><![CDATA[$F{monetary_asset_name}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="45" splitType="Stretch"> <textField pattern="¤#,##0.###;¤(-#,##0.###)"> <reportElement x="340" y="0" width="192" height="20" uuid="059f3cfa-0e32-4497-82d6-2d30cb16974f"/> <box> <topPen lineWidth="1.0" lineStyle="Double"/> <bottomPen lineWidth="1.0" lineStyle="Double"/> </box> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA[$V{monetary_total}]]></textFieldExpression> </textField> </band> </columnFooter></jasperReport>[/code]Hree's the SQL statement I use in th emain report to support the embedded subreports (though other simpler SQL statements have the same mulriple pages results): select m.monetary_asset_name, m.monetary_asset_type, m.monetary_asset_value, p.personal_type, p.personal_name, p.personal_current_value, r.real_type, r.real_name, r.real_current_value from dstest.monetary_assets as m JOIN dstest.personal_property_assets as p ON m.created_by_id =p.created_by_idJOIN dstest.real_property_assets as r ON r.created_by_id = p.created_by_id[/code]Any help/suggestions is very welcome as I'm completely stuck.