Jaspersoft studio calculate variables before detail band

Question

Jaspersoft studio 6.2.

The report below, there are 3 bands: title, detail, and summary. Detail is in the middle. Look at "Activated staff" on the top on title band, it used a variable (activatedstaffcount1) as expression. The variable sum all activated staff counts in the detail. However it shows null. The bottom one is in the summary band and used the same variable but it shows correct number. The middle section is the data (detail band). I want to show aggregated result before the display data(detail band), how can I do it?

Answer 1

Try to set also Evaluation time in the text field which contains that variable to the "Report".

If the text field is outside of the table - try to return value into the parameter back from dataset and display that parameter at the end of report evaluation.