dogfuel

I'm stumped... addition, subtraction and multiplication work for me, but division does not. iReport Version is 4.1.1, Report Language is groovy variables $V{DirectHrs1_1} and $V{TotalHrs1_1} are java.math.BigDecimal and simply sum fields for a group. When defining a third variable, also java.math.BigDecimal, the expressions: $V{DirectHrs1_1} + $V{TotalHrs1_1 does work $V{DirectHrs1_1} - $V{TotalHrs1_1 does work $V{DirectHrs1_1} * $V{TotalHrs1_1 does work $V{DirectHrs1_1} / $V{TotalHrs1_1) does NOT work! With division, the report compiles, but does not fill with error: Compiling to file... C:UsersjbairdDocumentsTimesheetDetail.jasper Compilation running time: 332! Filling report... Locale: English (United States) Time zone: Default Error filling print... Error evaluating expression : Source text : $V{DirectHrs1_1} / $V{TotalHrs1_1} net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : $V{DirectHrs1_1} / $V{TotalHrs1_1} at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:203) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:589) at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:141) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:748) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:291) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:133) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:903) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:813) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:878) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: java.lang.ArithmeticException: Division undefined at java.math.BigDecimal.divide(Unknown Source) at org.codehaus.groovy.runtime.typehandling.BigDecimalMath.divideImpl(BigDecimalMath.java:66) at org.codehaus.groovy.runtime.dgmimpl.NumberNumberDiv$NumberNumber.invoke(NumberNumberDiv.java:320) at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52) at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40) at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.call(PogoMetaClassSite.java:54) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:124) at TimesheetSummary_1336422548811_243902.evaluate(calculator_TimesheetSummary_1336422548811_243902:255) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:190) ... 13 more Print not filled. Try to use an EmptyDataSource...

Code:Is no one else having this problem? It makes jasperserver unusable for our intended application. (had to reply in the code box due to forum issues that have been there for a few days... not a good indicator!)

Regardless of the pattern set in iReport, reports, when run in jasperserver, show the number formatted as it is returned by the query. Any thoughts or help on this? JRXML includes the below and seems correct. Thanks! Code:<textField pattern="#,##0;(#,##0)">

Is there a parameter from which I can determine the output viewer of a report being run or exported? I would like to hide certian bands with a "print when" if a report is being output to excel. thanks!!!

I'm struggling and cannot find any relative documentation or posts for the versions I am using.... I have uploaded a working subreport: /root/support/subreports/myrsub.jrxml with a Resource ID of mysub I have uploaded a working master report: /root/reports/mychart.jrxml with a Resource ID of mychart In iReport 4.1.1, a chart has a hyperlink: Hyperlink type is set to ReportExecution. to what do I set the Hyperlink Reference Expression? I understand the hyperlink will not work in iRepor, but even the hyperling tooltip will not show up. I am confused and have tried many pernutations of file name, path and Resource ID.

bump for corrections ...please help! Thanks

Hello - Using Sql Server stored procs as data provider, the below works: dbo.usp_RptComprehensiveLoadReport;1, '2009-Sep-20', '2009-Sep-24' When I try to pass in Jasper parameters for the date strings (as below), I cannot even retreive field in the query window dbo.usp_RptComprehensiveLoadReport;1, $P{string_BegDate}, $P{string_EndDate} does not work (defaults are valid).nor does: dbo.usp_RptComprehensiveLoadReport;1, '$P{string_BegDate}', '$P{string_EndDate}' Am I missing the obvious? Error is Token Parsing Error: Lexical Error at Line 1 Column 3. Encountered "0"(48), after :"\'2" Thanks! Post Edited by dogfuel at 09/27/2009 15:28

I am running js 3.1 - on Windows, I am able to make and test MySQL JDBC connections - on Debian, like connections fail the "test connection" button when set up and do not work. mysql-connector-java-3.1.12-bin.jar seems to be in the correct place and I do not see anything in the log files (I may be looking at the wrong log as I am not so good with TOMCAT) - Is there additional setup known to be needed on LINUX that is not needed on Windows? The test data JNDI connections work but the JDBC connections even to the test data seem disfunctional. Thanks in advance, J

Is it just me or does iReport not really work on LINUX? I does open but the navigation and ui are so compromised it is all but unusable (i.e. no resizing of windows). Same issues in 2.03, 2.04. iReport is a great tool - am I just limited to running it on a Widows pc?

I wonder this also - it is currently the reason we are not going with JasperServer Pro. Am I also missing the obvious workaround? I do not want business users wondering what the data sources, input controls and sub reports are. Any help greatly appreciated!

Hello - Any problem with two JasperServer instances sharing a repository? Though this seems like a good scale-out strategy, my need is a little different as the first instance is in a DMZ and can only access one specific db server inside our network. the second instance would be inside the inner firewall and would have access to many databases. users with roles that allow access to other databases will just know to log into the second instance of JasperServer. Related-I have had problems with the LINUX installer being unable to use a repository on anything but a local server - does anyone know if this has been fixed? Thanks

perfect - thank you

Is there a way I can call the LoggedInUser.getuserID() or .getUserEMAIL()? I would like to retrieve the user keys and/or user emails. Thanks.

I have a black and gray rectangle as the background of my column headers. If I export the report using PDF or excel, the rectangles show up correctly. However, when I run the report in the Jasper Server, the HTML version loses the rectangles. The column header background is white and the rectangles are not showing up. How can I make sure that the rectangles which server as column header background will show in the Jasper Server? Thanks Post edited by: dogfuel, at: 2008/02/08 22:10

I'll rephrase .... Is it possible to use the logged in JasperServer userid as a parameter in the report query (to constrain results to a subset of rows based on this id)? Thanks!