Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Repeat Group Header On Each Page" option

Status
Not open for further replies.

harding1031

Programmer
Oct 21, 2004
65
US
When I select this option in Group Expert, my manual formulas are reset because I inialize these for each new group. I was able to get around it by setting a manual switch for each new group. Was there any other way to get around this, also, where can I get some information about the how a crystal report executes. For instance, if I have two formulas in the the group footer, which one will execute first. TIA.
 
Use the InRepeatedGroupHeader function in your manual formulas to reset your variables.

if not InRepeatedGroupHeader then
myVar := 0;
 
You'd do better using Running Totals. Right-click on a field and choose Insert to get a choice of Running Total, Summary and Grand Total.. Or else use the Field Explorer, the icon that is a grid-like box.

It helps to give your Crystal version, since newer versions have extra options, and some extra problems. I use Crystal 8.5.

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
Another option would be to add a section to your group footers and reset your variables there. You can suppress the new section and the variables will still reset.

MrBill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top