rasinc

Thanks bigalex. However, I am getting weird errors. When I have the report language set to Java as I understand I should when using Fishbowl Inventory, I am getting the error when running the report directly in iReport. The operator < is undefined for the arguement type(s) BigDecimal, double. I get other errors when it is set up as javascript. I can't believe how frustrated I am with this language but I expect that I am just missing some bit of logic.

Based on some research, it appears the typical method of showing negative numbers as red is to setup a conditional style. I have a variable in a group footer that calculates inventory availability. I set up a style with the expression $V{Available}<0.00 and red as the forecolour (255,0,0). However, when I run the report, the style doesn't change the forecolour. I'm not sure what to do to get this to work, or is this the correct approach? TIA, rasinc.

I am having a problem uploading a report to Fishbowl. The wizard goes through to the end and refreshes the list but when I open the report folder, I don't see the report. When I look in the Report table, it is not there. However, I have been able to upload a simple customer list report. The one that worked was language Javascript, the other was Java so I switched it to Javascript but that didn't change the upload problem. I've checked all the report settings I can think of. Does anyone know what might be the cause of the problem? TIA, rasinc.

Thank you for the help and direction luked. You helped me understand the math and syntax a little better. Final answer is: BigDecimal.valueOf($F{QTYONHAND}).subtract($V{qtyToFulfill_1})

Thanks for the reply. I added the formula to the Variable Expression and double-checked that I had set everything to BigDecimal and now I get the error The method valueOf(long, int) in the type BigDecimal is not applicable for the arguments (BigDecimal) The express is $F{QTYONHAND}.subtract(BigDecimal.valueOf($V{qtyToFulfill_1})) and put the variable in the group footer. QTYONHAND is showing as a double in the field list in the expression editor. Any ideas what else I can try?

I have an inventory-type report grouped by PartId. There is a total of the QtyToFulfill column for each group. I want to subtract the total of the QtyToFulfill (BigDecimal) from the QtyOnHand (Double) field. I've tried $F{QTYONHAND}.subtract($V{qtyToFulfill_1}) and $F{QTYONHAND}.subtract($V{qtyToFulfill_1}.DoubleValue()) I am sure it has to do with the datatype but I don't know the correct syntax. Can someone give me a hand figuring this out? TIA rasinc.