Results 1 to 2 of 2
  1. #1
    JustMePatrick is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    1

    Question Skipping Pages in Report When SubReport has No Data

    Hello all,

    I'm attempting to assist my colleague with his DB.



    In the report he generates sometimes one of the subreports has no data. He wants it to skip to the next item and not display the report for that item.

    For example:

    We have a report that generates for different locations. The report has multiple sub reports based off the location all in one page.
    Say location 52, Details subreport has no records. What we would is for the report to skip location 52 if Details has no data.

    We've googled and tried a few Filters with no success, and I hope I was clear with what we're trying to accomplish.

    Thanks,


    Patrick

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    In the query ,use inner join, on the 2 tables.
    Then there will not be any empty subreports.

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

Similar Threads

  1. Replies: 1
    Last Post: 01-24-2017, 06:31 PM
  2. Replies: 1
    Last Post: 04-15-2013, 10:02 AM
  3. not print blank pages when a subreport is empty
    By fabiobarreto10 in forum Reports
    Replies: 3
    Last Post: 04-28-2012, 10:01 AM
  4. Replies: 3
    Last Post: 06-23-2010, 02:02 PM
  5. Blank pages between report pages
    By jonsuns7 in forum Reports
    Replies: 2
    Last Post: 10-01-2009, 05:06 AM

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
  •  
Other Forums: Microsoft Office Forums