Repeating Groups within other groups

[cgunkel]

I have a report with 8 groups and the 2 inner groups need to be displayed in the footer of group 1 through 5. I need to display the descriptions and totals for group 7 and 8 for groups 1 through 5. If anyone has any ideas on how to accomplish putting 2 groups in a footer (this how I define what I need to do), please let me know. (I am using Crystal 8.5)

Group 1 Header
Group 2 Header
Group 3 Header
Group 4 Header
Group 5 Header
Group 6 Header
Group 7 Header
Group 8 Header

Group 8 Footer
Group 7 Footer
Group 6 Footer
Group 5 Footer
Group DESCRIPTION 7 total:
Group DESCRIPTION 8 total:
Group 4 Footer
Group DESCRIPTION 7 total:
Group DESCRIPTION 8 total:
Group 3 Footer
Group DESCRIPTION 7 total:
Group DESCRIPTION 8 total:
Group 2 Footer
Group DESCRIPTION 7 total:
Group DESCRIPTION 8 total:
Group 1 Footer
Group DESCRIPTION 7 total:
Group DESCRIPTION 8 total:

 

[HowardHammerman]

You will have to create formulas with shared variables and use the 'three formula' method.

Create a 'reset' formula that sets a value to blank or zero.
Place that in the proper group header.

Create an 'accum' fomula that sets the value of the shared variable.

Create a 'display' formula that displays the value.

See tech tips on my web site for more help. Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269