Jasper iReports and conditional statement in field expression
Say, I want to padd the Integer CurrentInvNo with one or two leading zeros. This doesn't work. Any ideas?
$F{AccNo}+iif(F${CurrentIn
$F{AccNo}+iif(F${CurrentIn
ASKER
Jasper won't complie this statement.
Compiling to file... C:\Documents and Settings\admin\My Documents\Voip SW\iReports\Savings Analysis Report & Management Invoice.jasper
Errors compiling C:\Documents and Settings\admin\My Documents\Voip SW\iReports\Savings Analysis Report & Management Invoice.jasper!
Compilation exceptions: co
Compilation running time: 1,329
Compiling to file... C:\Documents and Settings\admin\My Documents\Voip SW\iReports\Savings Analysis Report & Management Invoice.jasper
Errors compiling C:\Documents and Settings\admin\My Documents\Voip SW\iReports\Savings Analysis Report & Management Invoice.jasper!
Compilation exceptions: co
Compilation running time: 1,329
OK. In the middle of all of that, I see
unexpected token: F @ line 191, column 181
Meanwhile, looking at your code again, I noticed another apparent problem. After the first iif you have F${CurrentInvNo}, but in other places in the line, you have $F.
Still just guessing here, but maybe the error on token "F" is because you have F$ in that one spot, instead of $F. Or possibly it's the other way around, and each $F should be F$ . Either way, I'm guessing that they should all be the same.
James
unexpected token: F @ line 191, column 181
Meanwhile, looking at your code again, I noticed another apparent problem. After the first iif you have F${CurrentInvNo}, but in other places in the line, you have $F.
Still just guessing here, but maybe the error on token "F" is because you have F$ in that one spot, instead of $F. Or possibly it's the other way around, and each $F should be F$ . Either way, I'm guessing that they should all be the same.
James
ASKER
Good point but not. I'm trying to find if Jasper support iif and what correct syntax is....
Compiling to file... C:\Documents and Settings\admin\My Documents\Voip SW\iReports\Savings Analysis Report & Management Invoice.jasper
Compilation running time: 2,640!
Filling report...
Locale: English (South Africa)
Time zone: Default
Error filling print... Err
net.sf.jasperreports.engin
Print not filled. Try to use an EmptyDataSource...
Compiling to file... C:\Documents and Settings\admin\My Documents\Voip SW\iReports\Savings Analysis Report & Management Invoice.jasper
Compilation running time: 2,640!
Filling report...
Locale: English (South Africa)
Time zone: Default
Error filling print... Err
net.sf.jasperreports.engin
Print not filled. Try to use an EmptyDataSource...
> Good point but not. I'm trying to find if Jasper
> support iif and what correct syntax is....
Oh well. It was a shot in the dark, although I really did think I might be on to something.
I've looked around jasperforge.org some, but haven't been able to find specific documentation on "formulas" like that (which I suppose may be your problem). If the underlying language is Java, then maybe that's really where you need to be looking to see if anything like iif is supported.
FWIW, looking at one of the Jasper examples, I see the following, which looks kind of similar to your line:
"There are " + String.valueOf($V{REPORT_C
Maybe DecimalFormat is what you need to be looking at, in order to format CurrentInvNo to "000". Still just making guesses. :-)
The Jasper example that I was looking at is FirstJasper.jrxml . If it's included in the Jasper "package", then you may already have it, but I found it on:
http://jasperforge.org/website/jasperreportswebsite/trunk/samples.html?group_id=252
James
> support iif and what correct syntax is....
Oh well. It was a shot in the dark, although I really did think I might be on to something.
I've looked around jasperforge.org some, but haven't been able to find specific documentation on "formulas" like that (which I suppose may be your problem). If the underlying language is Java, then maybe that's really where you need to be looking to see if anything like iif is supported.
FWIW, looking at one of the Jasper examples, I see the following, which looks kind of similar to your line:
"There are " + String.valueOf($V{REPORT_C
Maybe DecimalFormat is what you need to be looking at, in order to format CurrentInvNo to "000". Still just making guesses. :-)
The Jasper example that I was looking at is FirstJasper.jrxml . If it's included in the Jasper "package", then you may already have it, but I found it on:
http://jasperforge.org/website/jasperreportswebsite/trunk/samples.html?group_id=252
James
ASKER
Tx 4 the effort, however the decimal point will look out of place as need Invoice NO: 013 for example.
Yes java could be the clue.... or someone who know iReports...
Yes java could be the clue.... or someone who know iReports...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tx. I did try but still not. Asking moderator.
Error filling print... Err
net.sf.jasperreports.engin
Print not filled. Try to use an EmptyDataSource...
Error filling print... Err
net.sf.jasperreports.engin
Print not filled. Try to use an EmptyDataSource...
ASKER
Still don't know if iif (,,) is valid in Jasper
Having said that, and with the disclaimer that I don't know the first thing about Jasper iReports, I do see one error in your formula.
The middle iif should read:
iif($F{CurrentInvNo} > 99,'','0')
Which would make the formula:
$F{AccNo}+iif(F${CurrentIn
If you were getting a leading 0 on 3 digit numbers, that was probably why.
I'm assuming that CurrentInvNo is always positive. If not, you'd need separate tests for negative values, or you could use an absolute value function, if there is one, when testing the values.
James