Stonefield Query for Sage BusinessVision Version 4.1 New Release

Lots of new and improved features in version 4.1. including the new Dashboard Wizard.

Orlando, FL, March 08, 2012 --( Stonefield is pleased to announce the immediate release of Stonefield Query for Sage BusinessVision version 4.1. There are lots of new and improved features in version 4.1.

Download a free demo here:

New Features

- You can now define dashboards using the new Dashboard Wizard. A dashboard is a set of chart reports that displays on your desktop in its own window. These charts automatically refresh at an interval you specify so you can always see the most current data.

- Stonefield Query now supports Windows 7: When you run a report, the taskbar button shows a moving green bar indicating something is happening.

- You can now right-click a report and choose Pin to Taskbar to pin it to the taskbar; choosing that item in the taskbar launches Stonefield Query and previews that report (this obviously works best when Stonefield Query itself is pinned to the taskbar).

- Stonefield Query report files, which have an SFX extension, now display a nice report icon in Windows Explorer. Double-clicking an SFX file launches Stonefield Query and previews that report.

- You can now create a desktop shortcut for a report. Right-click any report in the Reports Explorer and choose Create Desktop Shortcut. This will create a shortcut on your desktop with the same name as the report. Double-clicking this shortcut previews the report without opening Stonefield Query, which is handy if you just want to run one report without having to find it in the Reports Explorer.

- Usage statistics are now maintained for reports, and the new Usage Reporting function in the Tools menu allows you to report on these statistics. This allows you to determine which reports are actually being used, how often, and by whom.

- A new type of display for date fields is now available in the Field Properties dialog: "Month/Year". This displays the month and year part of the date, which the "Month" option formerly did. "Month" now outputs only the month part of the date, which is handy, for example, in cross-tab reports where you want to show the date in the rows and the year in the columns to compare sales by month and year. Reports you created prior to version 4.1 using "Month" are automatically changed to use "Month/Year" so they work as they did before.

- You can now configure how much memory Stonefield Query reserves for itself at startup. This is especially useful in Windows Terminal Server environments where multiple users run Stonefield Query on the same server at the same time.

- The new built-in GoMonthDay function makes calculating dynamic dates, such as the first day of the previous month, much easier.


- Multi-page charts are now supported. In the new Size/Paging page of the Chart Wizard, turn on Paging and set the number of points you want on each page.

- Linking, such as drilldowns, from charts is now supported. The Properties dialog for the Category (X-axis) field has a Link page that works the same as other report types. This allows you, for example, to display a chart showing sales by salesperson and click a certain salesperson to drill down to a report showing individual sales for that salesperson. Linking even works in charts displayed in a dashboard. To support this feature, a different preview window is used for charts. It has the same features as the preview window used for other report types but cannot used tabbed pages showing other report types, only other charts.

- Charts now use the Segoe UI font for text in Windows Vista or later because it looks better, especially when rotated.

Cross-Tab Reports

- Cross-tab reports now support displaying the amount and/or percentage change between columns. The Display page of the Properties dialog for a data field has new "Show difference from previous column" and "Show percentage change" options. You can turn on one or both of these.

- You can now specify whether cross-tab reports include row and column totals using new options in Step 5.

- The Select only top option in a cross-tab report now applies to the totals for the first row field rather than the row field itself. For example, setting "Select only top" to 10 now displays the top 10 values rather than the top 10 alphabetically.

For a full list of all the features please visit the Stonefield Query website.

Stonefield Software Inc.
Ken Kupchyk