asked on

Access Group Header to repeat for the detail section only (not with a Group Footer)

I have a group header on a report which I only want to repeat for the detail section. We have a separate Group Footer section with its own header and detail.

How can I get a Group Header to repeat for the detail but not for a specific Group Footer? What event do I put this code?

Thanks

OnALearningCurve

Hi quizzer,

You could try doing this using code in the "On Format" property of the "Sepcific Group Footer"

For example if you Group header has a single lable in it called LABLE1 then you could add the line

Me.LABLE1.Visible = False

against the On Format property of you group footer. If you also set the Can Shrink Property of the group header to yes then is should dissapear when the group footer is displayed.

I Hope this helps,

Mark.

quizzer

ASKER

I have a Group Footer named GroupFooter1, that is set up as an Entire page with Labels and Lines and is the last Page printed for each group.

I just cannot have the Group Header named GroupHeader0 pint its labels above this section. It throws everything off

I have GroupHeader0 then Detail Then GroupFooter0. I want Group Header0 to repeat over Detail and GroupFooter0. But not over GroupFooter1. Right now when the length of the detail records is one page it prints perfectly. I juts need code to get GroupHeader0 to not display over GroupFooter1.

Thanks

quizzer

ASKER

I set a running sum over the group in a Text Box named TxtLineCnt . Basically as long as TxtLineCnt is >0 in the Detail section I want GroupHeader0 to show. Just where would I put this OnPrint OnFormat Do i need RepeatSection????

If Me.TxtLineCnt > 0 Then
Me.GroupHeader0.Visible = True
Else
Me.GroupHeader0.Visible = False
End If

quizzer

ASKER

OK here is the deal

I have a GroupHeader0

Just has labels

Detail
has data may be 1 or more pages in length

GroupFooter0
has a subreport which prints a correct number of blank lines based on conditions

GroupFooter1
has some special formatting and lables and is basically a standalone page. Set Force new Page to Before Section

Everything works just fine except if the detail section is more than one page. If I set Repeat Section to False on GroupHeader0 everything is fine except for the single page of detail records, but it leaves no labels above the detail records for Page 2 and Beyond

When I set the Repeat Section to True in GroupHeader0 it puts a Group Header in front of everything, including my GroupFooter1 section where I do not want it to appear.

I just want it to stop repeating for GroupFooter1

ASKER CERTIFIED SOLUTION

OnALearningCurve

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

quizzer

ASKER

When I do that it turns off the Group Header everywhere there is no longer a Visible Group Header.

GroupHeader0 no longer displays at all. Is there some sort of Conditional formatting if there is some data present in the Control TxtLineCnt display GroupHeader0 else do not

quizzer

ASKER

Could I use the report's OnPage Event so that if the control TxtLineCnt is visible GroupHeader0 is Visible and if TxtLineCnt is not visible GroupHeader0 is Not Visible

OnALearningCurve

Hi Quizzer,

Sorry for the lack of response but I have been away for a while.

Would it be possible to upload a copy of sample of your database with the report included for me to take a look at?

Cheers,

Mark.

OnALearningCurve

Hi Quizzer, thanks for the points!

Did you manage to resolve your problem in the end?

Mark.