Shorts Version 2.0.5

  1. 7 months ago

    Bob K

    28 Apr 2017 Pre-Release Testers, Xojo Pro Kansas City

    BKeeney Software (Lenexa, KS) has released version 2.0 of it’s 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. 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 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

  2. Bob K

    1 May 2017 Pre-Release Testers, Xojo Pro Kansas City

    Can't believe I forgot to mention this. Shorts no long requires a database connection!

    You can supply your own data and pass it into to the report. What you can't do is supply your own data and have Shorts do a runtime query on it. So your data has to come in pre-filtered.

  3. scott b

    2 May 2017 Pre-Release Testers, Xojo Pro local coffee shop

    @Bob K You can supply your own data and pass it into to the report.

    This is a major enhancement of Shorts. @Bob K and team has done a wonderful job at making Shorts better.

  4. Bob K

    2 May 2017 Pre-Release Testers, Xojo Pro Kansas City
    Edited 7 months ago

    The first update to Shorts 2.0 is out. Version 2.0.1 is a bug fixes only release.


    • CSVRenderer now part of the project again
    • "Create Multiple Fields on Right" works again
    • Text items (and fields) now draw in the designer if there is no Data (they will use their UID instead)
    • Text items that are supposed to be invisible are now invisible on alternating backgrounds
    • Fixed rare issue with multiple selected items and the property list saying "No Selection"
    • Fixed issue with multiple-level deep break bands starting over prematurely
    • Fixed issue with SC_GetCount XojoScript function
  5. 6 months ago

    Bob K

    18 May 2017 Pre-Release Testers, Xojo Pro Kansas City
    Edited 6 months ago

    Version 2.0.2 Released today.

    * Added an EMail PDF example.


    • Duplicate suppressing is now handled through BKS_Shorts.TextItem.FieldName instead of the Tag
    • Changes made to DynaPDF renderer to allow it to email a PDF.


    • Band scripts work again
    • PostgreSQL databases work again
  6. Bob K

    Jun 8 Pre-Release Testers, Xojo Pro Kansas City

    BKS Shorts version 2.0.3 was released today.

    Release Notes:

    • Designer: Wrap lines without allowing the item to grow (#3419)
    • Designer: Text fields can now have borders (#3486 #3437)


    • Database Type detection moved in to SQLGeneratorBKS.Generator
    • Removed global PAF_DatabaseKit.bIsPostgres
    • GroupItemPF.HasItems no longer counts empty text items
    • Report template now only stores the database fields used (#3281)
    • Designer is no longer tied to App object with constants and methods (#3487)
    • Designer can now discern the app name by itself
    • Designer propery list now scrolls when it's too long


    • Body Band Limit works (#3505)
    • Line wrap drawing code in the designer now wraps properly
    • SQL Generator no longer chokes on more than 2 data filters (#3501)
    • Suppress duplicates no longer suppressing fields it shouldn't
    • Previewing a report in the Designer no longer briefly shows the last report run
    • Connection window no longer shows the same error message twice when SQLite fails to connect

    Existing Users Should Note:
    The App.AppDataDirectory, App.AppIcon, and App.AppImageDirectory methods have been moved to PreferencesModule to make Shorts easier to install. Please be aware that you may need to update the PreferencesModule.AppIcon method with your existing App.AppIcon code.

    The App.kAppName constant has also been moved into the PreferencesModule. The value now comes from the PreferencesModule.AppName method, which can automatically discern the app name, or you can have it return a string of your choosing. The later approach may be more desirable if you used a value in the kAppName constant that was not the actual value of your app's file name when built.

    For best results when updating, delete the three methods and constant from the App object. This will highlight any spots you may have referenced these methods (and will need to update them)

  7. 4 months ago

    Bob K

    Jul 19 Pre-Release Testers, Xojo Pro Kansas City

    BKS Shorts version 2.0.4 was released today.

    Release Notes:


    • Super Simple Example project demonstrates the basics of using the core classes
    • Checkbox field type for boolean data


    • Various improvements to the Property List for ease of use
    • Updated PrintField SerializeJSON to use UInteger in preparation for 64bit
    • BKS_Shorts.Settings.kUseBarcodePlugin now defaults as False
    • OrderBy is now a menu to prevent malformed data (#3519)


    • Checkboxes in the property list are now much easier to click on Windows (#3535)
    • Property list text fields no longer float when the property list scrolls
    • AlternatingList now draws properly on Linux, and code was simplified
    • Removed Special/Any filter on select file dialogs, this fixes selection on Linux
    • Removed AutoAlias from AddField method, this was creating invalid Aliases as we changed the way we use Alias in Shorts 2.0
    • Multiple fields in ORDER BY handled properly in the schema identification process (#3537)
    • Report Header with PageBreak no longer adds extra headers on the second page (#3538)
  8. Rich H

    Jul 21 Pre-Release Testers, Xojo Pro

    Hey Bob,

    Is it still possible to create Shorts reports from a console applications? I am using one of the first or second release of shorts and currently considering upgrading to the latest.

    thanks again.

  9. Bob K

    Jul 21 Pre-Release Testers, Xojo Pro Kansas City

    @Rich H Hey Bob,

    Is it still possible to create Shorts reports from a console applications? I am using one of the first or second release of shorts and currently considering upgrading to the latest.

    thanks again.

    Yup. The underlying reporting engine hasn't changed much. 2.0 is mostly enhancements to the Report Designer. Contact me at support for an upgrade coupon.

  10. 8 weeks ago

    Bob K

    Oct 2 Pre-Release Testers, Xojo Pro Kansas City
    Edited 8 weeks ago

    BKeeney Software has released Shorts 2.0.5 today. This maintenance release is recommended for all users and is a free update to those that have purchased a license for version 2.


    • PreviewCC now has a ReportFinished event
    • Report Designer Help menu item that goes to the documentation
    • BandType constants in PAF_PrintBand
    • Datestamps in the header and footer can now be formatted individually (#3572)


    • Ease of installation improvements
    • Code demo window order of operations, design, and reports improved
    • BKS_Shorts.ImageItem constructor copies over aspect ratio boolean
    • Moved the PAF_PrintKit.StylesLoad call from App.Open event to winReportDesigner.Open event
    • Moved Designer Constant "Page Placeholders" (Timestamp, PageNumber, PageCount) into constants of ReportBKS
    • Property list uses shared disclosure triangle drawing method now
    • Property list draws backgrounds for disclosure triangle and ellipsis to fix overlap issues
    • Removed workaround for 64 bit text splitting as the issue has been marked as fixed in 2017r2 (#3567)
    • Removed "ReportRun" notification sent through pfDispatcher, replaced with ReportFinished event on the ContainerControl
    • Removed global setting for date formatting for header and footer, fields can now be individually formatted
    • winReportDesigner.HandlePrint will now properly show the printer dialog for each print, as a user expects.
    • winDBConnection Password no longer a required field to attempt a connection
    • Added constant to recognize, or ignore, MS SQL Server (for future release).


    • DynaPDF Renderer now draws images properly in high resolution
    • Enum properties in the property list no longer have empty first value (causing KeyNotFoundException when selected)
    • Report Designer no longer leaves on an extra "g" when finding the app name automatically (only affects Debug environments)
    • Email PDF example protected against bad SSL settings
    • Constants no longer get drawn several times in the designer (#3578)
    • Error properly reported if no rows are returned from a SQL error
    • winDBConnection will no longer show an empty MsgBox when connecting to some database types
    • Image scaling no longer refuses to scale up, this improves how low resolution images are handled
    • SC_GetCount works again
    • Aggregates with body rows of repeating data (i.e. 2nd row data the same as the first and so on) works properly now

or Sign Up to reply!