PH off GF on 1

[teqtaq]

Hi!
I am displaying Summary in Group Footer.
I want to turn off Page Heather when Group Footer is displayed.

I am trying :
If GroupFooter0.Visible = True Then
txtCoName.Visible = False
txtBU.Visible = False
txtNameD.Visible = False
Else
txtCoName.Visible = True
txtBU.Visible = True
txtNameD.Visible = True
End If


No luck. Please, advice.

 

[Remou]

Which event did you use?

Private Sub PageHeaderSection_Print(Cancel As Integer, PrintCount As Integer)
If Me.GroupFooter1.Visible = True Then
   PageHeaderSection.Visible = False
Else
   PageHeaderSection.Visible = True
End If

End Sub

 

[teqtaq]

It almost worked except:
I have

Report Title
txtCoName
txtBU
txtNameD

all in Page Header because I need this to be seen on every page.

Then there is Group Footer that has SUB Report.

Sub Report is a Summary of the Report so it should be printing on the very last page of the Report.

And it does except first that is shown on the last page are

Report Title
txtCoName
txtBU
txtNameD

and then SUB Report's data.

So I need to resolve this issue.

Thanks for looking into it for me.

 

[Remou]

In that case the easiest thing to do is to put the summary in the report footer and set Page Header to "Not with Report Footer" on the report's property sheet.

 

[teqtaq]

I did not tell you correct things. This is how all of my other SUB Reports are - in the report footer and set Page Header to "Not with Report Footer" on the report's property sheet.

This one should come after every Group - per Group.

So this is why I had moved it from RF to a GF so I can link it by GF field and pull PER Group so each group has it's own Summary.

Sorry for the confusion.

 

[teqtaq]

Thanks done !
You were right I could keep it in RF and have links...Thanks

 

[Remou]

Ok. I am confused. Why did my first example not suit?

 

[teqtaq]

NO I moved it to Report Footer and linked as suppose to and it works. I shouldn't had to moved it to a Group Footer on a first place and you just opened that up for me.
Thanks

P.S. No coding - just simply positioning.

 

[teqtaq]

I was too confused yesterday!
It can't work with Report Footer because I need this after every Group.

OK, here is the problem (again)

I have

Report Title
txtCoName
txtBU
txtNameD

all in Page Header because I need this to be seen on every page.

Then there is Group Footer that has SUB Report.

Sub Report is a Summary of the Report so it should be printing AFTER EVERY GROUP.

And it does except first that is shown on the Summary page AFTER EVERY GROUP:

Report Title
txtCoName
txtBU
txtNameD

and then SUB Report's data.
___________________________________

So what I need is to remove
Report Title
txtCoName
txtBU
txtNameD
when Group Summary is printed.

I hope it makes sense.
Thanks

 

[teqtaq]

OK, thanks for support -it is done by moving all into another Header.