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

Report Runner

  • Report Runner facilitate running and management of Crystal Reports
  • Such reports can use the SQL Views generated by Data Views

Optional Tables

  • Store additional data in Sage 300 optional fields
  • Use Data Views to simplify reporting on additional data

Minimum
Requirements

  • Features relate to the latest supported version (currently v2022).
  • Data Views 2022 requires Sage 300 2022 System Manager.

How to buy

Talk to your local Sage partner Send message

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 3000
Website: 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)

Learn More