need to display empty campain

[#1]

i have a straight table following are the fields

emp id           contacts          leads          opportunities

344                  0                    0                        0

1111                 0                    0                    9

222                   1                   2                    1

333                    0                    0                     0

like this i have lot of records,scenario is if i have all three fields(contacts,leads,opportunities) are 0 then it should dislpay only related records. needed expression for this

[jonathandienst]

In the table properties | Presentation tab check the Suppress Zero Value option. If contacts, ideas and opportunities are expressions (not dimensions), then any row with all 3 zero will not be displayed.

I am not sure what you mean by related records? Please elaborate.