Results 1 to 3 of 3
  1. #1
    caniread is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2015
    Posts
    86

    Hide Report if no data


    I have a report that I dragged a bunch of other reports onto. It shows all the reports in the report but does not print the ones that have no data. That is what I want but is there any way to also not show them on the report if there isn't any data on them? I have looked around and was not able to find an answer for this particular situation. Not a huge deal but it would be nice to eliminate them if possible.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    try this,
    In the report header ON PRINT event,
    check the record count of the query the report uses, hide the sub reportr if zero.

    child1.visible = dcount("*","qsTotalDept")>0

  3. #3
    caniread is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2015
    Posts
    86
    I just got to try your solution but it did not work. When I print all the blank report do not get printed but they do show up on the screen when viewing report. Any one know how to hide them if they have no data?

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

Similar Threads

  1. How to hide data on my report
    By access_db_user in forum Reports
    Replies: 3
    Last Post: 12-29-2015, 03:50 PM
  2. Replies: 6
    Last Post: 12-14-2015, 03:25 PM
  3. Hide an attachment in a report
    By FJM in forum Reports
    Replies: 12
    Last Post: 10-10-2014, 12:17 AM
  4. Hide data
    By Rustman in forum Access
    Replies: 1
    Last Post: 03-25-2013, 02:54 PM
  5. Hide Report on Textbox Value
    By alyon in forum Access
    Replies: 4
    Last Post: 07-29-2011, 11:19 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