Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Force New Page

Force New Page

Force New Page

I have a report that links to a SQL view and only uses the details section. It creates labels and prints to a Dymo printer.

If I run the report locally it works ok. However, when I run it from our business system it puts 2 labels onto one page instead of just one.

Is there a way I can force it to just print one record per page using a formula or even an easier way. I have googled this but a lot of what I find is based on Groups which I do not have in this report


RE: Force New Page

Go into the Section Expert, select Details->New Page After and in the x+2 box, enter: Not OnLastRecord


RE: Force New Page

Under Paging I have New page after and then 2 parts

End of Section and Visible records

Which bit does this go in.


RE: Force New Page

Not familiar with this version if CR, I guess. I would try the formula area (x+2) for End of Section.


RE: Force New Page

Pretty sure you can just check end of section.

The fact that behavior changes is likely due to a change in printer or printer driver.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

RE: Force New Page


Yes I managed to put End Section in and then after that it was a printer setting alsi. Thanks for the help and advice much appreciated, all working now.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close