This might be an easy one but I cannot for the life of me work out how to get it to work. Basically I have a couple of sections under group footer 1 which gets suppressed or shown depending on certain situations. I need a variable to increment and display on the sections that are not suppressed.

E.g.

Section                 Suppressed              Variable displayed
GF1a                    No                              1
GF1b                    Yes                             N/A
GF1c                     No                              2
GF1d                    Yes                             N/A
GF1e                    Yes                             N/A
GF1d                    No                              3

I'm using the following formula on each of the sections to display the variable:
shared numbervar v-number;
v-number := v-number + 1;
v-number;

But they all just show 1 - how do i get it to show as per above? I tried using whileprintingrecords but that doesn't seem to work either... Help!


Edited by nix1016 - 28 May 2013 at 2:27am

Hi Thanks for that. I wanted to get around creating a formula for each row as there are quite a few rows and the suppression conditions on each row is different. This means that the formular for the later rows get quite big. Is there any other way around this? I had thought that whileprintingrecords would work for such situations?