
Data Views
Simplify reporting of Sage 300 Optional Fields
- Turn Optional Fields into columns for easy report writing
- Create a View once, making it available to all report writers
- Speed up report running through more efficient access to data

Data Views Features & Usage
Features
- Optional Fields become columns, so no need for Crystal sub-reports
- Data Views is developed in the Sage 300 SDK
- Your custom Data Views form part of the Sage 300 database, and are included in the standard Sage 300 Dump and Load utilities
- Views can be recreated from Sage 300 after an upgrade
Use Case Example
- AR Customer table is ARCUS
- You have 6 Optional Fields stored in ARCUSO.
- You want to write a Cyrstal Report including all those fields
Without Data Views, you would need to:
- Include 6 outer joins to ARCUSO table, or;
- Write 6 subreports to pick up each of the Optional Fields
With Data Views, you simply:
- Join the ARCUS and ARCUSO tables into a single database view (e.g. EBCUS)
- Use the new EBCUS view in your the Crystal Report
Data Views complements other Orchid modules
Minimum
Requirements
Data Views 2021 requires Sage 300 2021 System Manager
International Contacts
Please contact us directly if your business is in the UK, Europe or other regions not listed here.
North/South/Central America and the Caribbean
Robert Lavery
Phone: (416) 453-7876
Email: Robert.lavery@sympatico.ca
Address:
Robert Lavery & Associates
14 Woodway Trail
Toronto, Ontario CANADA M8Y 2B8
Asia Region
A-Plus Software Limited (ID#82011633)
Phone: + 852-2366 8392
Email: info@a-plussoft.com
Website: www.a-plussoft.com/en/orchid.php
Address:
5/F Goldsland Building
22 Minden Avenue, Tsim Sha Tsui,
Kowloon Hong Kong
Australia and New Zealand Region
Sage Software Australia - Business Management Solutions (ERP & CRM)
Phone: 137 243 (13 SAGE)
Website: https://www.sage.com/au
Level 11, Zenith Tower B,
821 Pacific Hwy,
Chatswood NSW 2067
Africa Region
Sage South Africa (Pty) Ltd
Phone: +27 11 304 3000Website: https://www.sage.com/za
6th Floor, Gateway West
22 Magwa Crescent
Waterfall 5-lr, Midrand, 2066
Middle East Region
Sage Middle East
Phone: +971 43900180
Website: https://www.sage.com/en-ae/support/contact-us
Office No. 118 Building No.11
Dubai Internet City (DIC)
Dubai, PO Box 500198
United Arab Emirates (UAE)