amartin_2

This did not directly fix it but it pointed me in the right direction . I do not have a "Windows" menu that I could find although I had a "Window" menu. Inside the "Window" menu there was none of the other options you mentioned but I did click "New Window" once I was in that menu and it actually loaded a fresh instance of Jaspersoft Studio with the outline frame restored. I didn't try this before because opening Jaspersoft fresh from the executable did not work so I assumed this wouldn't either. Thanks for pointing me in the right direction!

The outline window has disappeared from my workspace, I have checked every menu but can't figure out how to get it back. Can anyone help me? I was just starting to make some headway in learning how to use the program!

I have a variable that performs some math on some database fields. ($F{Price}.doubleValue()/$F{Price Qty}.doubleValue())*$F{Qty Sold} (($F{Reg Retail}.doubleValue()/$F{Reg Retail Unit}.doubleValue())-($F{Price}.doubleValue()/$F{Price Qty}.doubleValue()))*$F{Qty Sold} These variables perform perfectly and give me the values I need. The first tells me the price per unit of an item and multiplies it against the total sold to give me total sales for the unit. The second gives me the difference between the regular price and the discounted price and multiplies it against total sold to give me the markdown amount, or the amount the sale cost me. My problem occurs when I try to sum these variables in the Group Footers. I drag the variable into the footer and when the report runs it only shows me the last value of the calculation, but if I drag a field into the Group Footer band it asks me if I want to sum, count, etc. the field and the fields will sum properly. I am running into the same problem when I try to put a variable I have created into a crosstab. If I put fields from the database in the crosstab they calculate just fine but when I put variables I have created in Jaspersoft Studio that work correctly in the body of the report, the numbers come out all screwy. Anyone know what I am doing wrong?

I removed the "new Double($V{UnitPrice}.doubleValue() == 0 ? 0 : " portion from the above code and it calculates correctly now!!! Thanks for the help! It is giving me.5 I would like to see two decimal places, do you know how to do that?

Based upon other questions that seem similar, I have tried the following formula. I am getting null. This should be as simple as 3.00/2 and display 1.50 however it is not working it still shows null. I have confirmed that the fields contain values for all fields. The Price Qty field is an integer and the Price field is BigDecimal, but this sets the values to double for the purposes of this variable correct? Anyone know what I am missing? new Double($V{UnitPrice}.doubleValue() == 0 ? 0 : ($F{Price Qty}.doubleValue()/$F{Price}.doubleValue()))

Based upon other questions that seem similar, I have tried the following formula. This time I am using the fields directly instead of a variable. I am still getting null. This should be as simple as 3.00/2 and display 1.50 however it is not working it still shows null. I have confirmed that the fields contain values for all fields. new Double($V{UnitPrice}.doubleValue() == 0 ? 0 : ($F{Price Qty}.doubleValue()/$F{Price}.doubleValue()))

I am trying to make Jaspersoft Studio calculate a Markdown for the contents of the report. Basically, I need to first divide the price by the price qty (2 for $3.00 would give me $1.50 unit price). I then do the same thing for the regular retail (1 for $2.00 would give me a $2.00 unit price). I then would subtract the regular unit price from the discounted unit price to get my markdown ($0.50). I am using MySql. Both active price and regular price are set as Decimal and the price qty is set to integer. First I create two variables and use the following expressions to convert the integer values to BigDecimal. This seems to work fine, when I drag the variable into the report it shows the same value as the corrosponding field. So far so good. $V{Active Unit}.valueOf( $F{Price Qty} ) $V{Reg Unit}.valueOf( $F{Reg Retail Unit} ) The next two variables I create then divide a field by that variable. (I am at this point finding unit price 2 for $1.00 show as .50 this way). These are returning null. $F{Price}.divide($V{Current Unit Price}) $F{Reg Retail}.divide($V{Regular Unit Price}) I then subtract the two newly created variables from each other (This is to find out my markdown for discounted items .75 - .50 is a .25 markdown per item). This is also returning null, although I don't know if this is because of the previous null or if it is its own problem. $F{Reg Retail}.divide($V{Regular Unit Price}) Any ideas what I am doing wrong? I know very little java, I am using this through Jaspersoft Studio. Based on what I have read, I believe I have constrcuted this correctly. Anyone have any ideas?