Report Group Header Quandry

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?

Re: Report Group Header Quandry

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

Re: Report Group Header Quandry

On Oct 26, 4:45 pm, fredg wrote:
> 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!

Re: Report Group Header Quandry

On Oct 26, 4:45 pm, fredg wrote:
> 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...

Re: Report Group Header Quandry

On Oct 26, 4:45 pm, fredg wrote:
> 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!