Description
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 | |
| 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 | |
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.