Results 1 to 3 of 3
  1. #1
    jasdem is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2013
    Posts
    27

    Subreport arrangement issues

    I have a number of subreports I am trying to display concisely on a single page. All of them are set to grow and shrink based on the information being displayed. In one section of the report I have 2 columns of subreports. The first column is set to expand based on a continuous subreport. The second column does not have continuous subreports, but two subreports that are stacked. The problem is when I go to report view the subreport in the first column and the subreport in the second column are aligned (which is what I want), the second subreport in the second column falls down the page and begins where the continuous subreport ends (not wanted). I am not sure what property is aligning the subreports but any help would be great.




    I hope that I was clear
    Attached Files Attached Files

  2. #2
    Dal Jeanis is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742

    Use Nested Subreports

    Hmmm. That behavior actually sounds right as a default.

    The answer, I believe, is to to use nested subreports. Create one subreport(2) for the second column that has the two right-column subreports(2A and 2B) as subreports of that subreport(2).

    A main report can contain up to seven levels of subforms and subreports. For example, a report can contain a subreport, and that subreport can contain a subform or a subreport, and so on, up to seven levels deep.
    http://office.microsoft.com/en-us/ac...010209281.aspx

  3. #3
    jasdem is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2013
    Posts
    27
    That worked, thanks for the help!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Subreport on form seach issues
    By mike02 in forum Reports
    Replies: 15
    Last Post: 06-06-2013, 08:31 AM
  2. Replies: 1
    Last Post: 04-15-2013, 10:02 AM
  3. Microsoft Access query name arrangement from the table
    By successfulfail in forum Access
    Replies: 3
    Last Post: 10-31-2012, 12:08 PM
  4. Replies: 3
    Last Post: 04-20-2012, 01:30 PM
  5. Columns in a subreport
    By kcm4491 in forum Reports
    Replies: 1
    Last Post: 03-10-2011, 12:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums