are you using more than one table adn if so are you doing outer joins?

If you are doing outer joins are you using a select statement?

How many tables are in the 'Selected tables' window?

If there are more than 1 go into the Links tab of that window.

double click on the joni line and see what the join type is.

If it is an inner join you need to make it an outer join. Left or Right depends on whcih way the tables are set to.

This is odd...

 

If you remove the phone# field from your report all the records show up, but if you drag and drop the phone # field onto the detail section records start to disappear.

is that a correct description?

Likely you have a CONTACTS table and a PHONE table which are joined togther as an inner join on the CONTACT ID field.

IN your Field explorer (top of your tree), expand the Database Fields.

Now you should see 2 or more table names (CONTACTS and PHONES). If you expand the table names you will see the fields/columns in each table.

 

Here is what I am pretty sure is happening.

Crystal does not enforce joins just by making the join (like in SQL). You have to tell it to be enforced in the join set up or it will enforce the join when you use fields from both tables anywhere in the report. So when you exlude the phone number all the contact names appear. As soon as you use the phone number the join is enforced and the names disappear becase ther eis no row in the PHONE table to match to any row in the CONTACTS table.

Is this more on track?