The only way I can think of this would be to create a formula that adds all field together, we will call it "GRAND Total", then use your selection expert on the main report to say Grand Total is greater than 0.
If you need the raw data in the bottom of the report, then I would recommend using a sub report to make the cross tab.