Supporting Mobile Workers with Tablets, SmartPhones, and Email Alerts
December 7, 2011
Today's workforce wants to be able to receive their data and interact with it on smartphones and tablet computers as well as on their laptops. They also expect to receive timely email alerts about critical business conditions and to be able to access information anywhere, anytime. This demonstration shows how you can use the WebRunner function of IQ Server to give these mobile users on demand access to graphical Web reports from Android, Apple, and other devices. The presentation also includes a segment on using the Windows 7 Task Scheduler to run queries with Qport Access and WebRunner. Lastly, there is a demonstration of the new email distribution list function included in release 7.1 of NGS-IQ. Approximately 75 minutes.

Tips from the Field and Getting Ready for Release 7.1
August 10, 2011
A Logistics and Planning executive presents how his company uses NGS' SmartView and IQ Client to simplify access to sales, inventory control, order fulfillment, and other critical information. Plus, an overview of the enhancements NGS has planned for Release 7.1 of NGS-IQ. If you watched this presentation live, we re-recorded the demonstration of the new IQ SeQure Query Inventory feature to better present its capabilities, so please log in and watch that segment again. Approximately one hour.

Meta Files, Cascading Style Sheets, the IQ SeQure Query Inventory Feature, and Announcing the IBM-NGS Solution Edition Partnership
April 6, 2011
Discover how easily you can create meta files to simplify working with your data, see how using cascading style sheets can save time and help create better looking Web reports, get a preview of the new Query Inventory feature that will be included in the next release of IQ SeQure, and hear how IBM is enabling NGS customers to save 30% and more on a new POWER7 IBM server. Approximately one hour.

Introduction to SeQure, NGS-IQ's Security Management Module
Re-produced March 2011
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.

Overcoming Database Obstacles and a First Look at the Next Release of NGS-IQ
December 15, 2010
NGS-IQ offers a variety of powerful functions so that you can work with just about any data to get the information you need and store it for future reference. In this session, you learn how to do the following: 1) join files on a new field created in your query, 2) join files using record selection, 3) design a query so that the destination of its output on the Integrated File System (IFS) is a variable you control at run time, 4) include your query's name and library in your output to Excel when using Qport Access, 5) and learn about the new Web charting and drill down functions planned for the next release of NGS-IQ.  Approximately one hour.

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.