suppress page header in case there is no records+crystal report

MKItani used Ask the Experts™
how i can suppress page header in case there is no records
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
use the section expert and create a suppression formula under the X2 button for the section band.  You can test for the record  using a formula like value=0  for one of the values in the recordset
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

That works if you know a value for the first record.  In general you won't know the vlue unless there is one that is fixed.

You could suppress with a formula lie

Count({SomeFIeld}) = 0


Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial