Force new page problem

  • Thread starter Thread starter Andre
  • Start date Start date
A

Andre

Hello Everyone,

I have a report with 4 un-linked sub-reports:
1/ Details of services sold (based on recordset of query 1)
2/ Summary of services sold (based on recordset of query 1)
3/ Number of services sold (based on recordset of query 2)
4/ Summary of products sold. (based on recordset of query
1)
The plan is to select which report the user want to print
and print the selected reports all in one go in one report.

I want to force a new page between each sub-report. I have
added a 'Page Break' in all the report footer section of
all the sub-reports and also tried 'Force New Page after
Section' for all of them.

The problem is that I get a new page for the second report
but not for the others.
I tested the sub-report on their own and they force new
pages OK.

Any idea on how to solve this?
 
Andre said:
Hello Everyone,

I have a report with 4 un-linked sub-reports:
1/ Details of services sold (based on recordset of query 1)
2/ Summary of services sold (based on recordset of query 1)
3/ Number of services sold (based on recordset of query 2)
4/ Summary of products sold. (based on recordset of query
1)
The plan is to select which report the user want to print
and print the selected reports all in one go in one report.

I want to force a new page between each sub-report. I have
added a 'Page Break' in all the report footer section of
all the sub-reports and also tried 'Force New Page after
Section' for all of them.

The problem is that I get a new page for the second report
but not for the others.
I tested the sub-report on their own and they force new
pages OK.
Click to expand...


The main report is in charge of paging, a subreport's page
operations have no effect.

Place the PageBreak controls in the main report.
 
Marsh,


Thanks for the advice.

If I place the page break in the main report, how can I
disable them when I make some of the subreports invisible,
as per the user selection?
 
Make the PageBreak controls invisible too.

If <somecondition> Then
Me.subreport.Visible = False
Me.pgbreak1.Visible = False
End If
 
Or use a boolean operation:

Me.subreport.Visible = (<somecondition> = False)
Me.pgbreak1.Visible = (<somecondition> = False)

(note that you can leave the "= False" out if you'd rather evaluate a True
condition)

Randall Arnold
 
Back
Top