Shorts Version 2.0.4

  1. 4 months ago

    Bob K

    Apr 28 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 http://www.bkeeney.com/allproducts/bkeeney-shorts/

  2. Bob K

    May 1 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

    May 2 Pre-Release Testers, Xojo Pro airport lounge

    @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

    May 2 Pre-Release Testers, Xojo Pro Kansas City
    Edited 4 months ago by Bob K

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

    Fixes:

    • 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. 3 months ago

    Bob K

    May 18 Pre-Release Testers, Xojo Pro Kansas City
    Edited 3 months ago by Bob K

    Version 2.0.2 Released today.

    New:
    * Added an EMail PDF example.

    Changes:

    • 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.

    Fixes:

    • 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:
    New:

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

    Changes:

    • 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

    Fixes:

    • 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. 5 weeks ago

    Bob K

    Jul 19 Pre-Release Testers, Xojo Pro Kansas City

    BKS Shorts version 2.0.4 was released today.

    Release Notes:

    New:

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

    Changes:

    • 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)

    Fixes:

    • 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. Deleted 5 weeks ago by scott b

or Sign Up to reply!