Subtotal a variable

[mdtimo]

I pass a variable(numbervar) from my subreport to the detail of my master report. I then want to subtotal this variable in my master report. But unlike other fields or formulas I can not subtotal on the variable.

Is there a way around this?

 

[synapsevampire]

You'll have to manually do so in a formula, use the 3 step formula approach:

Place this in the report header and suppress it:
//@initSVsum;
whileprintingrecords;
global numbervar SVSum :=0

Place this after the shared variable is returned and suppress it:

//@IncrementSVSum
whileprintingrecords;
shared numbervar mysharedvar;
global numbervar SVSum;
SVSum := SVSum+mysharedvar

//@DisplaySVSum
whileprintingrecords;
global numbervar SVSum;
SVSum

Seems right anyway...

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[mdtimo]

I oversimplified my question.

I use the variable in a formula.

IF table.value="A" then variablefromsubreport else 0

This is the value I want to subtotal on.

Your logic seems good to me but I don't think it applies in this situation.

 

[synapsevampire]

I don't understand how this differs, except that you might need to qualify when it's summed:

Place this in the report header and suppress it:
//@initSVsum;
whileprintingrecords;
global numbervar SVSum :=0

Place this after the shared variable is returned and suppress it:

//@IncrementSVSum
whileprintingrecords;
shared numbervar mysharedvar;
global numbervar SVSum;
If table.value="A" then
SVSum := SVSum+mysharedvar

//@DisplaySVSum
whileprintingrecords;
global numbervar SVSum;
SVSum

Same rules apply, it just gets incremented when your logic is met.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[cmpgeek]

vampire...

i am guessing it is not possible for this to work when you are resetting your variable to 0 in the groupfooter each time; is there another way to subtotal them in that case?