Data Views

Information Manager Data Views can be used to simplify the Sage 300 optional field database structure for use in reports. 

For example where the AR Customer table is ARCUS, the optional fields are stored in ARCUSO.  If you have 6 optional fields – to report on them all in one report against the ARCUS table in Crystal Reports, you would need 6 outer joins to the ARCUSO table or 6 subreports to pick up the data. 

Writing a database view to join the ARCUS and ARCUSO tables into one view, you can simplify the Crystal report by including only the view (for example EBCUS)  in the Crystal Report.