Graphical, Web, and Mobile Query and Reporting
for IBM i (iSeries, AS/400) Users

Watch a One-Minute Capabilities Video | Build Your Business Case for NGS-IQ


NGS-IQ™ enables business users and analysts to write queries that can:

  • output to Excel, Access, Word, PDF, CSV, TXT, HTML, and XML
  • develop analytical reports
  • build multidimensional models
  • integrate Web reporting with charts and drill-down features into your intranet or Web portal

Query developers enjoy powerful, time saving features, including:

  • conditional (if-then), new column (field) calculations
  • run-time prompting for row (record) selection and calculation formulas
  • date formatting and arithmetic
  • simplified table (file) joins (inner, outer, exception, one-to-many, unions)
  • report break summaries and calculations based on summary results
  • SQL group by and having
  • program exits to support unique data access and manipulation processes
  • query usage statistics and change management
  • optional table (file) and column (field) aliases to make data elements easier to understand

NGS-IQ provides built-in email and FTP, plus the benefits of IBM i security and querying remote data sources.  You can modernize your reporting without adding another server or database to your network.

New Generation Software, Inc. also offers these solutions:

  • Qport Office—easy-to-learn tool that enables users to run IBM Query/400 queries from the Windows desktop and output to Microsoft Excel, Word, and Access.
  • NGS Query Developer Kit—affordable, one developer license of our query and Web reporting tools bundled with online education and technical support.

Customer Reviews

Duane Danner
Senior Programmer/Analyst, Avery Weigh-Tronix, Manufacturing

"Ease of use, creating reports on the fly. allowing other users to create reports and taking programming request away fron our RPGLE programmers. Support is awesome.

NGS was being used when I joined the company 20 plus years ago. We have many queries and have been using the product for over 20 years."

Van Truong
Systems Programming Manager, Inland Regional Center, Non-Profit Services

"Many users express that they love to run queries using NGS because it is easy, fast, and outputs reports to Excel."

Robert DiSalvo
Senior Software Developer, Steris, Medical Devices

"I appreciate how easy NGS-IQ makes it to query files in the system. The green-screen interface is good, but the separate desktop GUI client is even better. I can quickly develop a query and publish it to production. Using the web-interface my users have access to the query immediately. I am able to let them self-serve results from our 40+ year old system.

NGS customer support is the most responsive and helpful of any support team for any software company that I have encountered in my career.

Shawn Amick
IT Director, Ebix, Hospital & Health Care

"A great tool for extracting and sharing data. NGS-IQ works and works well. I've used the product to write literally hundreds of reports in the 10+ years that I have been a user. We have built significant business processes out of the data that we are able to extract from our system with this product. The ease of getting data out of our IBM database and out to Excel where it can be shared with coworkers or clients is fantastic. The product works well and is very well supported in the rare case that there is a problem. The regular, free training webinars offered are invaluable to picking up and learning more about the capabilities."

View Benefits for Every Industry


NGS-IQ Brochure

Advantages of NGS-IQ over IBM Query/400

Review the NGS-IQ Architecture Diagram

Order a FREE Trial

Request a Conference Call to Discuss Your Needs

IQ Connexion SmartView IQ SeQure Qport Access IQ Client IQ Server

Request Literature

Discuss Your Needs

IBM i Solution Edition

Find Your ROI

Follow Us

Privacy Policy

3835 N. Freeway Blvd, Suite 200 Sacramento, CA USA 95834
Office: (916) 920.2200 Sales: (800) 824.1220 Support: (800) 257.2442 Fax: (916) 920.1380

We Use Cookies

Site Map

Copyright & Copy; New Generation Software, Inc. All rights reserved.