LibraryDeveloper PortalDatabase Reporting

To help you present database data in multiple formats quickly and easily, Altova tools provide rich support for creating database reports in today’s most popular document formats: HTML, RTF (Rich Text Format), Adobe® PDF (Portable Data Format), and Microsoft® Word 2007 (OOXML). Learn about database reporting and relevant support in Altova software below.

Relational databases are the dominant data storage mechanism in businesses and organizations today. Intended primarily as a tool for storing, searching for, and retrieving information from massive collections of data, the relational database usually does not provide features for presenting the data stored therein in a meaningful, eye-catching manner. Database reporting applications have been developed to meet this need, but they are often expensive and optimized solely for one type of database or one output format such as HTML. To meet the communication requirements of various departments, partners, and customers, however, users are often required to present database reports in multiple formats, and converting reports to other formats can be costly and time consuming. Follow the links below to learn more about how Altova tools address these challenges.

Altova StyleVision® 2008 is a powerful database reporting tool that allows you to design stylesheets based on a database (or an XML Schema) to generate report output to HTML, RTF, PDF, and Word 2007 (OOXML) – all from a single design. StyleVision supports all the most popular relational databases, including:

• IBM DB2
• Oracle
• Microsoft SQL Server
• Microsoft Access
• MySQL
• Any other database via ADO connectivity

To design a database report in StyleVision, you simply connect to the required tables in your database and design your database report using drag-and-drop functionality and rich formatting options. Based on your design, StyleVision automatically creates stylesheets to output your report in HTML, RTF, PDF, and Word 2007 – you get four eye-catching reports from one easy-to-create design!

A fifth output format, the Authentic electronic form is also automatically generated. The Authentic e-Form provides a word processor-style interface for non-technical users to edit databases using Authentic, which is available free of charge on the Altova corporate Web site.

Database Reporting for Single Source Publishing

XML separates content from presentation, providing a framework for implementing single source publishing. However, XML alone does not address all the challenges associated with single source publishing, nor does it provide a de facto solution for managing the huge amounts of data stored in relational databases. Altova StyleVision closes this gap to enable true single source publishing by allowing you to create one design to output data stored in databases and XML in multiple formats.

Read the single source publishing whitepaper (PDF 838 KB) to learn more about the benefits of single source publishing. You’ll also learn how StyleVision removes the obstacles that often stand in the way of successful single source publishing implementations.

Download a free trial of StyleVision® 2008 today to see how you can create eye-catching HTML, RTF, PDF, and Word 2007 (OOXML) database reports – and a whole lot more – in an intuitive, visual manner.

In addition, extensive support for working with databases alongside XML is provided in the Altova® MissionKit™ 2008. Get up to 8 software tools for the price of 2 with the Altova® MissionKit™ 2008! The MissionKit bundles Altova's intelligent application development and data management tools to meet the needs of software architects and XML developers. Learn more about database support and download a free trial.