Table not displaying data in Solomon 5.5

[cis12232004]

I amended an existing report in Solomon 5.5 using Crystal 8.5 by linking another table to the existing one. I then included one of the fields from the new table to create a report that would show not only the vendor ID but also the vendor Name. My problem is that the report displays data on the first run but then it displays a blank report. Is there something I missed? When I try to run the report without the new field, it displays perfectly.

 

[smcnulty2000]

Any chance that the sql query is returning 'no records found'?

What happens when you go to the 'Database, Show SQL Query' menu?

scottm.