I have created some reports in Crystal reports 2008 which work fine when opened directly from Crystal reports.

Unfortunately the client would like to be able to open these reports from any workstation that has access to Sage, so must be able to open these reports directly from Sage 300.

When opened directly from Sage 300, the reports open without alerting any errors, but many of the fields are missing.
The report displays the fields which contain dates and numbers, but the string fields and their titles are not displayed.

All the dates and numbers displayed in the report are correct.

The report draws from a separate database external to Sage, with this obstacle being resolved by including a Sage database table which I do not actually use in the report.

I have tried creating a view instead of querying tables, and got the same results.

Any ideas?