Jump to content
Changes to the Jaspersoft community edition download ×

hondaman900

Members
  • Posts

    20
  • Joined

  • Last visited

hondaman900's Achievements

Apprentice

Apprentice (3/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Collaborator Rare

Recent Badges

0

Reputation

  1. @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?
  2. 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.
  3. 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
  4. 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.
  5. This worked for me after many hours not finding any hint of what could be causig this error - many thanks.
  6. 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?
  7. 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
  8. 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?
  9. 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:
  10. 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???
  11. 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.
  12. Simmtechnology is correct, also the correct way for Windows - this should be listed as an answer. Just Shift+Enter doesn't work in Windows.
  13. 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....?
  14. 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.
  15. Is there a reference document that lists available math expressions and their usage?
×
×
  • Create New...