regarding reports-Handling mulitple pages

  • Thread starter Thread starter archana
  • Start date Start date
A

archana

I have a report that looks like this
Main report header
sub report1 sub report 2
a 1
b 2
c 3
d 4
5


now if sub reports value is going to be more than 10 then i want the
report to be printed in next page(this it does) but i want the word
continued on the second page and i want sub report1 values on second
page.
Hope am clear?
Expecting some solutions?
Arch
 
I have a report that looks like this
Main report header
sub report1 sub report 2
a 1
b 2
c 3
d 4
5


now if sub reports value is going to be more than 10 then i want the
report to be printed in next page(this it does) but i want the word
continued on the second page and i want sub report1 values on second
page.
Hope am clear?
Expecting some solutions?
Arch
Click to expand...

Hi again

I solved this by using printcount property

Private Sub PageFooter2_Format(Cancel As Integer, FormatCount As Integer)
If PrintCount = 1 Then
Me.Report.txtContd.Value = ""
Else

'Print "continued"

Me.Report.txtContd.Visible = True
Me.Report.txtContd.Value = "Contd."
end sub
End If


I have one more query????
I need to know how to make one section of my sub report to repeat
ie i want the sub report1 to repeat when the pages extend for more than one.
Can some1 clarify the same?
Arch
 
Back
Top