NGS-IQ offers built-in email, FTP, and the benefits of IBM i security. It also allows remote querying and queries to remote data sources. Modernizing your reporting is possible without adding another server to your network. NGS-IQ™, which is used by business users and analysts, allows them to create queries that can be output to Excel, Access Word, Excel, Word, PDF and CSV. They can also build multidimensional models and integrate web reporting with charts into their intranets or web portals. Powerful, time-saving features for query developers include: conditional (if–then), new field (column) calculations, runtime prompting to select row (record), and calculation formulas; simplified table (file); joins (inner and outer, exception one-many, unions); program exits to support unique data accessibility and manipulation processes; query usage statistics and management.