Having issues with panels and databands

[Brainstorm]

Im having trouble with panels when using databands, the data is not being displayed in the correct order.
As you can see in the image bellow, the data is sent to the next row of execution instead of the current item:


The right most fields are doing a sum (Soma=Sum) of the green and red fields respectivelly.
I have already tried everything i know to make it show the sum properly, used a big panel with the small panels inside it, used another panel for the sum, re-creating the sum fields, using variables, everything gives me the same results.

Attached report:
http://dl.dropbox.com/u/34291967/tables.mrt

[HighAley]

Hello.

Im having trouble with panels when using databands, the data is not being displayed in the correct order.
As you can see in the image bellow, the data is sent to the next row of execution instead of the current item:


The right most fields are doing a sum (Soma=Sum) of the green and red fields respectivelly.
I have already tried everything i know to make it show the sum properly, used a big panel with the small panels inside it, used another panel for the sum, re-creating the sum fields, using variables, everything gives me the same results.

Attached report:
http://dl.dropbox.com/u/34291967/tables.mrt

The values of text boxes are calculated in order as they are in the report tree.
Please, try to move Panel3 and Panel5 higher then Thex32 text box in the report tree.

Thank you.

[Brainstorm]

The values of text boxes are calculated in order as they are in the report tree.
Please, try to move Panel3 and Panel5 higher then Thex32 text box in the report tree.

I realized it was related to the order they were being executed, the problem could be fixed temporarily when i deleted the sum boxes and made new ones, but as soon as i edited any of it's property, the problem came back.
But im unsure how to modify the report tree. Only place i could see it was on the property tab when browing the list of objects at the top (which had text32/etc bellow some panels).
EDIT
I figured out how to access it. But the sums are still giving wrong values here and there. Try it yourself.

[HighAley]

Hello.

The values of text boxes are calculated in order as they are in the report tree.
Please, try to move Panel3 and Panel5 higher then Thex32 text box in the report tree.

I realized it was related to the order they were being executed, the problem could be fixed temporarily when i deleted the sum boxes and made new ones, but as soon as i edited any of it's property, the problem came back.
But im unsure how to modify the report tree. Only place i could see it was on the property tab when browing the list of objects at the top (which had text32/etc bellow some panels).
EDIT
I figured out how to access it. But the sums are still giving wrong values here and there. Try it yourself.

Please, try to drug and drop Panels higher then Text32 in the report tree.

Thank you.

[Brainstorm]

EDIT2
I figured out the problem, the report tree is being reordered everytime i modify a property of one of the report objects (setting a font to bold for example). The text boxes will automatically go above the panels and cause errors on the Sum boxes.

The tree looks like:

Text
Text
Text
Panel
Panel

I put the panels above the texts and the sums work fine. But if i modify anything it will re-order back to texts before panels.

[HighAley]

Hello.

Please, try to set Lock property of Text boxes and Panels to True.

Thank you.

[Brainstorm]

Setting all their properties to Locked True solved the problem, thanks.

[Andrew]

Hello,

Perfect.

Have a nice day!