Skip to main content

I have added a new field to a view, used by an existing crystal report.

The new field is added to the report. and the report displays the field correctly in Crystal Report preview, with data.

However, when the report is tested in IFS, there is no data. The field doesn’t appear:

I have moved around other fields to make sure that it is the correct report that is executed. All other changes are visible, but the new field that was added to the view.

Query data works without any problems.

Is there a step that I have missed/forgotten? What need to be done when adding an additional field to an existing view?

Issue have been resolved. 

The error was depending on the user running the report from Crystal Report server, user IFSPRINT.

IFSPRINT isn’t assigned to any company/site which prevented retrieval of data from certain views using validation of site access.