Ariacom Business Reports is a database reporting and multi-dimensional analysis tool with dynamic SQL generation. Non-technical end-users can run and edit complex reports from any SQL relational database.

The product is able to meet a whole range of reporting requirements, from publishing a directory over the intranet to multi-dimensional analysis on a data-warehouse.

Ariacom Business Reports provides an integrated query engine, analysis tool, reporting and publishing function for all business enterprise data. It improves company productivity by providing the end user with powerful and flexible reporting, with limited IT involvement.

Ariacom Business Reports separates the business logic from the database structure, giving end users unprecedented control over their report content, presentation and business analysis.

The benefits of Ariacom Business Reports are:

Powerful Business Intelligence
Access of enterprise information allowing real time insight and decision making.
Multi layered security for business rules.
Business Analysis using drill through, ranking and cascade reports.
Report presentation with lists, cross tables and charts.

End User empowerment
Create, update and manage reports using well known business elements and logic.
Edit complex reports for business analysis.
Define report schedules with any available output device : printer, fax, mail, files, ftp…

Limited IT involvement
Separation of business logic from database structure is done once, together with business representative.
Training,maintenance and administration limited to absolute minimum.
Business logic and security stored in a unique repository.

Here are some key features of "Ariacom Business Reports":

· Dynamic and optimized SQL queries
· Generation of complex reports integrating pivot tables
· Native line, bar, point and pie charts
· Integrated security management limiting user access
· Fully multilingual design (currently in English, French, German, Spanish)
· Report results in various formats (html, csv, txt, xml with conversion to pdf)
· Output to various devices (file, printer, fax, email, ftp)
· Cascade reports allowing multi-dimensional navigation
· Publication and sharing of reports and results
· Simple to install and configure
· ActiveX to be integrated into any Win32 applications Functions limited in the free version: Report Scheduler, Web Report Server, Drill navigation, Running totals, Ranking, Formulas.


Limitations:

· Free for personal use only.


What's New in This Release:

New features:
· Report templates and Visual Basic Script are available to generate report results in a native Microsoft Word document format.
· Report Manager: For report templates having the template tag "OpenUsingRegisteredEditor", the report generated can be viewed and edited with the current application installed on the machine (for example Microsoft Word for .DOC files, Microsoft Excel for .CSV files).
· Report Manager, Output and schedule: Custom restriction values can be defined for a given report output.
· Report Manager, Charts: In chart Options, the minimum and maximum axis values can be specified in a Date format.
· The new template tag "SqlSelect" enables to insert the result of a parametrized SQL statement directly in a report result.
· A report description and comment can be edited directly in the report (with related template tags ReportDescription and ReportComment).
· Report Manager ActiveX: Restrictions of a report can be prompted by using the new PromptRestrictions() method.
· The use of the repository explorer is not limited anymore in the free version.

Issues addressed:
· [Web Report Server] The Drill navigation does not work if the report has restrictions to be prompted and if the user does not enter any restrictions.
· [All components] The %USER% keyword in pre-SQL statement for database returns the database user name instead of the business domain user name.
· [All components] For report having csv template, NULL values are displayed with "<%ARIACOM%NULL%VALUE%>".
· [All components] Left and right axis of charts are used if the measure is a count of an element of type DateTime and if a dimension is a chart splitter.
· [Report Manager] When many restrictions are prompted at run-time, the window may be to large for the screen, hiding the OK and Cancel buttons.
· [Report Manager] Using [Save Report Result…] may generate incorrect data tables if the rows and columns are sorted and if the report contains drilled or cascaded elements.
· [Business Domain Manager] The Business Domain Manager application may not respond anymore when adding a new report element having the same name as an existing element.
· [Business Domain Manager] The Business Domain Manager application may raise an unexpected exception when deleting a report element.
· The business domain is then corrupted (deleted elements can be added to report types).
· [Business Domain Manager] The Report Execution URL Wizard raises an Access Violation
· Exception after the choice of a report path.
· [All components] The execution of a report output on a folder causes a memory leak.
· [All components] The HTML attributes of the main chart may be corrupted ( tag) when using HTML custom report templates.
· [All components] The Print in landscape option is not supported for report printed with XML PDF templates.