[Help! Division does not work in Variable Expression]

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

["Pattern" set in iReport 4.1.1 not honored when JRXML run in 4.1.0]

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!)

["Pattern" set in iReport 4.1.1 not honored when JRXML run in 4.1.0]

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)">

[Determining when report is being exported to _________]

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!!!

 

[Drilldown Hyperlink Reference Expression setup in iReport 4.1.1 deployed on jasperserver 4.1.0]

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.

[SQL Server Stored Procs - perhaps I am slow]

bump for corrections ...please help!

 

Thanks

[SQL Server Stored Procs - perhaps I am slow]

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

[MySQL JDBC connections fail on LINUX, work on WIN?]

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 (linux client)?]

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?

[prevent viewing sub and drill to reports directly?]

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!

[two instances sharing repository?]

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

[Row level security - Authorization issue]

perfect - thank you

[Row level security - Authorization issue]

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.

[Rectangle not rendering]

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

[Row level security - Authorization issue]

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!

[Row level security - Authorization issue]

I need to restrict users to a specfic organization_id (an integer key).

 

I do not mind joining from the fact table to a row level security table that associates user ids with an organization_id - is it simple to pickup up the JS user id as a parameter?

 

Thanks!

[Three Tier JS deployment?]

Is there a straight-forward way of implementing a 3 tier architecture using the default app - two instances, one handling the presentation inside a dmz and one doing the lifting on an internal network? The databases would obviuosly be inside as well.

 

How would one do this?

 

Thanks!

Post edited by: dogfuel, at: 2008/01/12 02:17

[Active Directory]

Has anyone succeeded integrated JS 2.1 and AD? Are there any specific instructions for ding so?

Thanks!

[MySQL Dates and Calendar Input Contol]

nothing is wrong in JasperServer - didn't mean to sound critical.

 

The Calendar control in JasperServer returns a date in a java format that MySQL cannot use without reformatting - iReport's calendar prompt returns a date that does work with MySQL.

 

The question can be rephrased as "what is the cleanest way to use a JS 2.01 Calendar control as a prompt for a report on a MySQL source?"

 

thanks

[MySQL Dates and Calendar Input Contol]

What is the best practice for dealing with the 'feature' that returns dates from the Calendar Java-style (and, if it is intentonal, why does iReport handle it differently than JasperServer)?

 

I assume handling this in SQL as some suggested is really bad for performance.

 

Do I set a default parameter value that converts? Can/do I create a variable that converts the prompt value and se the variable in the report (and are things calculated in a sequence that allows this)?

 

Is there a step by step guide to dealing with this (for dummies. like me)?

 

Thanks

[Jasper Server with huge data]

Thanks - explains the (consistently acceptable) experience I've seen in my limited experience.

[Jasper Server with huge data]

Are you using Jasper to serve up large data sets for further analysis?

 

I'm hitting tens of millions of records with no problems but am only returning and reporting relatively few rows (either a subset or an aggregation).

 

I am considering using JS to return large sets that we currently generate and ftp and so would like to know.

 

Thanks

Post edited by: dogfuel, at: 2007/10/23 01:10

[(possibly unpopular) suggestion]

see my post at the other place ...

http://forums.pentaho.org/showthread.php?p=172043#post172043

 

JasperReports and iReport dominate the opensource reporting world for good reason - great product!

Post edited by: dogfuel, at: 2007/10/20 22:24

[Professional Services???]

I'm seeking professional help (in many personal areas but also with JasperServer) ...

 

Does anyone out there have experience with JS's professional services or with ind consultants with JasperServer expertise?

 

Does JasperSoft provide Prof Services on the Open Source versions?

 

Thanks -

[must be missing the obvious ...]

Trying to use the JasperServer calendar prompt with a MySql database. I have tried using a second string prompt in my query with no prompt for it and a default of:

 

Code:

new SimpleDateFormat("yyyy-MM-dd"«»).format($P{JavaDteFrom})

 

My report displays with "no data ..." in both iReport and through JasperServer.

 

Am I missing something obvious?

 

Thanks!