Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Posts
    361

    Unanswered: Number of Report Pages Equal Table Rows

    I have a report that is tied to a table. This table has 665 rows in it. The when the report launches, it fits on to one page but when I click to the next page in the report its the exact same data but without the header labels. I have about 60 text boxs on the report. Most of them carry a fucntion like this.

    =Sum(IIf([CountCust]=10,1,0))

    Is there a way that I can make the report stick to one page?

  2. #2
    Join Date
    Mar 2004
    Posts
    361
    What I want to do is export this report to excel so I can do further calculations on that data.

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Play with resizing your report (if possible) and/or adjust your page layout
    Back to Access ... ADO is not the way to go for speed ...

  4. #4
    Join Date
    Mar 2004
    Posts
    361
    I think the width is ok. I moved all of the rows next to each other and sure enough the same rows repeat themselves on the same page. It kinda looks like this.


    aaaaaaaaaaaa
    bbbbbbbbbbbb
    cccccccccccc
    dddddddddddd

    aaaaaaaaaaaa
    bbbbbbbbbbbb
    cccccccccccc
    dddddddddddd

    Is there a property I can change that says keep to one page or something like that.

  5. #5
    Join Date
    Mar 2004
    Posts
    361
    This is what I have now.

    Label1 aaaaaaaaaaaaaa
    Label2 Bbbbbbbbbbbbbbb
    Label3 CCCCCCCCCCCCC

    Label1
    Label2
    Label3

  6. #6
    Join Date
    Mar 2004
    Posts
    361
    I changed to a portriat layout and that didn't change anything. It still seems to need a layout for every row in my table. I also tried to put the labels in the page footer and so forth but that has no improvement. Any other idea's?

Posting Permissions

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