Results 1 to 7 of 7
  1. #1
    asoebye is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Oct 2021
    Posts
    3

    Invoice with a page two unrelated to the data

    I have a report which prints 51 invoices, each invoice on one page. Now I want to include some info to each receiver of the invoices, i.e. the SAME info to each.
    But I'm not able to place the information in the report so that each invoice gets a page two with the information part. The information is too long to be included on page one.

    How can this be done?



    Regards
    Asbjørn Søbye

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Very easy to do.
    Just put the additional info on a subreport with a page break before the subreport
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    asoebye is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Oct 2021
    Posts
    3
    Quote Originally Posted by isladogs View Post
    Very easy to do.
    Just put the additional info on a subreport with a page break before the subreport
    Thanks, that got me a step further.

    The invoice report is grouped by cabin number. I guess the subreport has to be placed in the section after the detail-section? The detail-section has one or two records. If it has one record, the subreport will not show. If it has two records, the subreport becomes visible, but the sum of the detail records jumps to the next page (together with the subreport) regardless of where I place the page break.

    Have I placed the subreport in the wrong section? I have tried the other sections and none of them gives the desired result.

    Regards
    Asbjørn

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Have you tried placing the subreport at the end of the detail section?
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    asoebye is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Oct 2021
    Posts
    3
    Yes, I have tried that too. The subreport repeats itself for each record (kind of logical?) But even now the subreport is missing if there are only one record in the detail section.

  6. #6
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    What is your "section after the detail section"? It could be a page footer or a report footer. This is subject to mis-interpretation by us, I think:
    I have tried the other sections and none of them gives the desired result.
    You put the page break above the sub and both in the page header? There can be a few properties at play here, such as grouping, keep with next, etc. Might be best to provide a sample copy if you can't figure it out. See How to Attach files at the top of this page.

    EDIT - even the report view can matter. You're looking at this in Print Preview?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  7. #7
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    This seems to work, but I don't have a lot of useful data to play with:
    - group header (in my case, EmployeeID): labels are in that header, not the page header
    - group header: controls just below labels
    - detail section: controls for multiple records pertaining to EmployeeID
    - group footer: page break then sub report container
    - group: force new page - After Section

    Hopefully I didn't forget something because I was experimenting a fair bit.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Unrelated data on one form
    By Homegrownandy in forum Access
    Replies: 4
    Last Post: 12-16-2016, 10:03 AM
  2. Replies: 2
    Last Post: 09-14-2015, 09:01 AM
  3. Replies: 1
    Last Post: 07-08-2015, 11:00 AM
  4. Replies: 3
    Last Post: 02-03-2013, 08:47 PM
  5. Displaying unrelated data on a form
    By FadingAPE in forum Forms
    Replies: 1
    Last Post: 10-06-2010, 10:33 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