Suppressing rows in Crystal Reports

[~J~]

Ooooo, this has got me!!

Got a report on my screen, text labels down the left with field values on the right, something like...

Sales £100
Expenses £200
Rent £400

etc.

There are several 'value' columns, dealing with actuals, budgets, variances, etc.

What I need to do (or rather the customer wants!) is to suppress a line if every value is a zero.

For example the following 2 lines would be shown...

Sales £100 £200 £300 £0
Expenses £300 £0 £150 £2

But if one of the rows is full of zeros, then it totally hides the line.

I know there's an option to suppress fields if they don't contain a value, but I need to suppress the entire row (including the label), thus automatically shifiting every other row up if the entire row is full of zeros.

Any ideas if this is possible?

 

[~J~]

Already tackled that mate, trouble is if the query doesn't return anything, for example if "Rent" is nothing, then I can skip over it on the SQL query no problems.

However, I've not got a 'fixed' and hardcoded label called "Rent" which needs to be supressed seeing as the query has returned nothing.

 

[~J~]

Yeah tried them, no joy really.

I think i'll need to create the code in the formula, not that much of a problem other than time really as there's 8 columns with about 36 lines of nominals so that's about 192 formulas need writing.

Cheers anyway, appreciate it.