I have three tables that I exported from RE: CnBIO, CnGF_1, CnGF_1Note1_1, that contain the following fields: First Name, Last Name, Gift Amount, Gift Balance, and a Gift Note

The issue I am having is that if a record does not have data in one of the fields, such as the Gift Note, it does not show that row/record at all.

Any suggestions,

Thanks!

Bryce

Yes this is correct. That's why you need to use a formula If not IsNull(Field Name) then Field Name else 0

Thanks for the quick response.

Where can I enter this formula?

Well as far as I know it should not affect text or general fields. Usually it's number fields or currency. So let's say you want to get a sum and Gift Amount is blank you won't be getting your total. It shouldn't really affect text fields.

So then this does not seem to be a viable solution, eh?

 I was wondering how the formula you suggested would be used during the import portion of creating a new report...

No it's just within the report. How you describe the problem it looks like some conditional formatting was done on section if you right-click on a section you could see the formatting. Double check this. It could be Suppress if blank or similar.

I right-clicked within the report and went into the Section Expert. Unfortunately none of the tabs had "Suppress Blank Sections"