SQL Database Reporting
SQL Database Reporting Features:
- Support for all leading relational databases
- Database Connection Wizard
- Direct SQL SELECT statement entry
- Support for XML content in leading DBMSs
- Database Query Window
- Drag-and-drop database report design
- Mix SQL, XML, and/or XBRL data in a single design
- Generate XML Schema from database query
- Generate XML document from database query result
- Command line operation for batch reporting
Connecting to the Database
StyleVision makes it easy to generate dynamic database reports. With a few simple steps, you can access data in SQL databases and create visually compelling reports in HTML, PDF, RTF, and Word (Open XML), along with Authentic enterprise forms, all with a single StyleVision design.
Designing a database report begins with the easy-to-use StyleVision Database Connection Wizard, which helps you connect via ADO, ODBC, or JDBC. Once connected, the StyleVision presents you with a list of the available views, tables, and system tables, and the Preview Window lets you to see the data while you're selecting the tables and views to use in your database reporting design. In addition to connecting to relational data, you can access and work with XML data stored in database fields.
Supported SQL Databases
- Firebird 2.5
- IBM DB2 for iSeries® v6.1, 7.1
- IBM DB2® 8, 9.1, 9.5, 9.7, 10.1, 10.5
- Informix® 11.70
- Microsoft Access™ 2003, 2007, 2010, 2013
- Microsoft® Azure SQL
- Microsoft® SQL Server® 2005, 2008, 2012, 2014, 2016
- MySQL® 5, 5.1, 5.5, 5.6
- Oracle® 9i, 10g, 11g, 12c
- PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1, 9.4
- Progress OpenEdge 11.6
- SQLite 3.x
- Sybase® ASE 15
That's right: one version supports all major relational databases.
Visual Design for Database Reporting
After connecting, your selected database resources are available in the StyleVision Schema Tree entry helper. To create your design, simply drag and drop elements to the desired location on the design pane. StyleVision walks you through specify formatting and layout rules using context-sensitive right click menus and advanced entry helper windows.
Advanced database reporting features like grouping based on the XSLT 2.0 standard, inline Primary and Foreign key creation, and support for Database Views enable you to add complexity and dynamic functionality to your report designs.
StyleVision is the only tool of its kind that allows you to create database reports in HTML, PDF, Word, and RTF – simultaneously. At any time during the design process, you can view and save one or all of the output files and standards-conformant stylesheets that are autogenerated based on your graphical design.
The StyleVision report you design also generates an Authentic enterprise form, which allows business users to query and update database data using Altova’s XML and database content editor.
Database-driven Authentic forms can include navigational controls, making it easy for business users to interactively explore their data resources. Authentic empowers business users to report on as well as directly edit SQL database content.
Database Query Window
As you're designing a database report, it is useful to view the content of the database you're connected to. The StyleVision Database Query window provides an intelligent SQL editor with auto-completion. You can also let StyleVision autogenerate SQL statements by dragging database objects from the browser pane onto the SQL editor or selecting them using the right-click menu. Alternatively, you may import and edit existing SQL scripts.
Altova MissionKit provides a complete SQL database integration solution including design, editing, publishing, mapping, and more. Learn more on the Database Tools page.