|
Workshop Lesson Description
Do you own a license (or two or three) of Qport Access or SmartView, but have not deployed these NGS-IQ modules? Or maybe you’re not using all their capabilities? Then take advantage of a valuable opportunity to expand your users’ query and reporting skills by scheduling an NGS-IQ Desktop Module Workshop—either at your company location or online. The low-cost Workshop provides step-by-step instructions and a comprehensive manual to help streamline your query and reporting process, while maximizing user productivity and your return of investment in the NGS-IQ modules.
Class Content : Pre-defined exercises taught lecture style, using sample DB2 data on NGS' IBM i server. Focus is on features and functions of the client modules (Qport Access, SmartView) and simplification of users running reports from desktop icons or hyperlinks in Windows applications. Other lessons include output from IQServer (IQ Client, Qport Builder) to PDF, XML, HTML, and e-mail distribution.
Profile of Attendee: Current or potential end users of these modules (no product knowledge required) and IT staff.
Class Time: 3 to 3-1/2 hours (average)
Description of Lessons:
1. |
Enhance Microsoft Excel reporting: Output one or multiple queries to workbooks, sheets, and named ranges; save formatting; append or replace data in sheets and ranges. |
2. |
Link Excel spreadsheets to other Windows applications: For example, PowerPoint presentations of charts and graphs created from Excel output are automatically updated when the query is re-run.
|
3. |
Create SmartView reports and graphs: Use the report layout, create multiple views or presentations from one query to reduce future query revision, filter records in SmartView for specific analysis or graph needs, highlight critical values, drag and drop format, create graphs using the Chart Designer or Chart Wizard, design and save graph templates, copy SmartView data to Windows applications, and save as a PDF. |
4. |
Use .IQPs to simplify report processing for users: Design desktop report folders for frequently run reports or create hyperlinks in Windows applications (e.g., Excel spreadsheet) to run NGS-IQ queries so users can simply click on hyperlinks for their reports.
|
5. |
Daisy-chain two or more queries to run directly from Qport Access. |
6. |
Create and update DB2 files with transfer to host feature of Qport Access: If you have non-DB2 data that is needed on your IBM i for query creation, this secure transfer makes this a breeze and eliminates manual data entry. |
7. |
Schedule NGS-IQ reports to run from your PC using the Windows Task Scheduler. |
8. |
Create PDF output. |
9. |
Create drillable HTML reports. |
10. |
Distribute reports via e-mail and messages to cellular phones. |
11. |
Design XML files. |
To request more information and pricing or to schedule a Workshop,
please call: 800-824-1220
Jeff Coley, ext 228
|
