[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 173
  • Last Modified:

Exclude a page in a report

Hi Experts,

Hopefully this will be a fairly simple one....

I have a report containing a sub-report, e.g:

        Category 1 details
        Category 4 details
        Category 7 details

I need to have an optional page in the report if a particular Category is present, say 4 in this example.

What is the best way to check the sub-report recordset to see if Category 4 is present (it won't always be) - do I need to loop thru the recordset when the report is opened to check if there is a Category 4 record or is there an easier way to do this?
1 Solution
Nico BontenbalCommented:
At the footer of your subreport you could add a (hidden) control with a source like:
Than on the main report you could refer to the value on this control on the subreport in code like this
If this doesn't help could you upload a sample database with some data and the sub and main report as you have it now.
redpoppyAuthor Commented:
Thanks - that works a treat.

Featured Post

Industry Leaders: 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