3305 Main Street Ste 019 Vancouver, WA 98663

Intermediate Report Design Techniques Using Office Connector Query

Session Details

If you are already familiar with building reports using Office Connector Query, this is a perfect next-step. In this class, you will learn how to make your Office Connector Query reports more useful, interactive and powerful.

Audience Users of Sage 300 Construction and Real Estate - Office Connector Query
Length 90 minutes
Required Software Office Connector Query Designer
Recommended Previous Training In order for this class to be considered helpful, we STRONGLY recommend first taking the following class(es):
Delivery Live instructor with online meeting and teleconference. Normally conducted as group training with participants from multiple companies.
Format Lecture style with question/answer
Suggested Next Course Mastering Report Design Using Office Connector
Price $175.00 per seat. Receive a 50% discount on additional seat purchases.
To add this class to your cart, you must first enter your business e-mail address.

Enter Your Business E-mail Address:


For a list of available times:

VIEW CLASS SCHEDULE

NOTE: A registration password is required to successfully register for a class. The password will be emailed to you upon successful payment.


This is a lecture style class conducted via an online meeting and teleconference. Materials provide fairly detailed, tutorial-like instructions, so that you can work through the examples on your own time in order to cement what you have learned.

The instructor will cover the following objectives:

  • Review of Office Connector report design basics
  • Adding drop-down lists for parameter cells
  • Creating data entry columns that keep their values attached to the correct rows
  • Applying and using drill-down functionality
  • Adding subtotals
  • Using macros to update parameters and refresh reports

Note: Once purchased, training seat must be used within one year from purchase date. Unused training does not carry forward.