Recent content by mikebird

Well, tell me if I'm wrong but it's the cross-tab which does the business. I can run a SQL query pulling the two fields and a count, where I'll get no zeros there. But the cross-tab is key. The set of values for one field goes all down the left side. The values for the other field go across the...

I have a good history of hundreds of reports. Usually I get past the hurdle of hundreds of zeros I don't want by suppressing empty rows and columns in cross-tabs. Here there are the odd 1s and 2s so the rows and colums have to remain. I can't see how to introduce a formula for every cell to...