Is this possible in reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a report where I have one group header and group footer. The group
footer consists of signature and title. The detail sections consists
LineNumber and Comments fields. When I run the report depending on the length
of data in the detail section, the signature and title fields gets inserted
anywhere in the page. Now is there any manipulation possible, so that the
footer value can be at the bottom of a page instead at any place on a page? I
appreciate any help. Thanks.
 
Hi,
I have a report where I have one group header and group footer. The group
footer consists of signature and title. The detail sections consists
LineNumber and Comments fields. When I run the report depending on the length
of data in the detail section, the signature and title fields gets inserted
anywhere in the page. Now is there any manipulation possible, so that the
footer value can be at the bottom of a page instead at any place on a page? I
appreciate any help. Thanks.
Click to expand...

It might be easier just to place the Signature and Title in the Page
Footer and make them Visible or Not Visible as needed.

However, to answer your question...
See this KnowledgeBase article:

208979 ACC2000: How to Print a Group Footer at a Specific Location
 
Thanks Fredg for the help. With the Signature and Title in the Page
Footer how does one make them Visible or Not Visible with the criteria that
the page containing the last number in the detail section should show the
page header and otherwise not.
 
Thanks Fredg for the help. With the Signature and Title in the Page
Footer how does one make them Visible or Not Visible with the criteria that
the page containing the last number in the detail section should show the
page header and otherwise not.
Click to expand...

re: > should show the page header and otherwise not. <
I think you mis-spoke.
Isn't it the controls in the page FOOTER you want to show?

Try it this way.
Include the signature etc. in the Group Footer as you do now.
Set the Group Footer.Visible = No.
Add an unbound control to the Page Footer for each control in the
Group Footer you wish to show. Make these Not Visible also.
Set their control source to:
=[Name of control in Group Footer]

Code the Group Footer Format Event:
[Control Name In Page Footer].Visible = True
repeat for each additional control.

Code the Page Header Format event:
[Control Name In Page Footer].Visible = False
repeat for each additional control.

The Page Header turns the control's Visible property Off.
The Group Footer will turn them Visible.
The Group footer will not display at all.
It should work.
 
Thanks Fredg again for your help. I will work on it.

fredg said:
Thanks Fredg for the help. With the Signature and Title in the Page
Footer how does one make them Visible or Not Visible with the criteria that
the page containing the last number in the detail section should show the
page header and otherwise not.
Click to expand...

re: > should show the page header and otherwise not. <
I think you mis-spoke.
Isn't it the controls in the page FOOTER you want to show?

Try it this way.
Include the signature etc. in the Group Footer as you do now.
Set the Group Footer.Visible = No.
Add an unbound control to the Page Footer for each control in the
Group Footer you wish to show. Make these Not Visible also.
Set their control source to:
=[Name of control in Group Footer]

Code the Group Footer Format Event:
[Control Name In Page Footer].Visible = True
repeat for each additional control.

Code the Page Header Format event:
[Control Name In Page Footer].Visible = False
repeat for each additional control.

The Page Header turns the control's Visible property Off.
The Group Footer will turn them Visible.
The Group footer will not display at all.
It should work.
Click to expand...
 
Back
Top