Skip to Content
1
Former Member
Feb 18, 2014 at 08:11 PM

How to suppress an entire "row" if one field is null?

23 Views

Hello!

I have googled all morning and cannot find an answer for this. A couple things regarding suppressing DUPLICATES, but not sure how to apply that to my situation. So here's what we have.

I've created a report that is grouped by company name. In the details section it shows the contact name, fax number, title, email address and date updated from the "rolodex" table (where fields are applicable).

It's a very simple and straightforward report. But I will try to show an "example" anyway.

Smith Company

John Smith 555-123-4567 President PresidentJohn@SmithCo.com 1/1/1999

Jane Smith 555-123-4567 Accountant 1/1/1999

Jacob Smith 555-123-4567 Sales Mgr SalesMgrJacob@SmithCo.com 1/1/1999

Janet Smith GopherJanet@SmithCo.com 4/29/2002

Joe Smith 6/6/2006

What I would like to be able to do is... suppress the "rows" that do not have an email address.

For my purposes with this report, if they aren't showing an email address I really don't need to see their information. So I would like to see the following.

Smith Company

John Smith 555-123-4567 President PresidentJohn@SmithCo.com 1/1/1999

Jacob Smith 555-123-4567 Sales Mgr SalesMgrJacob@SmithCo.com 1/1/1999

Janet Smith GopherJanet@SmithCo.com 4/29/2002

As you can see, Jane and Joe didn't have email addresses so their entire "row" is not showing.

I cannot figure out a way to make this happen.

I'm using Crystal Reports 2013.

I'll gladly answer any other information needed to help you help me.

Thank you in advance!