Hello,
I would like to know if there is a way to count the number of pages in all the groups of a Report.
So in other words I have a Report, that gets broken up into 3 different groups. Each group being printed on a different sheet. The reason I need this, is that I would like to hide the page header on the first page of every group, and hide the group header of every other page in the group (if the groups has more than one page).
So I am thinking like this:
in the group header have a text box 'txtGroupNumber' with control source '=1' and set it to running sum. So far that works good. Now what I need is a page of pages for each group.
Then I could check with code:
Is there a way of doing this?
Thanks,
Sylvain
I would like to know if there is a way to count the number of pages in all the groups of a Report.
So in other words I have a Report, that gets broken up into 3 different groups. Each group being printed on a different sheet. The reason I need this, is that I would like to hide the page header on the first page of every group, and hide the group header of every other page in the group (if the groups has more than one page).
So I am thinking like this:
in the group header have a text box 'txtGroupNumber' with control source '=1' and set it to running sum. So far that works good. Now what I need is a page of pages for each group.
Then I could check with code:
Code:
if txtGroupNumber = 1 then
If page 1 of group then
PageHeader.visible=false
GroupHeader.visible=true
end if
If page 2 of group then
GroupHeader.visible=false
Page header visible = true
End if
End if
Then repeat the code for every group
Is there a way of doing this?
Thanks,
Sylvain