By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,656 Members | 1,327 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,656 IT Pros & Developers. It's quick & easy.

Report Group Header Quandry

P: n/a
Im not sure if I am missing something obvious here or not so excuse me
if this is a DFU question please... I have a report I am working on
that includes the following data.

Agency Name
Vendor Name
Contract Number
Contract Description

Agencies can have (and often do have) multiple contracts. I want my
report to have a group header for the Agency Name followed by the
detail containing Vendor and Contract info for all Vendors who provide
services to that agency. All well and good up to now, pretty simple
stuff. Now what I want to do is this... NOT break the report on each
agency (I want to "keep together" the agency name with the first
detail but not "whole group"), however, if a given agency does have
more than one contract and the detail carries to the next page I want
to repeat the group header at the to of the page so that the Agency
name is displayed (again) on the next page. Any ideas?

Oct 26 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Fri, 26 Oct 2007 12:36:40 -0700, DavidB wrote:
Im not sure if I am missing something obvious here or not so excuse me
if this is a DFU question please... I have a report I am working on
that includes the following data.

Agency Name
Vendor Name
Contract Number
Contract Description

Agencies can have (and often do have) multiple contracts. I want my
report to have a group header for the Agency Name followed by the
detail containing Vendor and Contract info for all Vendors who provide
services to that agency. All well and good up to now, pretty simple
stuff. Now what I want to do is this... NOT break the report on each
agency (I want to "keep together" the agency name with the first
detail but not "whole group"), however, if a given agency does have
more than one contract and the detail carries to the next page I want
to repeat the group header at the to of the page so that the Agency
name is displayed (again) on the next page. Any ideas?
Set the Group Header's Repeat Section property to Yes.
It's on the Group Header Property sheet's Format tab.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Oct 26 '07 #2

P: n/a
On Oct 26, 4:45 pm, fredg <fgutk...@example.invalidwrote:
On Fri, 26 Oct 2007 12:36:40 -0700, DavidB wrote:
Im not sure if I am missing something obvious here or not so excuse me
if this is a DFU question please... I have a report I am working on
that includes the following data.
Agency Name
Vendor Name
Contract Number
Contract Description
Agencies can have (and often do have) multiple contracts. I want my
report to have a group header for the Agency Name followed by the
detail containing Vendor and Contract info for all Vendors who provide
services to that agency. All well and good up to now, pretty simple
stuff. Now what I want to do is this... NOT break the report on each
agency (I want to "keep together" the agency name with the first
detail but not "whole group"), however, if a given agency does have
more than one contract and the detail carries to the next page I want
to repeat the group header at the to of the page so that the Agency
name is displayed (again) on the next page. Any ideas?

Set the Group Header's Repeat Section property to Yes.
It's on the Group Header Property sheet's Format tab.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail- Hide quoted text -

- Show quoted text -
Thank you. I thought it was a DFU thing. I just could not recall
where that option was to save my butt. Appreciate the rap upside the
head!

Oct 29 '07 #3

P: n/a
On Oct 26, 4:45 pm, fredg <fgutk...@example.invalidwrote:
On Fri, 26 Oct 2007 12:36:40 -0700, DavidB wrote:
Im not sure if I am missing something obvious here or not so excuse me
if this is a DFU question please... I have a report I am working on
that includes the following data.
Agency Name
Vendor Name
Contract Number
Contract Description
Agencies can have (and often do have) multiple contracts. I want my
report to have a group header for the Agency Name followed by the
detail containing Vendor and Contract info for all Vendors who provide
services to that agency. All well and good up to now, pretty simple
stuff. Now what I want to do is this... NOT break the report on each
agency (I want to "keep together" the agency name with the first
detail but not "whole group"), however, if a given agency does have
more than one contract and the detail carries to the next page I want
to repeat the group header at the to of the page so that the Agency
name is displayed (again) on the next page. Any ideas?

Set the Group Header's Repeat Section property to Yes.
It's on the Group Header Property sheet's Format tab.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail- Hide quoted text -

- Show quoted text -
Thank you. I knew it was a DFU thing. Thanks for knocking sense back
into me, my wife wasnt around to do it...

Oct 29 '07 #4

P: n/a
On Oct 26, 4:45 pm, fredg <fgutk...@example.invalidwrote:
On Fri, 26 Oct 2007 12:36:40 -0700, DavidB wrote:
Im not sure if I am missing something obvious here or not so excuse me
if this is a DFU question please... I have a report I am working on
that includes the following data.
Agency Name
Vendor Name
Contract Number
Contract Description
Agencies can have (and often do have) multiple contracts. I want my
report to have a group header for the Agency Name followed by the
detail containing Vendor and Contract info for all Vendors who provide
services to that agency. All well and good up to now, pretty simple
stuff. Now what I want to do is this... NOT break the report on each
agency (I want to "keep together" the agency name with the first
detail but not "whole group"), however, if a given agency does have
more than one contract and the detail carries to the next page I want
to repeat the group header at the to of the page so that the Agency
name is displayed (again) on the next page. Any ideas?

Set the Group Header's Repeat Section property to Yes.
It's on the Group Header Property sheet's Format tab.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail- Hide quoted text -

- Show quoted text -
Sorry for the double post. Just goes to show how DFU I have been
recently!

Oct 29 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.