jDBexport 4.0.2

(0 رای)

Main features

• create data reports in various formats (xlsx, xls, ods, csv, html, pdf, json) from your databases
• individualise these reports with variable substition (such as userid or current date) or parameters entered by the user
• embed graphical charts (bar, pie, area, line, etc.) based on the requested data into your worksheets
• format these reports with colors, fonts, backgrounds (also alternating backgrounds), images, headers and footers, borders and more
• use a wide varity of conditions (including the result of SQL queries) for conditional formatting
• add additional cells with text, images or results from additional SQL queries
• define autofilter areas within your worksheets
• add any additional files (e.g. Excel Makros in an *.xlmx file) along with your workbook when compressing is activated
• deliver these reports regularly and fully automatically to your users, utilising our sophisticated scheduler
• define SQL based rules whether to run the scheduled task or not
• or let the users request these reports online or in the background or through the GoogleDocViewer
• or let the users preview these reports in a HTML preview within your website
• or prepare these reports (without showing them) for post processing with individual programs
• include virtually any accessible database - local or remote - into your reports (MySQL, MariaDB, MS-SQL, ORACLE, SQLite3, DB2, INGRES, SAP MaxDB, PostgreSQL, Firebird and others)
• check the validity of your SQL query with our on-the-fly (AJAX-driven) SQL syntax checker, while preparing the worksheet
• get inline help on creating your SQL queries, or reference the SQL manual that corresponds to your environment
• and many, many other features...
• jDBexport is translated in many languages (you can help us here...)
• jDBexport comes with a set of additional tools (frontend and backend module for easy access to your workbooks, datagrid and datafield plugin to embed worksheets or a single cell from a worksheet into any Joomla content, support for additional Truetype fonts in PDF creation)