Altova StyleVision is a powerful tool for creating database reports with a high degree of customization. It allows users to design visually compelling reports by connecting directly to various databases, such as SQL Server, Oracle, MySQL, PostgreSQL, and others, without needing to code complex SQL queries manually.
With StyleVision, you can define report layouts, formats, and even incorporate images and charts to produce dynamic, data-driven reports, all via an easy-to-use, drag-and-drop design interface.
Every report you design in StyleVision is simultaneously available in HTML, Word, PDF, and text formats.
StyleVision enables direct connections to all popular SQL databases, allowing you to fetch data and use it in your reports. The Database Connection Wizard makes it easy to connect to backend data and includes ADO, ODBC, or JDBC options. This feature simplifies report generation for users by eliminating the need for data exports or external integrations.
StyleVision supports:
- Firebird 2.5, 3, 4
- IBM DB2 for iSeries® v6.1, 7.1, 7.2, 7.3, 7.4
- IBM DB2® 8, 9.1, 9.5, 9.7, 10.1, 10.5, 11.5, 11.5.7
- Informix® 11.70, 12.10, 14.10
- MariaDB 10, 10.3, 10.4, 10.5, 10.6.5, 10.9.2, 10.11, 11.2, 11.4
- Microsoft Access™ 2003, 2007, 2010, 2013, 2019
- Microsoft® Azure SQL
- Microsoft® SQL Server® 2005-2022
- MySQL® 5, 5.1, 5.5, 5.6, 5.7, 8, 8.0.25, 8.0.28, 8.2, 8.3, 8.4
- Oracle® 9i, 10g, 11g, 12c, 18, 19
- PostgreSQL 8, 9, 10, 11, 12, 13, 14, 15, 16
- Progress OpenEdge 11.6
- SQLite 3.x
- Sybase® ASE 15, 16
- Teradata 16
Once connected, the connection wizard lists the 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.
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.
To create your design, simply drag and drop elements to the desired location on the design pane. 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 multi-channel reports.
StyleVision supports dynamic reporting, letting you create layout templates for consistent formatting while allowing actual report content to be determined at run-time based on your source data. This lets you retain your intricate report designs from one project to the next.
