How can I limit number of lines in a subreport

[acamusc]

Hi pals!
I am having problems with a sub-report that pushes out of page the lower part of the main report which contains the totals and summaries.
How can I keep the subreport with no growing(it is set Not growing, no shrink) in size and accepts just 23 lines and if it excedes print a second page?
Thanks in advance
Kindly
Acamusc

 

[danvlas]

Place a textbox (txtCount) in the detail section
Control source: = 1
Running Sum: Over All

Place an invisible page break (pbr) right below the relevant data.

In the code:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
pbr.Visible = Not (txtCount Mod 23)
End Sub

Good luck



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[acamusc]

Thank you Dan, I did it step by step, but now I get 1 line per page.
I don't think I forgot something, anyway I will keep trying.
Thanks again.
acamusc

 

[danvlas]

You forgot to set the Visible property of the page break to False.





Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[danvlas]

Ooops...guess I didn't wake up completely...

Try:

If (txtCount Mod 23) = 0 Then
pbr.Visible = True
Else
pbr.Visible = False
End If




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html