I have a program that exports data that I use Crystal Reports to make a report with. The problem is that the program that exports the data makes a row of numbers where every other row is my data and every other row is a 0. Example:

4 5 8 2 9
0 0 0 0 0
2 2 4 5 6
0 0 0 0 0
1 1 4 5 6
0 0 0 0 0

I've used formula fields to define each different row, but is there a way I can use formula fields to skip the 0's so the data above would like like this. Example:

4 5 8 2 9
2 2 4 5 6
1 1 4 5 6

I don't want to use select expert for this, because it will screw up the rest of my report.

Edited by waterboy550 - 02 Jul 2007 at 5:55am

No, zeros will never be valid, they should always be removed. The rows of zeros are in my data source, another program writes them. Like I've said I could use select expert to show only the ones without zeros, but this would effect the whole data source and not just the fields that i need this applied to.

Oops! I forgot to say you suppress the detail row.