Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2015
    Posts
    1

    Unanswered: How to display fixed number of records per page in a report?

    Hi All,

    I'm using the Northwind Traders database as an example to create my own. I have tweaked the database to what I want and its almost perfect to my requirement. One problem I have is the display of rows to fill up a landscape sheet (which I will print twice as customer copy and company copy) on one sheet of paper. So if there is one order id with 4 order details of that order id I need to display the 4 plus an additional 6 blank order details to fill up the space. If 3 then 7. If 11 then 10 on one page with 1 on and 9 blanks.


    Please let me know what information is required to help in this question so I can provide it. I can upload the database as well as it is if required.

  2. #2
    Join Date
    Dec 2013
    Posts
    43
    Provided Answers: 1
    saudkazia,

    I think you can use the "sorting and grouping" feature of the report to go to a new page when the Order ID changes.

    Wayne

  3. #3
    Join Date
    Dec 2013
    Posts
    43
    Provided Answers: 1
    saudkazia,

    I think you can use the "sorting and grouping" feature of the report to go to a new page when the Order ID changes.

    Wayne

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •