since I am not a Running Total person, I don't know if that is a viable solution path, but using variables, that I know.
since you are using a subreport to generate the number, I will assume that you are using a shared variable. Now the question is, what else do you need to do.
If you just summing a column and then adding the shared variable to it, I would try:
shared numbervar sharedVar;
sum({table.field}, {group}) + sharedVar
if you need to update the totals based on some condition
shared numbervar sharedVar;
if {table.fieldx} = x then
sharedVar := sharedVar + {table.fieldy};
this would increment/display the new value.
In general, the summing of a variable can be simplified to this: If CR can see the value in the raw data, on the first pass, it can sum it. Since it can't see the value that would be returned from a subreport, you can sum using the variable/formula. If you had a field for sex, you could create a formula like: if {table.sex} = "M" then 1 else 0
and you could sum that...I haven't but DBlank uses it all the time in his posts, I have done something similar as I use that sort of logic to perform dynamic grouping.
It all comes down to what CR can 'see' in the raw data as to whether or not you can sum on it.
HTH
IP Logged
