Suppressing blank fields and duplicate rows

I actually did try that and it had no effect.  The results still show up the same way.

can you test the blank field and see if it's really NULL?  Null is different than empty...
to test, you could put a color formula on that field....

if it's not really Null, then you'll need to change your suppression formula....

Ok, I think I may need to go into a little more detail.    Here are the three tables I'm working with:
net_res = Asset table
ctct = Contact table
lrel = relationship table

From net_res, I need the nr_prim_search_key field which is the asset name.  There is also a field called nr_prim_c_id which links to the contact table id field.  There can only be one primary contact per asset so I made that an Inner join.  The problem is that when a primary contact is chosen, a record is also placed in the lrel table.  I think this may be part of the problem.  So, in order to get the asset name and primary contact, I link net_res.nr_prim_c_id -> ctct.id.  I put net_res.nr_prim_search_key in the detail section along with ctct.c_last_name and everything is working fine.  I get output like this:

NAME                        PRIMARY CONTACT
=====                        =================
CI -0000000001         John Smith
CI-00000000002        Mary Jane

That is working fine because there is only one primary contact per record so I have no blank lines.
Now onto adding the Alternate Contact(s).  There can be none, one, or many.  The alternate contact records are stored in the lrel table so I link net_res.persid -> lrel.r_persid  and lrel.l_persid -> ctct_1.persid.  I make them all inner joins.  After I make these joins and before adding any fields, I refresh the data.  I now have two rows for each asset and the primary contacts are listed twice.  I am assuming this is because a record is created in the lrel table for the primary contact.

NAME                        PRIMARY CONTACT
=====                        =================
CI -0000000001         John Smith
CI -0000000001         John Smith
CI-00000000002        Mary Jane
CI-00000000002        Mary Jane

I suppose this is the first problem I need to correct.  If I add the Alternate Contact, I see output like this:

NAME                        PRIMARY CONTACT                  ALTERNATE CONTACT(S)
=====                        =================                 =====================
CI -0000000001         John Smith                                  
CI -0000000001         John Smith                                  Tyler Grant
CI-00000000002        Mary Jane
CI-00000000002        Mary Jane                                   Ty Dickens