Events

NGS' Share and Learn Webinar Playbacks
See Our Short Tutorials - Less Than 10 Minutes! | Playback Archives

Email Alerts, Temporary Work Files, Field Conversion, and Comparing Group By to Report Breaks
August 18, 2010
Learn how to use NGS-IQ to send email alerts that notify users of important business conditions, create the structure of temporary work files in IQ Client without having to upload and run the query that creates them, convert character values into numeric values and numeric values into character values in your database, and understand the differences between summary results produced with the Group By and report break functions. These four topics are presented in separate segments, so you can skip directly to the ones you want. Approximately one hour.

Using the Report Table Function and Using NGS-IQ to Create a Web Form that Updates DB2
March 18, 2010
The report tables function is powerful, but frequently overlooked by query developers. In the first half of this presentation, you will learn how report tables work and see how to design a query with three report tables that calculate sums, averages, running totals, rankings, and more. Do you think NGS-IQ is just for writing queries? Think again. The second half of this presentation shows how you can use NGS-IQ to create a live Web form that supports data entry, input validation, and an e-mail confirmation message delivered with an Adobe PDF as an attachment. Approximately one hour.

Concert Series
February 17, 2010
Watch this overview of the new features that were delivered in the most recent release of the Concert Series G/L, A/P, A/R, Payroll, and Human Resources software. Approximately one hour.

NGS-IQ Release 7.00 Update: Web Reporting, E-Mail, Report Distribution, and
SmartView Enhancements
December 9, 2009
Get an overview of the latest NGS-IQ enhancements that are now available in an update to Release 7.0. You'll see how to use the new WebRunner feature of IQ Server to run queries from your Web browser and output your results directly to Microsoft Excel and Adobe Acrobat; work with the new WebRunner keywords to embed NGS-IQ query processing into Web pages and portals; customize the e-mail distribution list, subject, and message sent with your query output each time you run a query - without having to revise the query definition; add calculated fields to your SmartView models; and export SmartView data to HTML and Excel. Approximately one hour and five minutes.

Designing Web Reports with IQ Client, Using the IQ Server Web Runner Interface, Designing Web Reports That Support Ad-Hoc Drill Down, Integrating NGS-IQ Reports into Web Pages and Portals, and Using the Qport Access Transfer to Host Feature
August 19, 2009
See the power of NGS-IQ Release 7.00 in this educational session that explores the new HTML report design features of IQ Client; the new IQ Server Web Runner feature that lets you run NGS-IQ queries from your own Web pages, portals, applications, and SmartPhones; how to use the NGS Business Performance Dashboard module to create a custom Web user interface to Web reports; and how to design queries with built-in "Web Links" that enable a user to drill down from summary to detail on demand as they view query output with their Web browser or SmartPhone. This presentation revisits the valuable and often overlooked Transfer to Host function of Qport Access to create DB2 files from data stored in Microsoft Access and Excel. Transfer to Host has been a standard Qport Access feature for many years. Approximately one hour.

Calculating Elapsed Time, Designing Reports with Running Balances, an Introduction to ShipView Plus, and an Update on the Features Planned for Release 7.0
March 18, 2009
Learn how to use NGS-IQ's IQDATE and IQTIME files along with the remainder function to design a query that calculates elapsed time in days, hours, minutes, and seconds between two events. In addition, see how to use the previous function of NGS-IQ to create a conditional new field that calculates the running balance of a numeric field. Third, get an overview of the new ShipView Plus transportation analytics solution developed jointly by NGS and Varsity Logistics using the NGS-IQ suite of software. Finally, enjoy a preview of the upcoming release 7.0 IQ Server Web interface and IQ Client Windows desktop query development module. Approximately one hour.

Advanced Query Development Tips, the Query/400 API, Dashboard Development, and the New Release 7.0 Web Interface
December 10, 2008
Learn how to use NGS-IQ's previous, skip, and count functions to overcome the challenges of "one-record-to-many-record" joins and to create "top n reports"; see how the Query/400 API enables users to enhance and run Query/400 queries from NGS-IQ; get a quick overview of the NGS Business Performance Dashboard development process; and see how the upcoming release 7.0 of NGS-IQ will enable you to combine dashboard components and the new IQ Server Web Interface to create easy-to-use, custom Web pages for end users. Approximately one hour.

For a limited time, NGS has waived the license fee for a two-concurrent user license of Qport Office to qualified IBM i customers who complete an NGS Software License Agreement. Read more.

Cross-Platform Data Access with NGS-IQ and IQ Connexion
August 12, 2008
Get a first look at IQ Connexion, the newest module of NGS-IQ. IQ Connexion enables NGS-IQ users to develop reports and presentations over data stored in SQL Server, MySQL, Oracle, PostgreSQL, and DB2 databases on other platforms. Find out how easy it can be to use NGS-IQ as the reporting and business intelligence engine behind all the databases used in your enterprise. Approximately 25 minutes. Part 3 of 3.

An NGS Customer Demonstrates How His Company Uses IQ Client and SmartView
April 17, 2008
A step-by-step demonstration of how to use IQ Client (the Windows desktop query development module) and SmartView (the NGS-IQ OLAP module), presented by an actual NGS-IQ customer. Includes a question and answer session at the end. Approximately 55 minutes. Part 1 of 2.

Introduction to SeQure, NGS-IQ's Security Management Module
April 17, 2008
An overview of the benefits of the NGS-IQ SeQure security management system with a demonstration, lead by an NGS-IQ Support Specialist, of how you can use IQ SeQure to control database and query security. Approximately 35 minutes. Part 2 of 2.