During this presentation, we explain and demonstrate:

• when and how to use the PREV (previous), *COUNT, *COUNTN, and *SKIP functions to calculate running totals, count rows, and reset row counts at different report breaks
• how to skip rows when specific conditions are met
• how to develop a query to return accurate values when the rows in two Db2 on i tables have a "one-to-many" relationship

The sample queries used to illustrate these functions are shown in both the graphical IQ Client and 5250 host interfaces. Approximately 60 minutes.

During this video, you'll learn how to use NGS-IQ's Previous Record Value (PREV) and Group By functions, link queries for sequential processing, and take advantage of SmartView's time saving import charts feature. 56 minutes.

During this video, you'll learn how to use NGS-IQ's report distribution features to burst and deliver separate sections of a query's output to different email addresses and network directories. You'll also learn how to access other valuable release 7.2 educational videos. 58 minutes.

During this presentation, we show you how to take advantage of more NGS-IQ release 7.2 enhancements, including:

• two helpful new field functions
• the search query definition template command
• the email job log and query definition template function

We also step through making reports more helpful to decision makers by adding analytical summary tables to your report breaks. After building a query with these summaries, we use IQ Client's web report design features to format the query output. 55 minutes.

During this presentation, you'll see how to develop and run queries to populate detail and summary data to different sheets of a Microsoft Excel workbook. You'll also learn how to use the new extended record selection feature and how to take advantage of the different ways NGS-IQ can generate Adobe PDF files. 50 minutes.

During this presentation, we contrast the different ways you can output queries to Microsoft Excel to help you decide which method is best for any business requirement. We also explain the new CSV delimiter and escape character settings, commands to help you manage email distribution lists, and keywords you can use to integrate NGS-IQ web reporting into applications. 55 minutes.

During this presentation, you'll learn how to:

• use and link Qport Access .IQP files to automate output to Excel sheets
• use IQ environment variables to pass run-time variable entries to queries that you run as a series
• design a web report to draw attention to important values
• customize the web reporting user interface
• use email distribution lists

Approx. 55 minutes.

We welcome NGS-IQ users to watch this preview of the forthcoming major new release of NGS-IQ. You'll learn about and see some of the enhancements we have planned. Note: Release availability and new features are subject to change at any time. 55 minutes.

Learn when to use a new field or record selection to add run-time prompts to queries; how to work with inconsistent data values to support accurate file joins, sorts, and summaries; and how NGS-IQ supports Microsoft Power BI's advanced analytics features. 60 minutes.