Group Headder's Headder 1

[Crowley16]

Hi...

I've got a group headder which sumarises stuff in the group, however I want to put a headder on All the headders...

i.e.

something
GroupHeadder <- This section contains summary info
Detail
GroupFooter

Is there an easy way of doing this?

--------------------
Procrastinate Now!

 

[THWatson]

Crowley16
In your sorting and grouping dialog box, make sure that Group Header is set to Yes. Then you can put a label, or whatever you want, in the Group Header section that will occur.

Tom

 

[Crowley16]

the group header is on...

I'm putting the sum IN the group headder section...

what I want is to have a headder for all the different groups...

currently my report has the structure:
report header
page header
locality header <- this is the group header in question
detail
locality footer
page footer
report footer

what I want is a headder to encompass ALL the different localities...

--------------------
Procrastinate Now!

 

[THWatson]

Here are 2 pictures...

(1.)
This section contains summary information
detail for Locality 1
Locality 1 footer
This section contains summary information
detail for Locality 2
Locality 2 footer

(2.)
This section contains summary information
detail for Locality 1
Locality 1 footer
detail for Locality 2
Locality 2 footer

Is it (2.) that you want?

Tom

 

[Crowley16]

close...

I don't actually have anything in the detail section...

so it's:

This section contains labels information
Locality 1 header (count of records for Locality 1)
Locality 2 header (count of records for Locality 1)
Locality 3 header (count of records for Locality 1)
...

--------------------
Procrastinate Now!

 

[THWatson]

Crowley16
Is there a reason you can't put that "This section contains summary information" in a label in your Page Header section?

Tom

 

[THWatson]

Crowley16
Here's a way you can do it, if you don't want to put the label in the Page Header section.

1. In your Group Header section, put the label "This section contains labels information" or whatever it is you want to put in there. Let's call it lblHeader

2. Also in the Group Header section, put an Unbound text box with the Control Source =1 and make it a running sum OverAll. Let's call the text box txtSum. Make that text box Invisible.

3. In the OnFormat property for the Group Header section, put the following...
If Me. txtSum > 1 Then
Me.lblHeader.Visible = False
End If

Tom

 

[Crowley16]

Tom,

I can't put this in the page headder since this is only relevant to 1 page, there's a chart object in the report footer...

your solution does work, so have a star, however I was hoping for a simple built in answer...

--------------------
Procrastinate Now!

 

[Crowley16]

Update

I've found another solution.

Basically, I set up a new column in the query and filled it with a simple text, then I put in a group level for this new column which has a higher priority over my Locality group. I.e. I shunted Locality to a subgroup.

Now I can use the new column's group headder to put my labels...

Not necessarily easier, but this way I don't have to keep resetting the visible properties and don't have to mess about with canGrow/Shrink stuff either...

--------------------
Procrastinate Now!

 

[THWatson]

Crowley16
Whatever works best for you...that's great.

Tom