shared variables and running totals canno tbe placed in a section above where all of the details that make up the total value- in essence you cannot reference something that does not exist before it exists. The variable might exist but the value you are setting the variable to does not.
You can reference a value gotten via a summary function (sum(field), average(field), etc.).
If your data is such as a field is identifying the type of value in one field and the amount in another you can create a formula to zero out the ones you don't want and sum it.
example: if table.type='Asset" then table.amount else 0
Sum this at your group level and it will only give you a sum of assets for group one. THis can be displayed anywhere in group one and the value will not change. It will only change in the next group.
Hopefully the logic of this gives you a possible solution.
The other option is to use sub reports and shared variables passing values back to the main report. This is less efficient.
Edited by DBlank - 05 Jan 2015 at 9:23am
IP Logged
