Access 07- Subreport to Print if query result is Null with "NONE"

Posted on 2014-08-19
Last Modified: 2016-06-15
Hello Experts,

I have a Report that has several subreport sections.  One of the subreports I think is critical to print EVEN IF the query that is the Record Source is Null.

I would like for that Sub Report's Header labels to print as will as a Label in the Detail area that says "NONE", and then the Report Footer section to show Zero's.  The data detail for the report has a field called TransAmt so in the footer I put

However, when I "View" the Overall report that Subreport shows.  But when I "Preview Print" or actually "Print the form it disappears if the query isnull.

Is there a way to force it to show?... OR will I have to add a calculated field in my query that forces a null ID or "none" field
Question by:wlwebb
    LVL 48

    Accepted Solution

    Before you run the report, check if records exist for the subreport.
    If not, change the recordsource of the subreport to pull one permanent dummy record from a table you create for the purpose.
    If yes, change the recordsource of the subreport to what it normally uses.


    Author Comment

    Interesting.........  I'll give that a try
    LVL 26

    Expert Comment

    No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

    I have recommended this question be closed as follows:

    Accept: Gustav Brock (https:#a40271941)

    If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

    Experts-Exchange Cleanup Volunteer

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now