#RevCon13 – The BRW and the Data Connectors


Revelation Software 2013 Conference LogoWith the first of the O4W training sessions behind us, it is time to choose between two new breakout sessions.  During this session Mike Ruane will go up against Bob Carten in a clash of the titans.

Banded Report Writer – Practical Examples, Tips and Tricks
Bob Carten (Revelation)
I have done a fair amount of work with the Banded Report Writer (BRW) during my Archery Club Manager development project and I have come to like the tool very much.  Whilst it can be a little frustrating at times and you have to understand the way that it has been designed and works, the tool is very powerful and you can create some really very nice formatted reports with graphics, exploding reports, etc.

The OpenInsight BRW therefore delivers the benefit of a robust reporting tool but at the cost of a steep learning curve.  During his presentation, Bob will step through creating some commonly used report formats and discuss some of the techniques and approaches for getting exactly what you want from the BRW.

Bob will create reports which demonstrate such commonly used features such as calculations, sub reports and graphs. The talk is aimed at people who have looked at the BRW and are interested in using it for more than simple tabular reports. Bob will also show how to launch the reports from OpenInsight.

Using OpenInsight with Non-OI Data sources
Mike Ruane (Revelation)
Given the power of OpenInsight’s desktop and web interface design tools and its programming tools, we are often asked whether OpenInsight can be used as a front end to other database technologies such as SQL and many of the other MultiValue databases.  Whilst OpenInsight applications are usually made to work the OpenInsight’s own Linear Hash data source, they work as well with other databases, such as SQL, QM, D3, and other MultiValue databases.

In this session, Mike will show the tools used to connect to these third party databases, show OpenInsight’s tools working with these databases, and talk about specific issues that an OpenInsight developer might come across whilst working with each of these data sources.

If you have the need to have your application, whether desktop based, or browser-based, work with other data sources like SQL or Access, you should attend this session.

OpenInsight 9.3.1 Now Available!


Overnight the OpenInsight 9.3.1 upgrade was posted to the WORKS area for all WORKS members to download.  Please contact me if you are not a WORKS member and wish to find out more about this great release.

This latest version includes O4W Mobile Extensions and a brand new data connector for Ladybridge’s OpenQM Multivalue database.

  • OpenInsight for Web (O4W v1.3) – This latest version of O4W includes additional integration with the new Banded Report Writer, new support routines for RSS feeds and a brand new ‘ad hoc’ report builder.  In addition, the release includes a number of additional mobile enhancements such as a mobile specific menu and report output.  Through O4W’s integration with jQuery Mobile (the companion library to O4W’s jQuery), web pages can be created using “finger friendly” user interface elements and design.
  • OpenInsight for QM Data Connector (OI4QM) – The OI4QM data connector enables MultiValue application developers to fully utilise the QM database from Ladybridge Systems Limited.  Using this dedicated data connector, Windows GUI and Web 2.0 interfaces can be quickly created without any change being required to an existing QM database.

“With this latest release, we’re proving our commitment to our Revelation and MultiValue community”, said Mike Ruane, President/CEO Revelation Software, “They asked us for a connection to QM from Ladybridge, and we listened. Our users also gave us a list of enhancements and suggestions for the Banded Report Writer, and we’ve taken care of them as well.”

Also included in the OI 9.3.1 are a number of patches and enhancements for the Banded Report Writer, Table Builder, and Database manager.

“Mobile computing is an essential requirement for any application development”, said Robert Catalano, Director of Sales, Revelation Software. “We are empowering the MultiValue community with one of the best mobile computing toolkits on the market that is affordable, familiar to MV developers, and connects to their existing database with no change.”

I would like to thank all of the developers involved in this release and also to our army of beta testers who provide their time and invaluable feedback.