Adding Figure Numbers on Summary Tables

H

HORNUNG

I have a Main Report that has 10 subreport. Of the 10 subreports, 2
subreports has a subreport within them. I have to add figure numbers after
each summary table which are my subreports. Not all subreports will display
because of lack of data.

Here is what I have done:
(1) Added a text box in Main Report called figCounter
(2) Added a text box in footer of all subreports referencing the
figCounter and Summary Table Title
(3) Created a macro that adds 1 to figCounter
(4) Run the macro on the "On Report" event at a particular group header

Seems to work fine, until my subreport that has its own subreport prints on
several pages, and the figCounter doubles or triples.

Can you advise me on the On Format, On Print, and On Format events? Is
there another solution?
 
Top