BKeeney Software (Lenexa, KS) has released version 2.0 of its Xojo reporting tool, BKS Shorts, today. BKS Shorts is the premier reporting tool for Xojo desktop and web applications and comes with an integrated Designer and Viewer components to make it easy for Xojo developers to get advanced reporting in their desktop and web applications.
Within a few minutes Xojo developers can incorporate the Report Designer component in their desktop applications and create rich, dynamic reports. Grouping on a field is easy as well as creating complex queries to filter data. Its possible to ask for query parameters at runtime so end-users can filter data how they choose. Using XojoScript its easy to create incredibly complex reports that can vary text, visibility, and formatting at runtime based on field values.
The Report Viewer component is available for desktop and web applications. The viewer allows users to view their reports but also can ask them for parameters for the reports at runtime. For example it would be easy to allow users to specify their own date range for their reports. Reports in the viewer are searchable and with can be configured to allow for drill down reports.
Reports can be printed and are resolution independent. They can also be exported to PDF (requires MBS DynaPDF Starter Edition), HTML, and CSV.
Shorts supports SQLite, MySQL, Postgres, CubeSQL, MS SQL Server, Informix (requires the SQL plugin from MBS), and ODBC.
Version 2 Highlights
Added Report Header
Added Report Footer
Now allow database fields in Report and Page Headers and Footers
Rewritten SQL engine that makes reports with a lot of groups faster
Field aggregates (sum, min, max, average, count) are now handled by the report rather than queried.
Barcode Fields (requires BarcodeGeneratorMBS from Monkeybread Software)
Project comes with a converter for On-Target Reports
Numerous bug fixes and tweaks
The normal price for Shorts is $300 USD and you receive the package in 100% unencrypted source code. Existing users receive a 50% discount and if they’ve not already received an email should contact support.
Requirements: Shorts 2.0 requires Xojo 2016 R1 and better. Windows users should avoid using Xojo 2016 R4 as there is a bug in the Xojo printing framework. Shorts works on macOS, Windows desktop environments (Linux is untested and unsupported). Shorts report viewer does work in web applications running on macOS, Windows, and Linux. Because of XojoScript 64-bit applications are not supported yet (though XojoScript can be removed to make it so)
More information at the Shorts page at http://www.bkeeney.com/allproducts/bkeeney-shorts/