How and where to reset shared variable 1

[DianaStewart]

Subreport:

Group Header1 is grouped by LastName
Group Header2 is grouped by Date (Month)

I have placed my formula is Group Footer2:

whileprintingrecords;
shared numbervar Variable1 := sum({PunchCard}, "monthly&quot

In my Main Report I have this formula placed in the Group Footer 2:

whileprintingrecords;
shared NumberVar Variable1;
Variable1


The problem is the same value is for the variable is being carried over to each LastName. If Smith has 30 as the shared variable then the value 30 is also being passed onto the next name.

Where and how can I reset the variable for each LastName?

 

[Naith]

Place

WhilePrintingRecords;
Shared NumberVar Variable1 := 0;

in the GroupHeader2.

Naith

 

[DianaStewart]

In which report do I place this Reset? In the main report or the subreport?

 

[chelseatech]

What are you trying to do?

The shared variable isn't of any use in the main report, until the subreport has finished processing. SO why not have a line in the subreport...
shared numbervar Variable1 :=
Variable1 + sum({PunchCard}, {datefield},"monthly&quot Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm