Skip to Content
author's profile photo Former Member
Former Member

Display rows on separate pages

Good day, wonderful people of this forum. Please I am using crystal reports visual studio version CRforVS_13_0_15 and I am finding difficulty displaying the rows on separate pages. For instance, when the SQL query returns 30 records, these records should display on 30 pages separately. None of the fields is on the detail section. I appreciate your effort in advance. Many thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 06, 2016 at 06:44 PM

    Thanks Dell,

    I did that but the report showed only two pages, the first one is blank and the second one contains the record, meanwhile the SQL rows fetched are more than five. I have the fields on Page Header & Page Footer only. Or do I have to put the fields in the detail section for the rows returned to be displayed on each page separately? One thing I have realized is if it is only one record it displays on the report as such, but if it is more than one then it displays only two pages preceding with a blank one. I'm just confused! Please help. Thanks again, Dell.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 06, 2016 at 01:43 PM

    If none of the fields is in a detail section, I'm going to assume that you have them in group headers or footers. If so, then try this: Go to the Section Expert for the group footer where you want the page break to appear by right-clicking in the gray area to the left of the section and selecting "Section Expert..." Go to the "Paging" tab. Click on the formula button to the right of "New Page After" - DO NOT check the New Page After checkbox!. Enter the following formula and save:

    not OnLastRecord

    This will give you a page break after each record except the last one (which would give you a blank page.)

    -Dell

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.