New LGX Ad Hoc Report Builder Optimizer Edition Adds Key Data Manipulation and Security Features for Growing "Power User" Base

Share Article

Premier business user reporting product from LogiXML adds advanced grouping support and calculation enhancements to its popular Web based report builder.

LogiXML ( announces the release of LGX Ad Hoc Report Builder Optimizer Edition, adding advanced features for data manipulation and security to support the needs of the increasing base of "power users."

LGX Ad Hoc Report Builder Optimizer Edition is a web based reporting system that provides an environment in which non-technical end-users can build and create their own queries and reports without knowledge of databases and SQL and offers administrators a web based management tool for defining security roles.

"Our goal is to be responsive to our users which drives our aggressive upgrade cycle for the LGX Ad Hoc Report Builder," said Arman Eshraghi, LogiXML CEO. "Our growing customer base of corporate end-users, ISVs and ASPs are not only committed to a zero footprint, Web-browser-based reporting, they also demand a feature-rich reporting environment that helps increase productivity. LogiXML is responding with a stream of additional features and refinements in the Optimizer Edition to support effective decision-making and easy administration."

Security Additions

Security enhancements for administrators allow them to define the access privileges of LGX Ad Hoc Report Builder users in the form of role packages that simplify the process of assigning "Roles" and "Rights" to end-users. The new version also supports assignment of an expanded set of rights to end-users such as application and security administration, report management and report scheduling as well as the ability to control access to shared folders based upon roles.

More Powerful Data Manipulation Capabilities

Feedback from LGX Ad Hoc Report Builder users reflects their desire to accomplish more manipulation of data in the tool itself, which has lead to a number of new capabilities in the Optimizer Edition. These include:

Improved grouping features which supplement the original drill-down style grouping with the new "flat grouping" that shows all detail rows in a grid with headers and footers for aggregate values. Flat grouping is key feature for analysts who want to see all the report details at once and is ideal for Excel exports.

In addition, reports can now be grouped on any number of columns, defined up to five levels of grouping; multiple aggregates for columns included in the main report can be specified.

Calculated and statistical columns have been enhanced so that they are now run on the database itself for improved performance and calculated column formulas now support more data types, including non-numeric columns. Users can now use calculated columns with initial sort order, grouping, charts and report parameters. New statistical columns show "numeric" or "percentile rankings," "running totals" and "difference" between current and previous row's values.

Plus, "virtual views" give administrators the ability to create customized views for end-users and for those who want to convert their reports .pdf files, export to .pdf is now faster, scaleable, more reliable and included in the base product at no extra charge.

LGX Ad Hoc Report Builder Optimizer Edition builds on a solid product foundation, adding many new features for end-users and administrators. LGX Ad Hoc Reporting Optimizer Edition is built on XML technology, supports major databases including Oracle, Sybase, MS SQL Server and MySQL and can be deployed across any .NET architecture.

About LogiXML, Inc.

LogiXML builds powerful Business Intelligence reporting and analytics tools that are easy to learn, use, deploy and maintain. Our tools help organizations make better, timelier decisions by transforming disparate data into critical business information.

LogiXML's growing base of customers includes leading organizations in Telecommunications, Life Sciences, Finance, Logistics, Education, Computer Hardware and Software, Retail, Non-Profit and Government. LogiXML stands as a leading provider of BI tools, featuring a complete and unique set of easy to use, XML-based solutions accessible through a standard web browser.

For more information about LogiXML and the LGX suite of tools, please contact:

Marketing and Public Relations


401 330-0385

Share article on social media or email:

View article via:

Pdf Print

Contact Author

Arman Eshraghi