Added Table Reduces Output

[MikeCopeland]

Using CRXI...
I have a report application that's been working well for several months. Now, a pair of new fields from a new table must be added: there is no change to the Select criteria, just addition data on the (only) detail line.
I am using (new) formulas to format the new data, and I am linking to 2 new tables via a data field that's been used throughout the old report. However, when I add the 2 formula data values the only data on the report is for database records that have non-null data in the new fields.
Here is one of the formulas (they are both similar, and removing the other has no effect on this problem):

// Annual Family Income
WhilePrintingRecords;
if IsNull({FCCommMain.SalaryRange}) then ""
else {CommunicationAddDropDowns.Description}

Adding this field to the Detail line and using the Database Expert to add/link the new tables are the only changes I made to the report. Prior to these changes, the report produces thousands of output lines, but now the only lines are those where the the values of FCCommMain.SalaryRange are non-NULL. When I remove the formula references (both of them), the report is okay.
What might the references to the new tables via only the formulas be doing to eliminate data output? TIA

 

[lbass]

You need to use left joins FROM the old tables TO the new tables.

-LB