Shorts version 2.0
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. It’s possible to ask for query parameters at runtime so end-users can filter data how they choose. Using XojoScript it’s 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, simply said, 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.
Shorts supports SQLite, MySQL, Postgres, CubeSQL, MS SQL Server, Informix (requires the SQL plugin from MBS), and ODBC.
New in version 2:
• 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
ALL SALES ARE FINAL
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 (though XojoScript can be removed to make it so)