Printing Multiple Reports to One PDF

[CharmyPoo]

Hi All,
QUESTION 1
I have 9 reports each with several subreports embedded. In reality, the 9 reports should be one report but I have been having difficulties integrating it with all the different headers and footers. Any suggestions?

As I have not been able to resolve that situation, I was wondering if there is a way to output multiple reports into ONE PDF file. Is there a command to append the report to the end of another report?

I am generating over 600 reports so it would be a pain to do it one by one.

QUESTION TWO
A rather stupid question. I have a field called "Name" in a table called tblPersonalInformation. I would only want the name to appear if it is on the first page of the report. I have written =IIf([Page]>1,[Name],""). The problem is that this query pulls up the report name. I have many queries and reports relating to this name so short of renaming the field - is there another way I can over come this problem.

Thanks so much,
Charmaine

 

[Orion45]

In response to your second question;
Try handling this from the section format event. It would look something like this..
Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer)
If Me.Page = 1 Then
me.Name.Visible = True
Else
Me.Name.Visible = False
End IF

I as assuming that Name is a field on your report. Hope this helps.