By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,273 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

drop label if field is empty

P: 1
In order to clean up a report's appearance, I want to drop the label if the associated field is empty. I'm currently exporting the report to word and then editing out 'blanks', but this is time-consuming.
What do I need to do to the label in the subreports to not print if the field is empty? (or do I mean nil?)
Oct 9 '06 #1
Share this Question
Share on Google+
1 Reply

P: 143
If you don't want to print out blank records, use Is Not Nulll as the criteria of whichever field you do not want to show.
Oct 10 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.