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|
|Required Software||Office Connector Query Designer|
|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.
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.