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

x
  • 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:

Location
        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?
0
redpoppy
Asked:
redpoppy
1 Solution
 
Nico BontenbalCommented:
At the footer of your subreport you could add a (hidden) control with a source like:
=sum(iif(category=4,1,0)
Than on the main report you could refer to the value on this control on the subreport in code like this
me.subreportname.report!ctrname.value
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.
0
 
redpoppyAuthor Commented:
Thanks - that works a treat.
0

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