display several records per report - Access 2010

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • M0ji
    New Member
    • Jan 2013
    • 15
    #1

    display several records per report - Access 2010

    I have a table with 10 records in it, and I have created a report and added existing fields.
    The report shows one record on each page (There are therefore 10 pages)
    I need all 10 records on one page.
    Tags: None
    • Seth Schrock
      Recognized Expert Specialist
      • Dec 2010
      • 2965
      #2
      The first thing that comes to my mind is that you possibly have one or more of your report sections (first guess would be the details section) heights to tall. Without more information about what you are doing, all we can do is guess.

        Comment

        • M0ji
          New Member
          • Jan 2013
          • 15
          #3
          no they are not too tall.
          I know what you are saying, I can make pages very small, but that will show all the records in a sequence. I would like to place the records anywhere on the page. (10 records placed on one page)
          let me know if I am not explaining this whole thing correctly.

            Comment

            • Anas Mosaad
              New Member
              • Jan 2013
              • 185
              #4
              What Seth has been trying to tell you is that you have multiple sections in your report. Make sure you are putting the records in the right section (i.e. details section not the header).

                Comment

                • Seth Schrock
                  Recognized Expert Specialist
                  • Dec 2010
                  • 2965
                  #5
                  If your sections (not the controls) aren't too tall, then do you have any page breaks in your details section? Is there any code in the report's OnLoad event that could affect the layout of the report?

                    Comment

                    • NeoPa
                      Recognized Expert Moderator MVP
                      • Oct 2006
                      • 32633
                      #6
                      Originally posted by Moji
                      Moji:
                      let me know if I am not explaining this whole thing correctly.
                      You are absolutely not explaining this at all clearly.

                      There are many points that might cause this behaviour, but as you give no real information about what you actually do have in the design of the report we could spend a long time guessing one after the other.

                      Alternativlely, you could actually consider what you have in your report and tell us, so we have something to work with.

                      If the sections of the report are not what you would think of as too big for one of your pages then you might check all the sections for the following properties :
                      1. Force New Page
                      2. New Row Or Col
                      3. Keep Together

                      This may help you find it anyway, but if not you really need to consider sharing the information of what you're working with if you expect help.

                        Comment

                        Previous template Next
                        Working...