[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 65
  • Last Modified:

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

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
iif(iserror(sum([TransAmt]),0,sum([TransAmt]))

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
0
wlwebb
Asked:
wlwebb
1 Solution
 
Gustav BrockCIOCommented:
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.

/gustav
0
 
wlwebbAuthor Commented:
Interesting.........  I'll give that a try
0
 
MacroShadowCommented:
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.

MacroShadow
Experts-Exchange Cleanup Volunteer
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now