Sage 100

AR_CustomerShiptoTaxExemptions file - there are some records in this file with blank tax exemption fields. They print when I have no selection criteria. When I try to print ONLY those records with blank tax exemptions, I can't get it to work, no how, now way. Have tried null (even though I have the null set to default), """", "" "", less than ""0"", less than ""a"", not equal to ""anything"" but those blanks will not print unless I have NO selection. Tried it in both Crystal 10 and 11 and no luck either way. Any suggestions or clues?

Do you want a report or just a data dump? Try an Excel query or a VI export if you just want the data.

A report. And I want to know why, because that's how I roll. :-) Client wants a report she can run listing customers with no tax exemption who have shiptos that HAVE tax exemption, and I can't even get the dang ""customers with no tax exemption"" part to work!

Maybe first try a report will all records and test the conditional suppression on the details where a code exists. Perhaps it can help you find the secret.

THat's actually what I started with, which is how I knew there were some records out there. I either get them all, or I get everything with an exemption, or I get nothing. Just can't get those blank ones!

Not sure if this will help, but I tried a report that may get you part way there. It uses a running toal to analyze the codes per customers and a conditional if/then for suppression. It's not pretty but functional, more or less.

Bill - thanks for the effort and I'll see if I can work it into what my original goal was. But we should not havet to go to this much trouble to get those records to print! Something wrong in the data dictionary or something? Just doesn't make sense. You can print records in other files that have blank or null in one of the fields, for Pete's sake.

Via good ol' DFDM, are the fields truly blank or is there a hidden character?

They're null. []

Maybe I'm missing something. I'm able to see them by using Isnull({AR_CustomerShipToTaxExemptions.TaxExemptionNo})

Damn it - that does work. But it doesn't work if you check the USe Default Values for Null check box, which I always have checked. So maybe the data dictionary doesn't have the default values set correctly, however that might be done. Hm. It's always the obvious things...

I don't like that file as it does not contain a record for every customer/Ship To on file. I noticed that some ship To's were missing (presumably because records were either imported or user disabled Sales Tax reporting when setting up AR). Add total record count from AR_Customer and SO_ShipToAddress to see if it equals what the exemption file shows. To get your report, you'll need all the records.