Link to home
Create AccountLog in
Avatar of BD
BDFlag for United States of America

asked on

How to hide a sub-report if it has no data?

I have a sub-report within a master-report that at times does not have any data to display for the linked master-report.  Due to some graphics I have in the sub-report, the sub-report displays at all times, but I would like to hide the sub-report (turn off its visibility) during those occasions where there is no data.  I have a text box in the master-report that indicates true/false if the sub-report is empty (has no data).  I know I want to do some kind of macro or if else statement to turn the sub-report's visibility on and off.  I just don't know how...

The master-report is called: R_Activities_sub1
The sub-report is called: R_Activities_sub2
The true/false textbox in the master-report is called: subgood
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer