Stonefield Query - Business Intelligence & Database Reporting Software

Stonefield Query for Sage Pro ERP version 4.1.4246

2011-08-18T16:10:00.001-06:00

We have released version 4.1.4246 of Stonefield Query for Sage Pro ERP. This is mostly a maintenance release but does have one new feature: The new Value on Hand field in the Inventory Master File (ICITEM) displays the total on hand value for the inventory item.

Stonefield Query for Sage Accpac ERP version 4.1.4246

2011-08-18T12:39:00.001-06:00

We have released version 4.1.4246 of Stonefield Query for Sage Accpac ERP. This release has several new features:

You can now report on Orion Point of Sale (POS) data (http://www.odiglobal.com).
You can now define security for individual databases in the Maintain Users and Groups dialog so only certain users can access certain databases.
A new AR Combined Documents & Adjustments table combines records from AR Documents (AROBL) and Receipts and Adjustments (ARTCR), making it easy to create a listing of all AR transactions for a customer.
A new Earning/Deduction YTD Amount field is now available in the Canadian Payroll Cheque Details (CPCHKD.YTDAMT) table. New YTD Earnings, YTD Net Pay, Current Earnings, Current Deductions, Current Taxes, and Spelled Out Amount fields are now available in the Cheque Header table. These fields were also added to the U.S. Payroll Check Details and Check Header tables. These fields make it easy to create a payroll advise report (see the next point).
New Cheque Advice (Canadian Payroll) and Check Advice (U.S. Payroll) sample reports make it easy to email payroll advices for a specific pay period to employees. These reports require Sage Accpac ERP version 5.5 or later.
New Total for Year calculated fields, such as Total Quantity for Year and Total Cost for Year, were added to the Project Costing Budget Detail (PMBUDD) table because the existing Accpac totals fields are always zero.
New Unisales Combined Invoices & Credit/Debit Notes (UXINVHCRDH) and Combined Invoice & Credit/Debit Note Details (UXINVDCRDD) tables are available, making it easier to show invoices, credit notes, and debit notes from Unisales on one report.
Lot tracking tables are no longer available if you're using Accpac 5.6 or later since Sage removed those tables. Unfortunately, that means that reports using those tables have to be recreated from new lot tracking tables in Inventory Control.
A new Certified Payroll Report Jobs (UPCPRJ) table is now available in U.S. Payroll.
Performance was improved for some types of calculated fields.
You can now turn on the "Suppress repeating values" setting for the last row field in a cross-tab report if desired.
You can now specify CC and BCC email addresses when emailing different pages in a report to separate addresses (which you do by turning on "Output each group as a separate file" and setting "Get email address from" to a field).
Date/time fields with the "Display date only" setting turned off can now be used in the row of cross-tab reports.

If you are using an earlier version 4.1 build, you can install the update using the Check for Updates function in the Tools menu of the Report Designer.

Stonefield Query SDK version 4.1.4246

2011-08-18T12:33:00.001-06:00

We have released version 4.1.4246 of the Stonefield Query SDK. This is a maintenance release fixing minor or obscure bugs. If you are using an earlier version 4.1 build, you can install the update using the Check for Updates function in the Tools menu of the Report Designer.

Stonefield Query SDK Version 4.1.4171

2011-06-10T10:46:00.001-06:00

Version 4.1.4171 is mostly a maintenance release but there are some new features.

Report Designer

You can now turn on the "Suppress repeating values" setting for the last row field in a cross-tab report if desired.
You can now define security for individual databases in the Maintain Users and Groups dialog so only certain users can access certain databases.
You can now specify CC and BCC email addresses when emailing different pages in a report to separate addresses (which you do by turning on "Output each group as a separate file" and setting "Get email address from" to a field).
Date/time fields with the "Display date only" setting turned off can now be used in the row of cross-tab reports.
You can now pass default values to the GetValueForParameter and GetValueForField functions.

SDK

A sample ASP.Net web application is now available.
You can now check for updates in Stonefield Query Studio using the Check for Updates function in the Help Menu.
Stonefield Query Studio's title bar now shows the version number.
An option defined in an Options.Settings script can now have the "restart" attribute even if no "key" attribute is provided.
The new Application.SetupMenu script allows you to customize the Stonefield Query menus.
The new OutputOptions.Settings script allows you to define custom file output types.
The Table and Field drop-down lists for Display Field from Related Table now display table and field captions.
If you have certain tables you want ignored when you refresh a database, add a [NoRefresh] section to SFQuery.INI.
Stonefield Query Studio now automatically delimits table and field names that have mixed case in Firebird databases because Firebird requires it.
You can now specify that Stonefield Query uses case-insensitive joins when it performs joins by adding CaseInsensitiveJoins=Y to an [Options] section in SFQuery.INI.

Stonefield Query for Sage BusinessVision Version 4.1

2011-06-09T10:23:00.005-06:00

We are 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.

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.

Charts

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.

Other Features

Emailing now supports SSL/TSL for SMTP, which means you can now email using Gmail or Hotmail accounts or other SMTP servers that require SSL/TSL. Also, emailing using MAPI with Microsoft Outlook as your email program no longer displays the dreaded Outlook security dialog.
Certain characters that weren't allowed in the name of a report, such as a period, comma, question mark, slash, and so on, are now allowed. The only character you can't use is a backslash ("\").
Certain characters that weren't supported in the body or subject of an email, such as "&" or ">", are now allowed.
You no longer have to contact us if you have to activate the program on a different computer than it was originally activated on. Online activation will automatically activate this computer and deactivate the license on the other one.
Output to text, comma-separated (CSV), table, and XML files is now faster.
Exclusion conditions now work faster than before.
The Preview window now remembers the setting of the zoom option. If you run a report and change the zoom to 200%, the next time you preview a report, it'll be at 200%.
The Ask At Runtime filter and report progress dialogs now always appear on top of any other windows so they can't get lost behind something else if you click on a different window.
The Setup dialog has a new page (page 2) for contact information.
The activation process is now simpler. Clicking the Click here to activate the program now link in the Welcome dialog (displayed when you're running an unactivated version) now displays the License Manager dialog where you can add as many licenses as you need rather than bringing up a Registration dialog that only allows one license to be activated.
New templates are automatically imported when you run Stonefield Query.
The OnSelect script for a report can now access the report using the Report object. This is useful if, for example, you want to change the default filter for a report when it's selected.
You can now use the built-in RunSQL function in formulas.
It's easier to work with the Dynamics tab in the properties dialog for Pictures and Rectangles in the Advanced Report Designer. You no longer have to enter values in 960th's of a inch; instead, you can enter value in inches or centimeters, depending on how your system is configured.
File dialogs, such as those displayed when you output to file or export a report, now support Windows Vista and later features, such as search and recent places.
The ask-at-runtime filter dialog now appears on top of the report progress window so it doesn't get hidden behind other windows.
The new GetValueForParameter function is like the existing GetValueForField but allows you to specify the caption, data type, and size of the parameter being requested from the user.
You can now filter on the Source Database field. This allows a report to drill down based on a data source. For example, suppose you have a cross-tab report that retrieves data from multiple data sources and it has Source Database as the column field. Clicking a specific data source should drilldown and run a detail report for that data source only, so the linked report has a filter on Source Database.
The progress dialog that appears when running a report that retrieves data from multiple databases now shows the name of the database the data is currently being retrieved from and the number of records retrieved.

Lost in Translation

2011-04-15T10:51:00.001-06:00

Here is a recent press release we sent out about the latest version of Stonefield Query.This one is the same press release that was obviously translated to another language and then back to English, I suspect by an automated rather than human translator. The translated version is hilarious. Here are some of my favorite quotes:

“Stonefield Software today declared the stylish promulgation of its database news code tool, Stonefield Query 4.1”

“The newborn edition includes over 30 newborn enhancements – the most momentous existence the Dashboard Wizard”

“As a result, they never intend the flooded benefits of what Goldmine CRM crapper do for them and their business.” (Um, we didn’t really call GoldMine “crapper”. It looks like “can” became “crapper” in the re-translation.)

“They woman opportunities and that effectuation forfeited sales.” (“Miss” became “woman”.)

“The stylish edition provides an ad hoc news resolution that crapper be utilised direct by modify users as substantially as IT staff.” There’s that word “crapper” again.

Stonefield Query for Sage Pro ERP Version 4.1 Released

2011-03-30T15:03:00.000-06:00

We are pleased to announce the immediate release of the Stonefield Query for Sage Pro ERP version 4.1. There are lots of new and improved features in version 4.1.

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.
When you install a new version of Stonefield Query over an existing one, if there are any new or modified sample reports, a dialog appears telling you that and allowing you to select which of those to import. You can also choose the Check New or Updated Sample Reports function in the Tools menu.
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.

Charts

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.

Other Features

Stonefield Query now works with Sage Pro 2011.
The new Sales Order Commission Header Current + History table combines current and history sales order commission records.
Many date fields are now available as "YM" (year and month) versions. For example, the Check Date YM field in the Accounts Payable Master File displays the year and month of the check date. In addition, numerous other calculated fields and more relationships between tables were generously provided by Philip Borkholder of Automation Plus Inc.
The new Always Union Current and History Tables Before Join option in the Options dialog allows you to decide when multiple "current + history" tables are used in a report whether it should do individual queries on the separate tables (which is slower) or queries with set of current tables and the set of history tables (which is faster but may not have matches).
The IC Items and Item at Location tables now also appear in the Order Entry module.
Emailing now supports SSL/TSL for SMTP, which means you can now email using Gmail or Hotmail accounts or other SMTP servers that require SSL/TSL. Also, emailing using MAPI with Microsoft Outlook as your email program no longer displays the dreaded Outlook security dialog.
Certain characters that weren't allowed in the name of a report, such as a period, comma, question mark, slash, and so on, are now allowed. The only character you can't use is a backslash ("\").
Certain characters that weren't supported in the body or subject of an email, such as "&" or ">", are now allowed.
You no longer have to contact us if you have to activate the program on a different computer than it was originally activated on. Online activation will automatically activate this computer and deactivate the license on the other one.
There's better support for adding images stored in your database to reports.
Output to text, comma-separated (CSV), table, and XML files is now faster.
Exclusion conditions now work faster than before.
The Preview window now remembers the setting of the zoom option. If you run a report and change the zoom to 200%, the next time you preview a report, it'll be at 200%.
The Ask At Runtime filter and report progress dialogs now always appear on top of any other windows so they can't get lost behind something else if you click on a different window.
The Setup dialog has a new page (page 2) for contact information.
The activation process is now simpler. Clicking the Click here to activate the program now link in the Welcome dialog (displayed when you're running an unactivated version) now displays the License Manager dialog where you can add as many licenses as you need rather than bringing up a Registration dialog that only allows one license to be activated.
New templates are automatically imported when you run Stonefield Query.
The OnSelect script for a report can now access the report using the Report object. This is useful if, for example, you want to change the default filter for a report when it's selected.
You can now use the built-in RunSQL function in formulas.
It's easier to work with the Dynamics tab in the properties dialog for Pictures and Rectangles in the Advanced Report Designer. You no longer have to enter values in 960th's of a inch; instead, you can enter value in inches or centimeters, depending on how your system is configured.
File dialogs, such as those displayed when you output to file or export a report, now support Windows Vista and later features, such as search and recent places.
The ask-at-runtime filter dialog now appears on top of the report progress window so it doesn't get hidden behind other windows.
The new GetValueForParameter function is like the existing GetValueForField but allows you to specify the caption, data type, and size of the parameter being requested from the user.
You can now filter on the Source Database field. This allows a report to drill down based on a data source. For example, suppose you have a cross-tab report that retrieves data from multiple data sources and it has Source Database as the column field. Clicking a specific data source should drilldown and run a detail report for that data source only, so the linked report has a filter on Source Database.
The progress dialog that appears when running a report that retrieves data from multiple databases now shows the name of the database the data is currently being retrieved from and the number of records retrieved.

Stonefield Query for GoldMine 4.1

2011-03-16T08:59:00.005-06:00

We are pleased to announce the immediate release of Stonefield Query for GoldMine version 4.1. There are lots of new and improved features in version 4.1.

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.

Charts

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.

Other Features

Emailing now supports SSL/TSL for SMTP, which means you can now email using Gmail or Hotmail accounts or other SMTP servers that require SSL/TSL. Also, emailing using MAPI with Microsoft Outlook as your email program no longer displays the dreaded Outlook security dialog.
Certain characters that weren't allowed in the name of a report, such as a period, comma, question mark, slash, and so on, are now allowed. The only character you can't use is a backslash ("\").
Certain characters that weren't supported in the body or subject of an email, such as "&" or ">", are now allowed.
You no longer have to contact us if you have to activate the program on a different computer than it was originally activated on. Online activation will automatically activate this computer and deactivate the license on the other one.
Output to text, comma-separated (CSV), table, and XML files is now faster.
Exclusion conditions now work faster than before.
The Preview window now remembers the setting of the zoom option. If you run a report and change the zoom to 200%, the next time you preview a report, it'll be at 200%.
The Ask At Runtime filter and report progress dialogs now always appear on top of any other windows so they can't get lost behind something else if you click on a different window.
The Setup dialog has a new page (page 2) for contact information.
The activation process is now simpler. Clicking the Click here to activate the program now link in the Welcome dialog (displayed when you're running an unactivated version) now displays the License Manager dialog where you can add as many licenses as you need rather than bringing up a Registration dialog that only allows one license to be activated.
New templates are automatically imported when you run Stonefield Query.
The OnSelect script for a report can now access the report using the Report object. This is useful if, for example, you want to change the default filter for a report when it's selected.
You can now use the built-in RunSQL function in formulas.
It's easier to work with the Dynamics tab in the properties dialog for Pictures and Rectangles in the Advanced Report Designer. You no longer have to enter values in 960th's of a inch; instead, you can enter value in inches or centimeters, depending on how your system is configured.
File dialogs, such as those displayed when you output to file or export a report, now support Windows Vista and later features, such as search and recent places.
The ask-at-runtime filter dialog now appears on top of the report progress window so it doesn't get hidden behind other windows.
The new GetValueForParameter function is like the existing GetValueForField but allows you to specify the caption, data type, and size of the parameter being requested from the user.
You can now filter on the Source Database field. This allows a report to drill down based on a data source. For example, suppose you have a cross-tab report that retrieves data from multiple data sources and it has Source Database as the column field. Clicking a specific data source should drilldown and run a detail report for that data source only, so the linked report has a filter on Source Database.
The progress dialog that appears when running a report that retrieves data from multiple databases now shows the name of the database the data is currently being retrieved from and the number of records retrieved.
Stonefield Query is now smarter about locating the GoldMine database information for GoldMine versions 7.0 and later, when installed on Windows Vista or later.
In the case where Query has no GoldMine databases available for reporting, it now gives an informative message about this, with instructions for resolving the problem.

Stonefield Query for ACT! 4.1

2011-03-04T11:51:00.001-06:00

We are pleased to announce the immediate release of Stonefield Query for ACT! version 4.1. There are lots of new and improved features in version 4.1.

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.

Charts

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.

Other Features

Emailing now supports SSL/TSL for SMTP, which means you can now email using Gmail or Hotmail accounts or other SMTP servers that require SSL/TSL. Also, emailing using MAPI with Microsoft Outlook as your email program no longer displays the dreaded Outlook security dialog.
Certain characters that weren't allowed in the name of a report, such as a period, comma, question mark, slash, and so on, are now allowed. The only character you can't use is a backslash ("\").
Certain characters that weren't supported in the body or subject of an email, such as "&" or ">", are now allowed.
You no longer have to contact us if you have to activate the program on a different computer than it was originally activated on. Online activation will automatically activate this computer and deactivate the license on the other one.
Output to text, comma-separated (CSV), table, and XML files is now faster.
Exclusion conditions now work faster than before.
The Preview window now remembers the setting of the zoom option. If you run a report and change the zoom to 200%, the next time you preview a report, it'll be at 200%.
The Ask At Runtime filter and report progress dialogs now always appear on top of any other windows so they can't get lost behind something else if you click on a different window.
The Setup dialog has a new page (page 2) for contact information.
The activation process is now simpler. Clicking the Click here to activate the program now link in the Welcome dialog (displayed when you're running an unactivated version) now displays the License Manager dialog where you can add as many licenses as you need rather than bringing up a Registration dialog that only allows one license to be activated.
New templates are automatically imported when you run Stonefield Query.
The OnSelect script for a report can now access the report using the Report object. This is useful if, for example, you want to change the default filter for a report when it's selected.
You can now use the built-in RunSQL function in formulas.
It's easier to work with the Dynamics tab in the properties dialog for Pictures and Rectangles in the Advanced Report Designer. You no longer have to enter values in 960th's of a inch; instead, you can enter value in inches or centimeters, depending on how your system is configured.
File dialogs, such as those displayed when you output to file or export a report, now support Windows Vista and later features, such as search and recent places.
The ask-at-runtime filter dialog now appears on top of the report progress window so it doesn't get hidden behind other windows.
The new GetValueForParameter function is like the existing GetValueForField but allows you to specify the caption, data type, and size of the parameter being requested from the user.
The "Add Report to ACT! Menu" screen now includes an option to output to the Stonefield Query preview window.

Stonefield Query for HEAT 4.1

2011-02-23T11:47:00.001-06:00

We are pleased to announce the immediate release of the Stonefield Query for HEAT version 4.1. There are lots of new and improved features in version 4.1.

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.
When you install a new version of Stonefield Query over an existing one, if there are any new or modified sample reports, a dialog appears telling you that and allowing you to select which of those to import. You can also choose the Check New or Updated Sample Reports function in the Tools menu.
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.

Charts

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.

Other Features

Emailing now supports SSL/TSL for SMTP, which means you can now email using Gmail or Hotmail accounts or other SMTP servers that require SSL/TSL. Also, emailing using MAPI with Microsoft Outlook as your email program no longer displays the dreaded Outlook security dialog.
Certain characters that weren't allowed in the name of a report, such as a period, comma, question mark, slash, and so on, are now allowed. The only character you can't use is a backslash ("\").
Certain characters that weren't supported in the body or subject of an email, such as "&" or ">", are now allowed.
You no longer have to contact us if you have to activate the program on a different computer than it was originally activated on. Online activation will automatically activate this computer and deactivate the license on the other one.
There's better support for adding images stored in your database to reports.
Output to text, comma-separated (CSV), table, and XML files is now faster.
Exclusion conditions now work faster than before.
The Preview window now remembers the setting of the zoom option. If you run a report and change the zoom to 200%, the next time you preview a report, it'll be at 200%.
The Ask At Runtime filter and report progress dialogs now always appear on top of any other windows so they can't get lost behind something else if you click on a different window.
The Setup dialog has a new page (page 2) for contact information.
The activation process is now simpler. Clicking the Click here to activate the program now link in the Welcome dialog (displayed when you're running an unactivated version) now displays the License Manager dialog where you can add as many licenses as you need rather than bringing up a Registration dialog that only allows one license to be activated.
New templates are automatically imported when you run Stonefield Query.
The OnSelect script for a report can now access the report using the Report object. This is useful if, for example, you want to change the default filter for a report when it's selected.
You can now use the built-in RunSQL function in formulas.
It's easier to work with the Dynamics tab in the properties dialog for Pictures and Rectangles in the Advanced Report Designer. You no longer have to enter values in 960th's of a inch; instead, you can enter value in inches or centimeters, depending on how your system is configured.
File dialogs, such as those displayed when you output to file or export a report, now support Windows Vista and later features, such as search and recent places.
The ask-at-runtime filter dialog now appears on top of the report progress window so it doesn't get hidden behind other windows.
The new GetValueForParameter function is like the existing GetValueForField but allows you to specify the caption, data type, and size of the parameter being requested from the user.
You can now filter on the Source Database field. This allows a report to drill down based on a data source. For example, suppose you have a cross-tab report that retrieves data from multiple data sources and it has Source Database as the column field. Clicking a specific data source should drilldown and run a detail report for that data source only, so the linked report has a filter on Source Database.
The progress dialog that appears when running a report that retrieves data from multiple databases now shows the name of the database the data is currently being retrieved from and the number of records retrieved.

Stonefield Query for Sage Timberline Office 4.1

2011-02-23T11:43:00.000-06:00

We are pleased to announce the immediate release of the Stonefield Query for Sage Timberline Office version 4.1. There are lots of new and improved features in version 4.1.

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.
When you install a new version of Stonefield Query over an existing one, if there are any new or modified sample reports, a dialog appears telling you that and allowing you to select which of those to import. You can also choose the Check New or Updated Sample Reports function in the Tools menu.
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.

Charts

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.

Other Features

Emailing now supports SSL/TSL for SMTP, which means you can now email using Gmail or Hotmail accounts or other SMTP servers that require SSL/TSL. Also, emailing using MAPI with Microsoft Outlook as your email program no longer displays the dreaded Outlook security dialog.
Certain characters that weren't allowed in the name of a report, such as a period, comma, question mark, slash, and so on, are now allowed. The only character you can't use is a backslash ("\").
Certain characters that weren't supported in the body or subject of an email, such as "&" or ">", are now allowed.
You no longer have to contact us if you have to activate the program on a different computer than it was originally activated on. Online activation will automatically activate this computer and deactivate the license on the other one.
There's better support for adding images stored in your database to reports.
Output to text, comma-separated (CSV), table, and XML files is now faster.
Exclusion conditions now work faster than before.
The Preview window now remembers the setting of the zoom option. If you run a report and change the zoom to 200%, the next time you preview a report, it'll be at 200%.
The Ask At Runtime filter and report progress dialogs now always appear on top of any other windows so they can't get lost behind something else if you click on a different window.
The Setup dialog has a new page (page 2) for contact information.
The activation process is now simpler. Clicking the Click here to activate the program now link in the Welcome dialog (displayed when you're running an unactivated version) now displays the License Manager dialog where you can add as many licenses as you need rather than bringing up a Registration dialog that only allows one license to be activated.
New templates are automatically imported when you run Stonefield Query.
The OnSelect script for a report can now access the report using the Report object. This is useful if, for example, you want to change the default filter for a report when it's selected.
You can now use the built-in RunSQL function in formulas.
It's easier to work with the Dynamics tab in the properties dialog for Pictures and Rectangles in the Advanced Report Designer. You no longer have to enter values in 960th's of a inch; instead, you can enter value in inches or centimeters, depending on how your system is configured.
File dialogs, such as those displayed when you output to file or export a report, now support Windows Vista and later features, such as search and recent places.
The ask-at-runtime filter dialog now appears on top of the report progress window so it doesn't get hidden behind other windows.
The new GetValueForParameter function is like the existing GetValueForField but allows you to specify the caption, data type, and size of the parameter being requested from the user.
You can now filter on the Source Database field. This allows a report to drill down based on a data source. For example, suppose you have a cross-tab report that retrieves data from multiple data sources and it has Source Database as the column field. Clicking a specific data source should drilldown and run a detail report for that data source only, so the linked report has a filter on Source Database.
The progress dialog that appears when running a report that retrieves data from multiple databases now shows the name of the database the data is currently being retrieved from and the number of records retrieved.

Stonefield Query for AccountMate 4.1

2011-02-23T11:14:00.002-06:00

We are pleased to announce the immediate release of the Stonefield Query for AccountMate version 4.1. This release includes both Stonefield Query for AccountMate SQL and Stonefield Query for AccountMate LAN. There are lots of new and improved features in version 4.1.

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.
When you install a new version of Stonefield Query over an existing one, if there are any new or modified sample reports, a dialog appears telling you that and allowing you to select which of those to import. You can also choose the Check New or Updated Sample Reports function in the Tools menu.
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.

Charts

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.

Other Features

Emailing now supports SSL/TSL for SMTP, which means you can now email using Gmail or Hotmail accounts or other SMTP servers that require SSL/TSL. Also, emailing using MAPI with Microsoft Outlook as your email program no longer displays the dreaded Outlook security dialog.
Certain characters that weren't allowed in the name of a report, such as a period, comma, question mark, slash, and so on, are now allowed. The only character you can't use is a backslash ("\").
Certain characters that weren't supported in the body or subject of an email, such as "&" or ">", are now allowed.
You no longer have to contact us if you have to activate the program on a different computer than it was originally activated on. Online activation will automatically activate this computer and deactivate the license on the other one.
There's better support for adding images stored in your database to reports.
Output to text, comma-separated (CSV), table, and XML files is now faster.
Exclusion conditions now work faster than before.
The Preview window now remembers the setting of the zoom option. If you run a report and change the zoom to 200%, the next time you preview a report, it'll be at 200%.
The Ask At Runtime filter and report progress dialogs now always appear on top of any other windows so they can't get lost behind something else if you click on a different window.
The Setup dialog has a new page (page 2) for contact information.
The activation process is now simpler. Clicking the Click here to activate the program now link in the Welcome dialog (displayed when you're running an unactivated version) now displays the License Manager dialog where you can add as many licenses as you need rather than bringing up a Registration dialog that only allows one license to be activated.
New templates are automatically imported when you run Stonefield Query.
The OnSelect script for a report can now access the report using the Report object. This is useful if, for example, you want to change the default filter for a report when it's selected.
You can now use the built-in RunSQL function in formulas.
It's easier to work with the Dynamics tab in the properties dialog for Pictures and Rectangles in the Advanced Report Designer. You no longer have to enter values in 960th's of a inch; instead, you can enter value in inches or centimeters, depending on how your system is configured.
File dialogs, such as those displayed when you output to file or export a report, now support Windows Vista and later features, such as search and recent places.
The ask-at-runtime filter dialog now appears on top of the report progress window so it doesn't get hidden behind other windows.
The new GetValueForParameter function is like the existing GetValueForField but allows you to specify the caption, data type, and size of the parameter being requested from the user.
You can now filter on the Source Database field. This allows a report to drill down based on a data source. For example, suppose you have a cross-tab report that retrieves data from multiple data sources and it has Source Database as the column field. Clicking a specific data source should drilldown and run a detail report for that data source only, so the linked report has a filter on Source Database.
The progress dialog that appears when running a report that retrieves data from multiple databases now shows the name of the database the data is currently being retrieved from and the number of records retrieved.

Stonefield Query for Sage Accpac ERP 4.1 Released

2011-02-21T13:21:00.001-06:00

We are pleased to announce the immediate release of Stonefield Query for Sage Accpac ERP version 4.1. There are lots of new and improved features in version 4.1.

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.
Sage Accpac ERP 6.0 is now supported.
The US Payroll Check Details and Canadian Payroll Cheque Details tables have new user-definable calculated fields that contain the amounts for certain earning and deduction types. For example, the Earnings Gross field contains the gross earnings amount and the Pension Employer field contains the employer portion of the pension deduction. These fields make creating payroll reports much easier, especially summary reports showing employee total amounts by deduction type. You can define the fields you want to use in the Options dialog.
The AR Documents table has a new Starting Balance field that shows the starting balance for the fiscal period the record is in.
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.
When you install a new version of Stonefield Query over an existing one, if there are any new or modified sample reports, a dialog appears telling you that and allowing you to select which of those to import. You can also choose the Check New or Updated Sample Reports function in the Tools menu.
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.

Charts

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.

Other Features

Emailing now supports SSL/TSL for SMTP, which means you can now email using Gmail or Hotmail accounts or other SMTP servers that require SSL/TSL. Also, emailing using MAPI with Microsoft Outlook as your email program no longer displays the dreaded Outlook security dialog.
Certain characters that weren't allowed in the name of a report, such as a period, comma, question mark, slash, and so on, are now allowed. The only character you can't use is a backslash ("\").
Certain characters that weren't supported in the body or subject of an email, such as "&" or ">", are now allowed.
You no longer have to contact us if you have to activate the program on a different computer than it was originally activated on. Online activation will automatically activate this computer and deactivate the license on the other one.
There's better support for adding images stored in your database to reports.
Output to text, comma-separated (CSV), table, and XML files is now faster.
Exclusion conditions now work faster than before.
The Preview window now remembers the setting of the zoom option. If you run a report and change the zoom to 200%, the next time you preview a report, it'll be at 200%.
The Ask At Runtime filter and report progress dialogs now always appear on top of any other windows so they can't get lost behind something else if you click on a different window.
The Setup dialog has a new page (page 2) for contact information.
The activation process is now simpler. Clicking the Click here to activate the program now link in the Welcome dialog (displayed when you're running an unactivated version) now displays the License Manager dialog where you can add as many licenses as you need rather than bringing up a Registration dialog that only allows one license to be activated.
New templates are automatically imported when you run Stonefield Query.
The OnSelect script for a report can now access the report using the Report object. This is useful if, for example, you want to change the default filter for a report when it's selected.
You can now use the built-in RunSQL function in formulas.
It's easier to work with the Dynamics tab in the properties dialog for Pictures and Rectangles in the Advanced Report Designer. You no longer have to enter values in 960th's of a inch; instead, you can enter value in inches or centimeters, depending on how your system is configured.
File dialogs, such as those displayed when you output to file or export a report, now support Windows Vista and later features, such as search and recent places.
The ask-at-runtime filter dialog now appears on top of the report progress window so it doesn't get hidden behind other windows.
The new GetValueForParameter function is like the existing GetValueForField but allows you to specify the caption, data type, and size of the parameter being requested from the user.
You can now filter on the Source Database field. This allows a report to drill down based on a data source. For example, suppose you have a cross-tab report that retrieves data from multiple data sources and it has Source Database as the column field. Clicking a specific data source should drilldown and run a detail report for that data source only, so the linked report has a filter on Source Database.
The progress dialog that appears when running a report that retrieves data from multiple databases now shows the name of the database the data is currently being retrieved from and the number of records retrieved.

Stonefield Query SDK Version 4.1.4063 Released

2011-02-15T13:56:00.001-06:00

We released version 4.1.4063 of the Stonefield Query SDK today. This is mainly a maintenance release (see Release History.txt for details after installing) but does have one new feature: you can now replace Report.ICO in the Stonefield Query program folder to use your own icon for desktop shortcuts to Stonefield Query reports.

Stonefield Query for Sage BusinessVision Version 4.0

2011-01-18T16:09:00.000-06:00

We are pleased to announce the immediate release of Stonefield Query for Sage BusinessVision version 4.0. In addition to all the new and improved features listed below, version 4.0 includes support for the new version 7.4 (2010) of Sage BusinessVision.

We have a video covering some of the new features in the Report Designer.

Report Wizards

You can now customize the relationships between tables in a report without having to edit the SQL statement for the report.
You can now turn on the Show percentage of total option when you use the Count and Count Distinct summary types in Quick and Cross-Tab reports.
You can now use the Highest and Lowest summary types on all fields, not just numeric ones.
You can now create a filter condition that compares a field in one table to a field in another table by using an expression condition.
Creating a formula by clicking the Formula button in Step 2 of the report wizards now automatically adds the new formula to the report.
The list displayed when you click the Values button in Step 2 of the report wizards or the Expression Builder now displays two columns of information for certain fields: the value displayed in reports and the actual value stored in the database.
If Stonefield Query closed due to a problem and you were in the middle of editing a report in a report wizard, the next time you start the program, it prompts if you want to recover and continue editing that report. Choosing No abandons the recovered report so the changes are lost.
You now have finer control over the placement of a report's filter in a custom SQL statement.

Quick Reports

You can now group on a field even if the Display this field in the report option is turned off. This is useful, for example, if you want to group on customer ID but display customer name in the group header.
You can now create bookmarks on fields that are included in the group header of another field.
You now get a warning in the Field Properties dialog if you turn on the Include this field in group header for option and select a grouped field in a different table than the current field.

Charts

New options in the Chart Wizard allow you to stack series in area, bar, and column charts and combine smaller slices into one "other" slice in pie charts.
You can now specify whether a chart added to a quick or cross-tab report appears at the top or bottom of the report using the new Position on report option.
The Total type option in the Field Properties dialog for the Chart Wizard has a new Count Distinct setting.
The Summary report option in Step 4 of the Chart Wizard has been removed. Instead, set Total type in the Field Properties dialog to None, meaning you want individual values plotted rather than summarized values.
The Multi-line option in the Labels page of Step 4 in the Chart Wizard is no longer available for Windows XP since that option is only supported in Windows Vista and later versions.
You now receive a warning if you create a quick or cross-tab report, add a chart to it, then remove one or more of the fields used in the chart.
Outputting a chart report to an image (such as GIF) now outputs just the chart, not an entire page with the template.

Cross-Tab Reports

You can now specify how a date field used in the row of a cross-tab report is formatted: as a date, hour, week, month, quarter, or year.
You can now specify the width and what to do if the width is too narrow in row and data fields in the Cross Tab Wizard.
The Field Properties dialog now has a Suppress repeating values option for row fields. If this option is turned on (which it is by default) and several records in a row have the same value in this field, only the first occurrence is printed; the field in subsequent records appears blank.
A new _TOTAL value is True only for the grand totals line in a cross-tab report, so you can use that in, for example, the Print When expression of an object in a template to output that object only for the totals line. Similarly, _SUBTOTAL can be used to output an object only in a subtotals line.

Preview and Output

A new file output type is available: Microsoft Excel PivotTable. This type, which is only available for cross-tab reports, creates an Excel PivotTable formatted the same as the cross-tab report, but you can use Excel to change or pivot the report as necessary.
You can now output cross-tabulation and advanced layout reports to more file types, including Microsoft Excel data-only and delimited.
The Embed fonts in the file option on the Output page allows you to embed the fonts used in the report, such as a barcode font, in a PDF file.
The Preview window now supports the same types of output types as the Output page of the Reports Explorer.
When you run a report, the Reports Explorer and any open report wizard windows become dim and a progress window appears, showing you the progress of the report process and allowing you to cancel the process before it finishes. You can turn this off if you wish by turning off the Display progress during report runs setting in the Options dialog.
You can now configure Stonefield Query to retrieve records from the database in batches (also known as asynchronously). This gives you the ability to stop a long-running report while records are retrieved rather than having to wait a long time for retrieval to be complete.

Advanced Report Designer

Several of the object property dialogs in the Advanced Report Designer have some changes. The Rotation option no longer appears on the General page but on its own Rotation page because it now shows a sample of how the rotation will look. The properties dialogs for field, picture, rectangle, and line objects have a new Dynamics page that allows you to conditionally alter the appearance of the object. Because the conditions on the Dynamics page are more flexible than dynamic font and color settings, those two items have been removed from the Style page for field objects.
You can now use gradient colors for rectangles in the Advanced Report Designer, both for reports and templates. A couple of new sample templates, Gradient Template and Valencia Orange, show how these can be used to produce nice, professional effects in your reports.
If you use Windows Vista or later, you can now change the printer used for an advanced layout report in the Page Layout page of the Report Properties dialog (this option was previously and is still available for Windows XP and earlier).

Other Features

Stonefield Query for Sage BusinessVision now supports BusinessVision version 2010 (7.4).
You can now use fields from tables involved in the report for exclusion conditions. This means you can create a report that, for example, shows all customer who bought something last year (using a filter condition of sales date is between January 1 and December 31 of last year) but didn't this year (using an exclude condition of sales date is between January 1 and December 31 of this year).
The performance of certain types of formulas was improved.
The Formulas dialog now has a Copy function to make it easier to create a formula similar to an existing one.
The Formula Editor now has a Data group option so you can select the data group the tables in the Tables list are from.
The default name when you copy a report is now the existing report name with a "1" suffix; in previous versions, the default name was blank.
The login dialog now has a link to the Setup dialog. This is useful if you need to change something about the Stonefield Query setup before logging in.
You cannot schedule reports if you are running Stonefield Query on Windows Terminal Server or Citrix since those environments don't permit it.
The version number now displays in the Reports Explorer title bar so you can quickly see which version you are running.
You can now specify carbon copy (CC) addresses when sending emails.
If you're using Microsoft Outlook or some other MAPI email program, you can now enter the name of a distribution list in the To, CC, and BCC options to send the email to a group of people.
Importing several reports that use formulas at one time is now significantly faster than before.
Specifying "ALLOWDIALOGS" when running Stonefield Query from another application or the command line now causes a progress dialog to display as the report runs.
Diagnostic logging is now always performed. A file called Diagnostic.TXT is created in the Data subdirectory of the program folder and is overwritten every time you start Stonefield Query. This file is very useful for tracking down errors or performance issues, and previously was only created if a file named Log.TXT existed.
Stonefield Query now displays a message that it's retrieving news items while it does that task so you can see what's going on.

Final Thoughts on Looking at Stonefield Query

2010-10-06T15:43:00.001-06:00

George Jensen of CustomerFX has concluded his series of posts about his experience learning Stonefield Query. Check out his articles: part 1, part 2, part 3, part 4, part 5, part 6, and part 7.

Stonefield Query for HEAT 4.0

2010-09-17T11:18:00.001-06:00

We are pleased to announce the immediate release of Stonefield Query for HEAT version 4.0. There are lots of new and improved features in version 4.0.

We have a video covering some of the new features in the Report Designer.

Report Wizards

You can now customize the relationships between tables in a report without having to edit the SQL statement for the report.
You can now turn on the Show percentage of total option when you use the Count and Count Distinct summary types in Quick and Cross-Tab reports.
You can now use the Highest and Lowest summary types on all fields, not just numeric ones.
You can now create a filter condition that compares a field in one table to a field in another table by using an expression condition.
Creating a formula by clicking the Formula button in Step 2 of the report wizards now automatically adds the new formula to the report.
The list displayed when you click the Values button in Step 2 of the report wizards or the Expression Builder now displays two columns of information for certain fields: the value displayed in reports and the actual value stored in the database.
If Stonefield Query closed due to a problem and you were in the middle of editing a report in a report wizard, the next time you start the program, it prompts if you want to recover and continue editing that report. Choosing No abandons the recovered report so the changes are lost.
You now have finer control over the placement of a report's filter in a custom SQL statement.

Quick Reports

You can now group on a field even if the Display this field in the report option is turned off. This is useful, for example, if you want to group on customer ID but display customer name in the group header.
You can now create bookmarks on fields that are included in the group header of another field.
You now get a warning in the Field Properties dialog if you turn on the Include this field in group header for option and select a grouped field in a different table than the current field.

Charts

New options in the Chart Wizard allow you to stack series in area, bar, and column charts and combine smaller slices into one "other" slice in pie charts.
You can now specify whether a chart added to a quick or cross-tab report appears at the top or bottom of the report using the new Position on report option.
The Total type option in the Field Properties dialog for the Chart Wizard has a new Count Distinct setting.
The Summary report option in Step 4 of the Chart Wizard has been removed. Instead, set Total type in the Field Properties dialog to None, meaning you want individual values plotted rather than summarized values.
The Multi-line option in the Labels page of Step 4 in the Chart Wizard is no longer available for Windows XP since that option is only supported in Windows Vista and later versions.
You now receive a warning if you create a quick or cross-tab report, add a chart to it, then remove one or more of the fields used in the chart.
Outputting a chart report to an image (such as GIF) now outputs just the chart, not an entire page with the template.

Cross-Tab Reports

You can now specify how a date field used in the row of a cross-tab report is formatted: as a date, hour, week, month, quarter, or year.
You can now specify the width and what to do if the width is too narrow in row and data fields in the Cross Tab Wizard.
The Field Properties dialog now has a Suppress repeating values option for row fields. If this option is turned on (which it is by default) and several records in a row have the same value in this field, only the first occurrence is printed; the field in subsequent records appears blank.
A new _TOTAL value is True only for the grand totals line in a cross-tab report, so you can use that in, for example, the Print When expression of an object in a template to output that object only for the totals line. Similarly, _SUBTOTAL can be used to output an object only in a subtotals line.

Preview and Output

A new file output type is available: Microsoft Excel PivotTable. This type, which is only available for cross-tab reports, creates an Excel PivotTable formatted the same as the cross-tab report, but you can use Excel to change or pivot the report as necessary.
You can now output cross-tabulation and advanced layout reports to more file types, including Microsoft Excel data-only and delimited.
The Embed fonts in the file option on the Output page allows you to embed the fonts used in the report, such as a barcode font, in a PDF file.
The Preview window now supports the same types of output types as the Output page of the Reports Explorer.
When you run a report, the Reports Explorer and any open report wizard windows become dim and a progress window appears, showing you the progress of the report process and allowing you to cancel the process before it finishes. You can turn this off if you wish by turning off the Display progress during report runs setting in the Options dialog.
You can now configure Stonefield Query to retrieve records from the database in batches (also known as asynchronously). This gives you the ability to stop a long-running report while records are retrieved rather than having to wait a long time for retrieval to be complete.

Advanced Report Designer

Several of the object property dialogs in the Advanced Report Designer have some changes. The Rotation option no longer appears on the General page but on its own Rotation page because it now shows a sample of how the rotation will look. The properties dialogs for field, picture, rectangle, and line objects have a new Dynamics page that allows you to conditionally alter the appearance of the object. Because the conditions on the Dynamics page are more flexible than dynamic font and color settings, those two items have been removed from the Style page for field objects.
You can now use gradient colors for rectangles in the Advanced Report Designer, both for reports and templates. A couple of new sample templates, Gradient Template and Valencia Orange, show how these can be used to produce nice, professional effects in your reports.
If you use Windows Vista or later, you can now change the printer used for an advanced layout report in the Page Layout page of the Report Properties dialog (this option was previously and is still available for Windows XP and earlier).

Other Features

Stonefield Query for HEAT now supports HEAT version 9.5 and lower.
You can now use fields from tables involved in the report for exclusion conditions. This means you can create a report that, for example, shows all customer who bought something last year (using a filter condition of sales date is between January 1 and December 31 of last year) but didn't this year (using an exclude condition of sales date is between January 1 and December 31 of this year).
The performance of certain types of formulas was improved.
The Formulas dialog now has a Copy function to make it easier to create a formula similar to an existing one.
The Formula Editor now has a Data group option so you can select the data group the tables in the Tables list are from.
The default name when you copy a report is now the existing report name with a "1" suffix; in previous versions, the default name was blank.
The login dialog now has a link to the Setup dialog. This is useful if you need to change something about the Stonefield Query setup before logging in.
You cannot schedule reports if you are running Stonefield Query on Windows Terminal Server or Citrix since those environments don't permit it.
The version number now displays in the Reports Explorer title bar so you can quickly see which version you are running.
You can now specify carbon copy (CC) addresses when sending emails.
If you're using Microsoft Outlook or some other MAPI email program, you can now enter the name of a distribution list in the To, CC, and BCC options to send the email to a group of people.
Importing several reports that use formulas at one time is now significantly faster than before.
Specifying "ALLOWDIALOGS" when running Stonefield Query from another application or the command line now causes a progress dialog to display as the report runs.
Diagnostic logging is now always performed. A file called Diagnostic.TXT is created in the Data subdirectory of the program folder and is overwritten every time you start Stonefield Query. This file is very useful for tracking down errors or performance issues, and previously was only created if a file named Log.TXT existed.
Stonefield Query now displays a message that it's retrieving news items while it does that task so you can see what's going on.

Stonefield Query for Sage Pro ERP version 4.0

2010-09-16T11:11:00.001-06:00

We are pleased to announce the immediate release of Stonefield Query for Sage Pro ERP version 4.0. There are lots of new and improved features in version 4.0.

We have a video covering some of the new features in the Report Designer.

Report Wizards

You can now customize the relationships between tables in a report without having to edit the SQL statement for the report.
You can now turn on the Show percentage of total option when you use the Count and Count Distinct summary types in Quick and Cross-Tab reports.
You can now use the Highest and Lowest summary types on all fields, not just numeric ones.
You can now create a filter condition that compares a field in one table to a field in another table by using an expression condition.
Creating a formula by clicking the Formula button in Step 2 of the report wizards now automatically adds the new formula to the report.
The list displayed when you click the Values button in Step 2 of the report wizards or the Expression Builder now displays two columns of information for certain fields: the value displayed in reports and the actual value stored in the database.
If Stonefield Query closed due to a problem and you were in the middle of editing a report in a report wizard, the next time you start the program, it prompts if you want to recover and continue editing that report. Choosing No abandons the recovered report so the changes are lost.
You now have finer control over the placement of a report's filter in a custom SQL statement.

Quick Reports

You can now group on a field even if the Display this field in the report option is turned off. This is useful, for example, if you want to group on customer ID but display customer name in the group header.
You can now create bookmarks on fields that are included in the group header of another field.
You now get a warning in the Field Properties dialog if you turn on the Include this field in group header for option and select a grouped field in a different table than the current field.

Charts

New options in the Chart Wizard allow you to stack series in area, bar, and column charts and combine smaller slices into one "other" slice in pie charts.
You can now specify whether a chart added to a quick or cross-tab report appears at the top or bottom of the report using the new Position on report option.
The Total type option in the Field Properties dialog for the Chart Wizard has a new Count Distinct setting.
The Summary report option in Step 4 of the Chart Wizard has been removed. Instead, set Total type in the Field Properties dialog to None, meaning you want individual values plotted rather than summarized values.
The Multi-line option in the Labels page of Step 4 in the Chart Wizard is no longer available for Windows XP since that option is only supported in Windows Vista and later versions.
You now receive a warning if you create a quick or cross-tab report, add a chart to it, then remove one or more of the fields used in the chart.
Outputting a chart report to an image (such as GIF) now outputs just the chart, not an entire page with the template.

Cross-Tab Reports

You can now specify how a date field used in the row of a cross-tab report is formatted: as a date, hour, week, month, quarter, or year.
You can now specify the width and what to do if the width is too narrow in row and data fields in the Cross Tab Wizard.
The Field Properties dialog now has a Suppress repeating values option for row fields. If this option is turned on (which it is by default) and several records in a row have the same value in this field, only the first occurrence is printed; the field in subsequent records appears blank.
A new _TOTAL value is True only for the grand totals line in a cross-tab report, so you can use that in, for example, the Print When expression of an object in a template to output that object only for the totals line. Similarly, _SUBTOTAL can be used to output an object only in a subtotals line.

Preview and Output

A new file output type is available: Microsoft Excel PivotTable. This type, which is only available for cross-tab reports, creates an Excel PivotTable formatted the same as the cross-tab report, but you can use Excel to change or pivot the report as necessary.
You can now output cross-tabulation and advanced layout reports to more file types, including Microsoft Excel data-only and delimited.
The Embed fonts in the file option on the Output page allows you to embed the fonts used in the report, such as a barcode font, in a PDF file.
The Preview window now supports the same types of output types as the Output page of the Reports Explorer.
When you run a report, the Reports Explorer and any open report wizard windows become dim and a progress window appears, showing you the progress of the report process and allowing you to cancel the process before it finishes. You can turn this off if you wish by turning off the Display progress during report runs setting in the Options dialog.
You can now configure Stonefield Query to retrieve records from the database in batches (also known as asynchronously). This gives you the ability to stop a long-running report while records are retrieved rather than having to wait a long time for retrieval to be complete.

Advanced Report Designer

Several of the object property dialogs in the Advanced Report Designer have some changes. The Rotation option no longer appears on the General page but on its own Rotation page because it now shows a sample of how the rotation will look. The properties dialogs for field, picture, rectangle, and line objects have a new Dynamics page that allows you to conditionally alter the appearance of the object. Because the conditions on the Dynamics page are more flexible than dynamic font and color settings, those two items have been removed from the Style page for field objects.
You can now use gradient colors for rectangles in the Advanced Report Designer, both for reports and templates. A couple of new sample templates, Gradient Template and Valencia Orange, show how these can be used to produce nice, professional effects in your reports.
If you use Windows Vista or later, you can now change the printer used for an advanced layout report in the Page Layout page of the Report Properties dialog (this option was previously and is still available for Windows XP and earlier).

Other Features

You can now use fields from tables involved in the report for exclusion conditions. This means you can create a report that, for example, shows all customer who bought something last year (using a filter condition of sales date is between January 1 and December 31 of last year) but didn't this year (using an exclude condition of sales date is between January 1 and December 31 of this year).
The performance of certain types of formulas was improved.
The Formulas dialog now has a Copy function to make it easier to create a formula similar to an existing one.
The Formula Editor now has a Data group option so you can select the data group the tables in the Tables list are from.
The default name when you copy a report is now the existing report name with a "1" suffix; in previous versions, the default name was blank.
The login dialog now has a link to the Setup dialog. This is useful if you need to change something about the Stonefield Query setup before logging in.
You cannot schedule reports if you are running Stonefield Query on Windows Terminal Server or Citrix since those environments don't permit it.
The version number now displays in the Reports Explorer title bar so you can quickly see which version you are running.
You can now specify carbon copy (CC) addresses when sending emails.
If you're using Microsoft Outlook or some other MAPI email program, you can now enter the name of a distribution list in the To, CC, and BCC options to send the email to a group of people.
Importing several reports that use formulas at one time is now significantly faster than before.
Specifying "ALLOWDIALOGS" when running Stonefield Query from another application or the command line now causes a progress dialog to display as the report runs.
Diagnostic logging is now always performed. A file called Diagnostic.TXT is created in the Data subdirectory of the program folder and is overwritten every time you start Stonefield Query. This file is very useful for tracking down errors or performance issues, and previously was only created if a file named Log.TXT existed.
Stonefield Query now displays a message that it's retrieving news items while it does that task so you can see what's going on.

Stonefield Query for ALERE 4.0

2010-09-10T11:43:00.000-06:00

We are pleased to announce the immediate release of Stonefield Query for ALERE version 4.0. There are lots of new and improved features in version 4.0.

We have a video covering some of the new features in the Report Designer.

Report Wizards

You can now customize the relationships between tables in a report without having to edit the SQL statement for the report.
You can now turn on the Show percentage of total option when you use the Count and Count Distinct summary types in Quick and Cross-Tab reports.
You can now use the Highest and Lowest summary types on all fields, not just numeric ones.
You can now create a filter condition that compares a field in one table to a field in another table by using an expression condition.
Creating a formula by clicking the Formula button in Step 2 of the report wizards now automatically adds the new formula to the report.
The list displayed when you click the Values button in Step 2 of the report wizards or the Expression Builder now displays two columns of information for certain fields: the value displayed in reports and the actual value stored in the database.
If Stonefield Query closed due to a problem and you were in the middle of editing a report in a report wizard, the next time you start the program, it prompts if you want to recover and continue editing that report. Choosing No abandons the recovered report so the changes are lost.
You now have finer control over the placement of a report's filter in a custom SQL statement.

Quick Reports

You can now group on a field even if the Display this field in the report option is turned off. This is useful, for example, if you want to group on customer ID but display customer name in the group header.
You can now create bookmarks on fields that are included in the group header of another field.
You now get a warning in the Field Properties dialog if you turn on the Include this field in group header for option and select a grouped field in a different table than the current field.

Charts

New options in the Chart Wizard allow you to stack series in area, bar, and column charts and combine smaller slices into one "other" slice in pie charts.
You can now specify whether a chart added to a quick or cross-tab report appears at the top or bottom of the report using the new Position on report option.
The Total type option in the Field Properties dialog for the Chart Wizard has a new Count Distinct setting.
The Summary report option in Step 4 of the Chart Wizard has been removed. Instead, set Total type in the Field Properties dialog to None, meaning you want individual values plotted rather than summarized values.
The Multi-line option in the Labels page of Step 4 in the Chart Wizard is no longer available for Windows XP since that option is only supported in Windows Vista and later versions.
You now receive a warning if you create a quick or cross-tab report, add a chart to it, then remove one or more of the fields used in the chart.
Outputting a chart report to an image (such as GIF) now outputs just the chart, not an entire page with the template.

Cross-Tab Reports

You can now specify how a date field used in the row of a cross-tab report is formatted: as a date, hour, week, month, quarter, or year.
You can now specify the width and what to do if the width is too narrow in row and data fields in the Cross Tab Wizard.
The Field Properties dialog now has a Suppress repeating values option for row fields. If this option is turned on (which it is by default) and several records in a row have the same value in this field, only the first occurrence is printed; the field in subsequent records appears blank.
A new _TOTAL value is True only for the grand totals line in a cross-tab report, so you can use that in, for example, the Print When expression of an object in a template to output that object only for the totals line. Similarly, _SUBTOTAL can be used to output an object only in a subtotals line.

Preview and Output

A new file output type is available: Microsoft Excel PivotTable. This type, which is only available for cross-tab reports, creates an Excel PivotTable formatted the same as the cross-tab report, but you can use Excel to change or pivot the report as necessary.
You can now output cross-tabulation and advanced layout reports to more file types, including Microsoft Excel data-only and delimited.
The Embed fonts in the file option on the Output page allows you to embed the fonts used in the report, such as a barcode font, in a PDF file.
The Preview window now supports the same types of output types as the Output page of the Reports Explorer.
When you run a report, the Reports Explorer and any open report wizard windows become dim and a progress window appears, showing you the progress of the report process and allowing you to cancel the process before it finishes. You can turn this off if you wish by turning off the Display progress during report runs setting in the Options dialog.

Advanced Report Designer

Several of the object property dialogs in the Advanced Report Designer have some changes. The Rotation option no longer appears on the General page but on its own Rotation page because it now shows a sample of how the rotation will look. The properties dialogs for field, picture, rectangle, and line objects have a new Dynamics page that allows you to conditionally alter the appearance of the object. Because the conditions on the Dynamics page are more flexible than dynamic font and color settings, those two items have been removed from the Style page for field objects.
You can now use gradient colors for rectangles in the Advanced Report Designer, both for reports and templates. A couple of new sample templates, Gradient Template and Valencia Orange, show how these can be used to produce nice, professional effects in your reports.
If you use Windows Vista or later, you can now change the printer used for an advanced layout report in the Page Layout page of the Report Properties dialog (this option was previously and is still available for Windows XP and earlier).

Other Features

When Stonefield Query finds an ALERE SQL database and asks for "connection info", you can select the "I do not want to report on this ALERE Company" option if you don't know the connection information for that SQL database or do not want to report on it.
Some fields in the ALERE database are actually a Code value that joins to the "Company Codes" table. In Stonefield Query, these fields automatically display as the "Code Description" value from the "Company Codes" table instead of as the Code value. Each of these "Code Description" fields also has a companion field that let's you display the original Code value in a report if needed.
The "Inventory Location" table has a few new calculated fields:

"On Hand Value" = "Quantity On Hand" * "Average Cost"
"Alllocated" = "Sales Order Allocation" + "Work Order Allocation"
"On Order" = "On Order from Purchase Order" + "On Order from Work Order"
"Available" = "Quantity On Hand" + "On Order from Purchase Order" + "On Order from Work Order" - ("Sales Order Allocation" + "Work Order Allocation")
The "Inventory Activity Log" table now contains a calculated "Status" field that tells you the Status of the record based on the "Transaction Type" and "Order Type".
You can now use fields from tables involved in the report for exclusion conditions. This means you can create a report that, for example, shows all customer who bought something last year (using a filter condition of sales date is between January 1 and December 31 of last year) but didn't this year (using an exclude condition of sales date is between January 1 and December 31 of this year).
The performance of certain types of formulas was improved.
The Formulas dialog now has a Copy function to make it easier to create a formula similar to an existing one.
The Formula Editor now has a Data Provider option so you can select the data provider the tables in the Tables list are from.
The default name when you copy a report is now the existing report name with a "1" suffix; in previous versions, the default name was blank.
The login dialog now has a link to the Setup dialog. This is useful if you need to change something about the Stonefield Query setup before logging in.
You cannot schedule reports if you are running Stonefield Query on Windows Terminal Server or Citrix since those environments don't permit it.
The version number now displays in the Reports Explorer title bar so you can quickly see which version you are running.
You can now specify carbon copy (CC) addresses when sending emails.
If you're using Microsoft Outlook or some other MAPI email program, you can now enter the name of a distribution list in the To, CC, and BCC options to send the email to a group of people.
Importing several reports that use formulas at one time is now significantly faster than before.
Specifying "ALLOWDIALOGS" when running Stonefield Query from another application or the command line now causes a progress dialog to display as the report runs.
Diagnostic logging is now always performed. A file called Diagnostic.TXT is created in the Data subdirectory of the program folder and is overwritten every time you start Stonefield Query. This file is very useful for tracking down errors or performance issues, and previously was only created if a file named Log.TXT existed.
Stonefield Query now displays a message that it's retrieving news items while it does that task so you can see what's going on.

Even More Looking at Stonefield Query

2010-09-02T10:12:00.001-06:00

George Jensen of CustomerFX has added several more posts about his experience learning Stonefield Query. Check out his articles: part 1, part 2, part 3, part 4, and part 5.

Stonefield Query for SalesLogix 4.0

2010-08-27T15:08:00.002-06:00

We are pleased to announce the immediate release of Stonefield Query for SalesLogix version 4.0. There are lots of new and improved features in version 4.0.

We have a video covering some of the new features in the Report Designer.

Report Wizards

You can now customize the relationships between tables in a report without having to edit the SQL statement for the report.
You can now turn on the Show percentage of total option when you use the Count and Count Distinct summary types in Quick and Cross-Tab reports.
You can now use the Highest and Lowest summary types on all fields, not just numeric ones.
You can now create a filter condition that compares a field in one table to a field in another table by using an expression condition.
Creating a formula by clicking the Formula button in Step 2 of the report wizards now automatically adds the new formula to the report.
The list displayed when you click the Values button in Step 2 of the report wizards or the Expression Builder now displays two columns of information for certain fields: the value displayed in reports and the actual value stored in the database.
If Stonefield Query closed due to a problem and you were in the middle of editing a report in a report wizard, the next time you start the program, it prompts if you want to recover and continue editing that report. Choosing No abandons the recovered report so the changes are lost.
You now have finer control over the placement of a report's filter in a custom SQL statement.

Quick Reports

You can now group on a field even if the Display this field in the report option is turned off. This is useful, for example, if you want to group on customer ID but display customer name in the group header.
You can now create bookmarks on fields that are included in the group header of another field.
You now get a warning in the Field Properties dialog if you turn on the Include this field in group header for option and select a grouped field in a different table than the current field.

Charts

New options in the Chart Wizard allow you to stack series in area, bar, and column charts and combine smaller slices into one "other" slice in pie charts.
You can now specify whether a chart added to a quick or cross-tab report appears at the top or bottom of the report using the new Position on report option.
The Total type option in the Field Properties dialog for the Chart Wizard has a new Count Distinct setting.
The Summary report option in Step 4 of the Chart Wizard has been removed. Instead, set Total type in the Field Properties dialog to None, meaning you want individual values plotted rather than summarized values.
The Multi-line option in the Labels page of Step 4 in the Chart Wizard is no longer available for Windows XP since that option is only supported in Windows Vista and later versions.
You now receive a warning if you create a quick or cross-tab report, add a chart to it, then remove one or more of the fields used in the chart.
Outputting a chart report to an image (such as GIF) now outputs just the chart, not an entire page with the template.

Cross-Tab Reports

You can now specify how a date field used in the row of a cross-tab report is formatted: as a date, hour, week, month, quarter, or year.
You can now specify the width and what to do if the width is too narrow in row and data fields in the Cross Tab Wizard.
The Field Properties dialog now has a Suppress repeating values option for row fields. If this option is turned on (which it is by default) and several records in a row have the same value in this field, only the first occurrence is printed; the field in subsequent records appears blank.
A new _TOTAL value is True only for the grand totals line in a cross-tab report, so you can use that in, for example, the Print When expression of an object in a template to output that object only for the totals line. Similarly, _SUBTOTAL can be used to output an object only in a subtotals line.

Preview and Output

A new file output type is available: Microsoft Excel PivotTable. This type, which is only available for cross-tab reports, creates an Excel PivotTable formatted the same as the cross-tab report, but you can use Excel to change or pivot the report as necessary.
You can now output cross-tabulation and advanced layout reports to more file types, including Microsoft Excel data-only and delimited.
The Embed fonts in the file option on the Output page allows you to embed the fonts used in the report, such as a barcode font, in a PDF file.
The Preview window now supports the same types of output types as the Output page of the Reports Explorer.
When you run a report, the Reports Explorer and any open report wizard windows become dim and a progress window appears, showing you the progress of the report process and allowing you to cancel the process before it finishes. You can turn this off if you wish by turning off the Display progress during report runs setting in the Options dialog.

Advanced Report Designer

Several of the object property dialogs in the Advanced Report Designer have some changes. The Rotation option no longer appears on the General page but on its own Rotation page because it now shows a sample of how the rotation will look. The properties dialogs for field, picture, rectangle, and line objects have a new Dynamics page that allows you to conditionally alter the appearance of the object. Because the conditions on the Dynamics page are more flexible than dynamic font and color settings, those two items have been removed from the Style page for field objects.
You can now use gradient colors for rectangles in the Advanced Report Designer, both for reports and templates. A couple of new sample templates, Gradient Template and Valencia Orange, show how these can be used to produce nice, professional effects in your reports.
If you use Windows Vista or later, you can now change the printer used for an advanced layout report in the Page Layout page of the Report Properties dialog (this option was previously and is still available for Windows XP and earlier).

Other Features

You can now use fields from tables involved in the report for exclusion conditions. This means you can create a report that, for example, shows all customer who bought something last year (using a filter condition of sales date is between January 1 and December 31 of last year) but didn't this year (using an exclude condition of sales date is between January 1 and December 31 of this year).
The performance of certain types of formulas was improved.
The Formulas dialog now has a Copy function to make it easier to create a formula similar to an existing one.
The Formula Editor now has a Data Provider option so you can select the data provider the tables in the Tables list are from.
The default name when you copy a report is now the existing report name with a "1" suffix; in previous versions, the default name was blank.
The login dialog now has a link to the Setup dialog. This is useful if you need to change something about the Stonefield Query setup before logging in.
You cannot schedule reports if you are running Stonefield Query on Windows Terminal Server or Citrix since those environments don't permit it.
The version number now displays in the Reports Explorer title bar so you can quickly see which version you are running.
You can now specify carbon copy (CC) addresses when sending emails.
If you're using Microsoft Outlook or some other MAPI email program, you can now enter the name of a distribution list in the To, CC, and BCC options to send the email to a group of people.
Importing several reports that use formulas at one time is now significantly faster than before.
Specifying "ALLOWDIALOGS" when running Stonefield Query from another application or the command line now causes a progress dialog to display as the report runs.
Diagnostic logging is now always performed. A file called Diagnostic.TXT is created in the Data subdirectory of the program folder and is overwritten every time you start Stonefield Query. This file is very useful for tracking down errors or performance issues, and previously was only created if a file named Log.TXT existed.
Stonefield Query now displays a message that it's retrieving news items while it does that task so you can see what's going on.

More Looking at Stonefield Query

2010-08-18T15:38:00.001-06:00

George Jensen of CustomerFX has added a couple of more posts about his experience learning Stonefield Query. Check out his articles: part 1, part 2, part 3, and part 4.

Stonefield Query for GoldMine 4.0

2010-08-18T11:04:00.005-06:00

We are pleased to announce the immediate release of Stonefield Query for GoldMine version 4.0. There are lots of new and improved features in version 4.0.

We have a video covering some of the new features in the Report Designer.

Report Wizards

You can now customize the relationships between tables in a report without having to edit the SQL statement for the report.
You can now turn on the Show percentage of total option when you use the Count and Count Distinct summary types in Quick and Cross-Tab reports.
You can now use the Highest and Lowest summary types on all fields, not just numeric ones.
You can now create a filter condition that compares a field in one table to a field in another table by using an expression condition.
Creating a formula by clicking the Formula button in Step 2 of the report wizards now automatically adds the new formula to the report.
The list displayed when you click the Values button in Step 2 of the report wizards or the Expression Builder now displays two columns of information for certain fields: the value displayed in reports and the actual value stored in the database.
If Stonefield Query closed due to a problem and you were in the middle of editing a report in a report wizard, the next time you start the program, it prompts if you want to recover and continue editing that report. Choosing No abandons the recovered report so the changes are lost.
You now have finer control over the placement of a report's filter in a custom SQL statement.

Quick Reports

You can now group on a field even if the Display this field in the report option is turned off. This is useful, for example, if you want to group on customer ID but display customer name in the group header.
You can now create bookmarks on fields that are included in the group header of another field.
You now get a warning in the Field Properties dialog if you turn on the Include this field in group header for option and select a grouped field in a different table than the current field.

Charts

New options in the Chart Wizard allow you to stack series in area, bar, and column charts and combine smaller slices into one "other" slice in pie charts.
You can now specify whether a chart added to a quick or cross-tab report appears at the top or bottom of the report using the new Position on report option.
The Total type option in the Field Properties dialog for the Chart Wizard has a new Count Distinct setting.
The Summary report option in Step 4 of the Chart Wizard has been removed. Instead, set Total type in the Field Properties dialog to None, meaning you want individual values plotted rather than summarized values.
The Multi-line option in the Labels page of Step 4 in the Chart Wizard is no longer available for Windows XP since that option is only supported in Windows Vista and later versions.
You now receive a warning if you create a quick or cross-tab report, add a chart to it, then remove one or more of the fields used in the chart.
Outputting a chart report to an image (such as GIF) now outputs just the chart, not an entire page with the template.

Cross-Tab Reports

You can now specify how a date field used in the row of a cross-tab report is formatted: as a date, hour, week, month, quarter, or year.
You can now specify the width and what to do if the width is too narrow in row and data fields in the Cross Tab Wizard.
The Field Properties dialog now has a Suppress repeating values option for row fields. If this option is turned on (which it is by default) and several records in a row have the same value in this field, only the first occurrence is printed; the field in subsequent records appears blank.
A new _TOTAL value is True only for the grand totals line in a cross-tab report, so you can use that in, for example, the Print When expression of an object in a template to output that object only for the totals line. Similarly, _SUBTOTAL can be used to output an object only in a subtotals line.

Preview and Output

A new file output type is available: Microsoft Excel PivotTable. This type, which is only available for cross-tab reports, creates an Excel PivotTable formatted the same as the cross-tab report, but you can use Excel to change or pivot the report as necessary.
You can now output cross-tabulation and advanced layout reports to more file types, including Microsoft Excel data-only and delimited.
The Embed fonts in the file option on the Output page allows you to embed the fonts used in the report, such as a barcode font, in a PDF file.
The Preview window now supports the same types of output types as the Output page of the Reports Explorer.
When you run a report, the Reports Explorer and any open report wizard windows become dim and a progress window appears, showing you the progress of the report process and allowing you to cancel the process before it finishes. You can turn this off if you wish by turning off the Display progress during report runs setting in the Options dialog.

Advanced Report Designer

Several of the object property dialogs in the Advanced Report Designer have some changes. The Rotation option no longer appears on the General page but on its own Rotation page because it now shows a sample of how the rotation will look. The properties dialogs for field, picture, rectangle, and line objects have a new Dynamics page that allows you to conditionally alter the appearance of the object. Because the conditions on the Dynamics page are more flexible than dynamic font and color settings, those two items have been removed from the Style page for field objects.
You can now use gradient colors for rectangles in the Advanced Report Designer, both for reports and templates. A couple of new sample templates, Gradient Template and Valencia Orange, show how these can be used to produce nice, professional effects in your reports.
If you use Windows Vista or later, you can now change the printer used for an advanced layout report in the Page Layout page of the Report Properties dialog (this option was previously and is still available for Windows XP and earlier).

Other Features

Stonefield Query now works with GoldMine version 9.
You can now use fields from tables involved in the report for exclusion conditions. This means you can create a report that, for example, shows all customer who bought something last year (using a filter condition of sales date is between January 1 and December 31 of last year) but didn't this year (using an exclude condition of sales date is between January 1 and December 31 of this year).
The performance of certain types of formulas was improved.
The Formulas dialog now has a Copy function to make it easier to create a formula similar to an existing one.
The Formula Editor now has a Data Provider option so you can select the data provider the tables in the Tables list are from.
The default name when you copy a report is now the existing report name with a "1" suffix; in previous versions, the default name was blank.
The login dialog now has a link to the Setup dialog. This is useful if you need to change something about the Stonefield Query setup before logging in.
You cannot schedule reports if you are running Stonefield Query on Windows Terminal Server or Citrix since those environments don't permit it.
The version number now displays in the Reports Explorer title bar so you can quickly see which version you are running.
You can now specify carbon copy (CC) addresses when sending emails.
If you're using Microsoft Outlook or some other MAPI email program, you can now enter the name of a distribution list in the To, CC, and BCC options to send the email to a group of people.
Importing several reports that use formulas at one time is now significantly faster than before.
Specifying "ALLOWDIALOGS" when running Stonefield Query from another application or the command line now causes a progress dialog to display as the report runs.
Diagnostic logging is now always performed. A file called Diagnostic.TXT is created in the Data subdirectory of the program folder and is overwritten every time you start Stonefield Query. This file is very useful for tracking down errors or performance issues, and previously was only created if a file named Log.TXT existed.
Stonefield Query now displays a message that it's retrieving news items while it does that task so you can see what's going on.
Query now handles SQL Server databases with a blank password more cleanly.
A new "Combined Opportunity and Project" table is now available.
Adding items to the GoldMine menu now creates an XML settings file, rather than including the settings in the GoldMine command itself.
The account number field in the Main table is now sortable and can be used in filters.

Looking at Stonefield Query

2010-08-02T17:55:00.001-06:00

George Jensen of CustomerFX has been blogging about his experience learning Stonefield Query (specifically the SalesLogix version but it’s applicable to all versions). Check out his articles: part 1 and part 2.

Stonefield Query for ACT! 4.0

2010-07-29T11:30:00.005-06:00

We are pleased to announce the immediate release of Stonefield Query for ACT! version 4.0. There are lots of new and improved features in version 4.0.

We have a video covering some of the new features in the Report Designer.

Report Wizards

You can now customize the relationships between tables in a report without having to edit the SQL statement for the report.
You can now turn on the Show percentage of total option when you use the Count and Count Distinct summary types in Quick and Cross-Tab reports.
You can now use the Highest and Lowest summary types on all fields, not just numeric ones.
You can now create a filter condition that compares a field in one table to a field in another table by using an expression condition.
Creating a formula by clicking the Formula button in Step 2 of the report wizards now automatically adds the new formula to the report.
The list displayed when you click the Values button in Step 2 of the report wizards or the Expression Builder now displays two columns of information for certain fields: the value displayed in reports and the actual value stored in the database.
If Stonefield Query closed due to a problem and you were in the middle of editing a report in a report wizard, the next time you start the program, it prompts if you want to recover and continue editing that report. Choosing No abandons the recovered report so the changes are lost.
You now have finer control over the placement of a report's filter in a custom SQL statement.

Quick Reports

You can now group on a field even if the Display this field in the report option is turned off. This is useful, for example, if you want to group on customer ID but display customer name in the group header.
You can now create bookmarks on fields that are included in the group header of another field.
You now get a warning in the Field Properties dialog if you turn on the Include this field in group header for option and select a grouped field in a different table than the current field.

Charts

New options in the Chart Wizard allow you to stack series in area, bar, and column charts and combine smaller slices into one "other" slice in pie charts.
You can now specify whether a chart added to a quick or cross-tab report appears at the top or bottom of the report using the new Position on report option.
The Total type option in the Field Properties dialog for the Chart Wizard has a new Count Distinct setting.
The Summary report option in Step 4 of the Chart Wizard has been removed. Instead, set Total type in the Field Properties dialog to None, meaning you want individual values plotted rather than summarized values.
The Multi-line option in the Labels page of Step 4 in the Chart Wizard is no longer available for Windows XP since that option is only supported in Windows Vista and later versions.
You now receive a warning if you create a quick or cross-tab report, add a chart to it, then remove one or more of the fields used in the chart.
Outputting a chart report to an image (such as GIF) now outputs just the chart, not an entire page with the template.

Cross-Tab Reports

You can now specify how a date field used in the row of a cross-tab report is formatted: as a date, hour, week, month, quarter, or year.
You can now specify the width and what to do if the width is too narrow in row and data fields in the Cross Tab Wizard.
The Field Properties dialog now has a Suppress repeating values option for row fields. If this option is turned on (which it is by default) and several records in a row have the same value in this field, only the first occurrence is printed; the field in subsequent records appears blank.
A new _TOTAL value is True only for the grand totals line in a cross-tab report, so you can use that in, for example, the Print When expression of an object in a template to output that object only for the totals line. Similarly, _SUBTOTAL can be used to output an object only in a subtotals line.

Preview and Output

A new file output type is available: Microsoft Excel PivotTable. This type, which is only available for cross-tab reports, creates an Excel PivotTable formatted the same as the cross-tab report, but you can use Excel to change or pivot the report as necessary.
You can now output cross-tabulation and advanced layout reports to more file types, including Microsoft Excel data-only and delimited.
The Embed fonts in the file option on the Output page allows you to embed the fonts used in the report, such as a barcode font, in a PDF file.
The Preview window now supports the same types of output types as the Output page of the Reports Explorer.
When you run a report, the Reports Explorer and any open report wizard windows become dim and a progress window appears, showing you the progress of the report process and allowing you to cancel the process before it finishes. You can turn this off if you wish by turning off the Display progress during report runs setting in the Options dialog.

Advanced Report Designer

Several of the object property dialogs in the Advanced Report Designer have some changes. The Rotation option no longer appears on the General page but on its own Rotation page because it now shows a sample of how the rotation will look. The properties dialogs for field, picture, rectangle, and line objects have a new Dynamics page that allows you to conditionally alter the appearance of the object. Because the conditions on the Dynamics page are more flexible than dynamic font and color settings, those two items have been removed from the Style page for field objects.
You can now use gradient colors for rectangles in the Advanced Report Designer, both for reports and templates. A couple of new sample templates, Gradient Template and Valencia Orange, show how these can be used to produce nice, professional effects in your reports.
If you use Windows Vista or later, you can now change the printer used for an advanced layout report in the Page Layout page of the Report Properties dialog (this option was previously and is still available for Windows XP and earlier).

Other Features

You can now use fields from tables involved in the report for exclusion conditions. This means you can create a report that, for example, shows all customer who bought something last year (using a filter condition of sales date is between January 1 and December 31 of last year) but didn't this year (using an exclude condition of sales date is between January 1 and December 31 of this year).
The performance of certain types of formulas was improved.
The Formulas dialog now has a Copy function to make it easier to create a formula similar to an existing one.
The Formula Editor now has a Data Provider option so you can select the data provider the tables in the Tables list are from.
The default name when you copy a report is now the existing report name with a "1" suffix; in previous versions, the default name was blank.
The login dialog now has a link to the Setup dialog. This is useful if you need to change something about the Stonefield Query setup before logging in.
You cannot schedule reports if you are running Stonefield Query on Windows Terminal Server or Citrix since those environments don't permit it.
The version number now displays in the Reports Explorer title bar so you can quickly see which version you are running.
You can now specify carbon copy (CC) addresses when sending emails.
If you're using Microsoft Outlook or some other MAPI email program, you can now enter the name of a distribution list in the To, CC, and BCC options to send the email to a group of people.
Importing several reports that use formulas at one time is now significantly faster than before.
Specifying "ALLOWDIALOGS" when running Stonefield Query from another application or the command line now causes a progress dialog to display as the report runs.
Diagnostic logging is now always performed. A file called Diagnostic.TXT is created in the Data subdirectory of the program folder and is overwritten every time you start Stonefield Query. This file is very useful for tracking down errors or performance issues, and previously was only created if a file named Log.TXT existed.
Stonefield Query now displays a message that it's retrieving news items while it does that task so you can see what's going on.
An option to control the "serialization" of retrieving activity data when using the ACT! 2005-2009 data provider was added to the Options screen.
The options screen now gives more informative messages about when changes made will take effect.

Stonefield Query for Sage Timberline Office 4.0

2010-07-28T09:49:00.003-06:00

We are pleased to announce the immediate release of Stonefield Query for Sage Timberline Office version 4.0. There are lots of new and improved features in version 4.0.

We have a video covering some of the new features in the Report Designer.

Report Wizards

You can now customize the relationships between tables in a report without having to edit the SQL statement for the report.
You can now turn on the Show percentage of total option when you use the Count and Count Distinct summary types in Quick and Cross-Tab reports.
You can now use the Highest and Lowest summary types on all fields, not just numeric ones.
You can now create a filter condition that compares a field in one table to a field in another table by using an expression condition.
Creating a formula by clicking the Formula button in Step 2 of the report wizards now automatically adds the new formula to the report.
The list displayed when you click the Values button in Step 2 of the report wizards or the Expression Builder now displays two columns of information for certain fields: the value displayed in reports and the actual value stored in the database.
If Stonefield Query closed due to a problem and you were in the middle of editing a report in a report wizard, the next time you start the program, it prompts if you want to recover and continue editing that report. Choosing No abandons the recovered report so the changes are lost.
You now have finer control over the placement of a report's filter in a custom SQL statement.

Quick Reports

You can now group on a field even if the Display this field in the report option is turned off. This is useful, for example, if you want to group on customer ID but display customer name in the group header.
You can now create bookmarks on fields that are included in the group header of another field.
You now get a warning in the Field Properties dialog if you turn on the Include this field in group header for option and select a grouped field in a different table than the current field.

Charts

New options in the Chart Wizard allow you to stack series in area, bar, and column charts and combine smaller slices into one "other" slice in pie charts.
You can now specify whether a chart added to a quick or cross-tab report appears at the top or bottom of the report using the new Position on report option.
The Total type option in the Field Properties dialog for the Chart Wizard has a new Count Distinct setting.
The Summary report option in Step 4 of the Chart Wizard has been removed. Instead, set Total type in the Field Properties dialog to None, meaning you want individual values plotted rather than summarized values.
The Multi-line option in the Labels page of Step 4 in the Chart Wizard is no longer available for Windows XP since that option is only supported in Windows Vista and later versions.
You now receive a warning if you create a quick or cross-tab report, add a chart to it, then remove one or more of the fields used in the chart.
Outputting a chart report to an image (such as GIF) now outputs just the chart, not an entire page with the template.

Cross-Tab Reports

You can now specify how a date field used in the row of a cross-tab report is formatted: as a date, hour, week, month, quarter, or year.
You can now specify the width and what to do if the width is too narrow in row and data fields in the Cross Tab Wizard.
The Field Properties dialog now has a Suppress repeating values option for row fields. If this option is turned on (which it is by default) and several records in a row have the same value in this field, only the first occurrence is printed; the field in subsequent records appears blank.
A new _TOTAL value is True only for the grand totals line in a cross-tab report, so you can use that in, for example, the Print When expression of an object in a template to output that object only for the totals line. Similarly, _SUBTOTAL can be used to output an object only in a subtotals line.

Preview and Output

A new file output type is available: Microsoft Excel PivotTable. This type, which is only available for cross-tab reports, creates an Excel PivotTable formatted the same as the cross-tab report, but you can use Excel to change or pivot the report as necessary.
You can now output cross-tabulation and advanced layout reports to more file types, including Microsoft Excel data-only and delimited.
The Embed fonts in the file option on the Output page allows you to embed the fonts used in the report, such as a barcode font, in a PDF file.
The Preview window now supports the same types of output types as the Output page of the Reports Explorer.
When you run a report, the Reports Explorer and any open report wizard windows become dim and a progress window appears, showing you the progress of the report process and allowing you to cancel the process before it finishes. You can turn this off if you wish by turning off the Display progress during report runs setting in the Options dialog.
You can now configure Stonefield Query to retrieve records from the database in batches (also known as asynchronously). This gives you the ability to stop a long-running report while records are retrieved rather than having to wait a long time for retrieval to be complete.

Advanced Report Designer

Several of the object property dialogs in the Advanced Report Designer have some changes. The Rotation option no longer appears on the General page but on its own Rotation page because it now shows a sample of how the rotation will look. The properties dialogs for field, picture, rectangle, and line objects have a new Dynamics page that allows you to conditionally alter the appearance of the object. Because the conditions on the Dynamics page are more flexible than dynamic font and color settings, those two items have been removed from the Style page for field objects.
You can now use gradient colors for rectangles in the Advanced Report Designer, both for reports and templates. A couple of new sample templates, Gradient Template and Valencia Orange, show how these can be used to produce nice, professional effects in your reports.
If you use Windows Vista or later, you can now change the printer used for an advanced layout report in the Page Layout page of the Report Properties dialog (this option was previously and is still available for Windows XP and earlier).

Other Features

Stonefield Query for Sage Timberline Office supports Sage Timberline Office 9.7.
You can now use fields from tables involved in the report for exclusion conditions. This means you can create a report that, for example, shows all customer who bought something last year (using a filter condition of sales date is between January 1 and December 31 of last year) but didn't this year (using an exclude condition of sales date is between January 1 and December 31 of this year).
The performance of certain types of formulas was improved.
The Formulas dialog now has a Copy function to make it easier to create a formula similar to an existing one.
The Formula Editor now has a Data group option so you can select the data group the tables in the Tables list are from.
The default name when you copy a report is now the existing report name with a "1" suffix; in previous versions, the default name was blank.
The login dialog now has a link to the Setup dialog. This is useful if you need to change something about the Stonefield Query setup before logging in.
You cannot schedule reports if you are running Stonefield Query on Windows Terminal Server or Citrix since those environments don't permit it.
The version number now displays in the Reports Explorer title bar so you can quickly see which version you are running.
You can now specify carbon copy (CC) addresses when sending emails.
If you're using Microsoft Outlook or some other MAPI email program, you can now enter the name of a distribution list in the To, CC, and BCC options to send the email to a group of people.
Importing several reports that use formulas at one time is now significantly faster than before.
Specifying "ALLOWDIALOGS" when running Stonefield Query from another application or the command line now causes a progress dialog to display as the report runs.
Diagnostic logging is now always performed. A file called Diagnostic.TXT is created in the Data subdirectory of the program folder and is overwritten every time you start Stonefield Query. This file is very useful for tracking down errors or performance issues, and previously was only created if a file named Log.TXT existed.
Stonefield Query now displays a message that it's retrieving news items while it does that task so you can see what's going on.

Stonefield Query for AccountMate 4.0

2010-07-28T09:35:00.003-06:00

We are pleased to announce the immediate release of Stonefield Query for AccountMate version 4.0. This release includes both Stonefield Query for AccountMate SQL and Stonefield Query for AccountMate LAN. There are lots of new and improved features in version 4.0.

We have a video covering some of the new features in the Report Designer.

Report Wizards

You can now customize the relationships between tables in a report without having to edit the SQL statement for the report.
You can now turn on the Show percentage of total option when you use the Count and Count Distinct summary types in Quick and Cross-Tab reports.
You can now use the Highest and Lowest summary types on all fields, not just numeric ones.
You can now create a filter condition that compares a field in one table to a field in another table by using an expression condition.
Creating a formula by clicking the Formula button in Step 2 of the report wizards now automatically adds the new formula to the report.
The list displayed when you click the Values button in Step 2 of the report wizards or the Expression Builder now displays two columns of information for certain fields: the value displayed in reports and the actual value stored in the database.
If Stonefield Query closed due to a problem and you were in the middle of editing a report in a report wizard, the next time you start the program, it prompts if you want to recover and continue editing that report. Choosing No abandons the recovered report so the changes are lost.
You now have finer control over the placement of a report's filter in a custom SQL statement.

Quick Reports

You can now group on a field even if the Display this field in the report option is turned off. This is useful, for example, if you want to group on customer ID but display customer name in the group header.
You can now create bookmarks on fields that are included in the group header of another field.
You now get a warning in the Field Properties dialog if you turn on the Include this field in group header for option and select a grouped field in a different table than the current field.

Charts

New options in the Chart Wizard allow you to stack series in area, bar, and column charts and combine smaller slices into one "other" slice in pie charts.
You can now specify whether a chart added to a quick or cross-tab report appears at the top or bottom of the report using the new Position on report option.
The Total type option in the Field Properties dialog for the Chart Wizard has a new Count Distinct setting.
The Summary report option in Step 4 of the Chart Wizard has been removed. Instead, set Total type in the Field Properties dialog to None, meaning you want individual values plotted rather than summarized values.
The Multi-line option in the Labels page of Step 4 in the Chart Wizard is no longer available for Windows XP since that option is only supported in Windows Vista and later versions.
You now receive a warning if you create a quick or cross-tab report, add a chart to it, then remove one or more of the fields used in the chart.
Outputting a chart report to an image (such as GIF) now outputs just the chart, not an entire page with the template.

Cross-Tab Reports

You can now specify how a date field used in the row of a cross-tab report is formatted: as a date, hour, week, month, quarter, or year.
You can now specify the width and what to do if the width is too narrow in row and data fields in the Cross Tab Wizard.
The Field Properties dialog now has a Suppress repeating values option for row fields. If this option is turned on (which it is by default) and several records in a row have the same value in this field, only the first occurrence is printed; the field in subsequent records appears blank.
A new _TOTAL value is True only for the grand totals line in a cross-tab report, so you can use that in, for example, the Print When expression of an object in a template to output that object only for the totals line. Similarly, _SUBTOTAL can be used to output an object only in a subtotals line.

Preview and Output

A new file output type is available: Microsoft Excel PivotTable. This type, which is only available for cross-tab reports, creates an Excel PivotTable formatted the same as the cross-tab report, but you can use Excel to change or pivot the report as necessary.
You can now output cross-tabulation and advanced layout reports to more file types, including Microsoft Excel data-only and delimited.
The Embed fonts in the file option on the Output page allows you to embed the fonts used in the report, such as a barcode font, in a PDF file.
The Preview window now supports the same types of output types as the Output page of the Reports Explorer.
When you run a report, the Reports Explorer and any open report wizard windows become dim and a progress window appears, showing you the progress of the report process and allowing you to cancel the process before it finishes. You can turn this off if you wish by turning off the Display progress during report runs setting in the Options dialog.
You can now configure Stonefield Query to retrieve records from the database in batches (also known as asynchronously). This gives you the ability to stop a long-running report while records are retrieved rather than having to wait a long time for retrieval to be complete.

Advanced Report Designer

Several of the object property dialogs in the Advanced Report Designer have some changes. The Rotation option no longer appears on the General page but on its own Rotation page because it now shows a sample of how the rotation will look. The properties dialogs for field, picture, rectangle, and line objects have a new Dynamics page that allows you to conditionally alter the appearance of the object. Because the conditions on the Dynamics page are more flexible than dynamic font and color settings, those two items have been removed from the Style page for field objects.
You can now use gradient colors for rectangles in the Advanced Report Designer, both for reports and templates. A couple of new sample templates, Gradient Template and Valencia Orange, show how these can be used to produce nice, professional effects in your reports.
If you use Windows Vista or later, you can now change the printer used for an advanced layout report in the Page Layout page of the Report Properties dialog (this option was previously and is still available for Windows XP and earlier).

Other Features

Stonefield Query for AccountMate SQL has added support for new tables and fields added in AccountMate SQL 8.1.
You can now use fields from tables involved in the report for exclusion conditions. This means you can create a report that, for example, shows all customer who bought something last year (using a filter condition of sales date is between January 1 and December 31 of last year) but didn't this year (using an exclude condition of sales date is between January 1 and December 31 of this year).
The performance of certain types of formulas was improved.
The Formulas dialog now has a Copy function to make it easier to create a formula similar to an existing one.
The Formula Editor now has a Data group option so you can select the data group the tables in the Tables list are from.
The default name when you copy a report is now the existing report name with a "1" suffix; in previous versions, the default name was blank.
The login dialog now has a link to the Setup dialog. This is useful if you need to change something about the Stonefield Query setup before logging in.
You cannot schedule reports if you are running Stonefield Query on Windows Terminal Server or Citrix since those environments don't permit it.
The version number now displays in the Reports Explorer title bar so you can quickly see which version you are running.
You can now specify carbon copy (CC) addresses when sending emails.
If you're using Microsoft Outlook or some other MAPI email program, you can now enter the name of a distribution list in the To, CC, and BCC options to send the email to a group of people.
Importing several reports that use formulas at one time is now significantly faster than before.
Specifying "ALLOWDIALOGS" when running Stonefield Query from another application or the command line now causes a progress dialog to display as the report runs.
Diagnostic logging is now always performed. A file called Diagnostic.TXT is created in the Data subdirectory of the program folder and is overwritten every time you start Stonefield Query. This file is very useful for tracking down errors or performance issues, and previously was only created if a file named Log.TXT existed.
Stonefield Query now displays a message that it's retrieving news items while it does that task so you can see what's going on.

Stonefield Query for SageCRM 4.0

2010-07-27T12:05:00.000-06:00

We are pleased to announce the immediate release of Stonefield Query for SageCRM version 4.0. There are lots of new and improved features in version 4.0.

We have a video covering some of the new features in the Report Designer.

Report Wizards

You can now customize the relationships between tables in a report without having to edit the SQL statement for the report.
You can now turn on the Show percentage of total option when you use the Count and Count Distinct summary types in Quick and Cross-Tab reports.
You can now use the Highest and Lowest summary types on all fields, not just numeric ones.
You can now create a filter condition that compares a field in one table to a field in another table by using an expression condition.
Creating a formula by clicking the Formula button in Step 2 of the report wizards now automatically adds the new formula to the report.
The list displayed when you click the Values button in Step 2 of the report wizards or the Expression Builder now displays two columns of information for certain fields: the value displayed in reports and the actual value stored in the database.
If Stonefield Query closed due to a problem and you were in the middle of editing a report in a report wizard, the next time you start the program, it prompts if you want to recover and continue editing that report. Choosing No abandons the recovered report so the changes are lost.
You now have finer control over the placement of a report's filter in a custom SQL statement.

Quick Reports

You can now group on a field even if the Display this field in the report option is turned off. This is useful, for example, if you want to group on customer ID but display customer name in the group header.
You can now create bookmarks on fields that are included in the group header of another field.
You now get a warning in the Field Properties dialog if you turn on the Include this field in group header for option and select a grouped field in a different table than the current field.

Charts

New options in the Chart Wizard allow you to stack series in area, bar, and column charts and combine smaller slices into one "other" slice in pie charts.
You can now specify whether a chart added to a quick or cross-tab report appears at the top or bottom of the report using the new Position on report option.
The Total type option in the Field Properties dialog for the Chart Wizard has a new Count Distinct setting.
The Summary report option in Step 4 of the Chart Wizard has been removed. Instead, set Total type in the Field Properties dialog to None, meaning you want individual values plotted rather than summarized values.
The Multi-line option in the Labels page of Step 4 in the Chart Wizard is no longer available for Windows XP since that option is only supported in Windows Vista and later versions.
You now receive a warning if you create a quick or cross-tab report, add a chart to it, then remove one or more of the fields used in the chart.
Outputting a chart report to an image (such as GIF) now outputs just the chart, not an entire page with the template.

Cross-Tab Reports

You can now specify how a date field used in the row of a cross-tab report is formatted: as a date, hour, week, month, quarter, or year.
You can now specify the width and what to do if the width is too narrow in row and data fields in the Cross Tab Wizard.
The Field Properties dialog now has a Suppress repeating values option for row fields. If this option is turned on (which it is by default) and several records in a row have the same value in this field, only the first occurrence is printed; the field in subsequent records appears blank.
A new _TOTAL value is True only for the grand totals line in a cross-tab report, so you can use that in, for example, the Print When expression of an object in a template to output that object only for the totals line. Similarly, _SUBTOTAL can be used to output an object only in a subtotals line.

Preview and Output

A new file output type is available: Microsoft Excel PivotTable. This type, which is only available for cross-tab reports, creates an Excel PivotTable formatted the same as the cross-tab report, but you can use Excel to change or pivot the report as necessary.
You can now output cross-tabulation and advanced layout reports to more file types, including Microsoft Excel data-only and delimited.
The Embed fonts in the file option on the Output page allows you to embed the fonts used in the report, such as a barcode font, in a PDF file.
The Preview window now supports the same types of output types as the Output page of the Reports Explorer.
When you run a report, the Reports Explorer and any open report wizard windows become dim and a progress window appears, showing you the progress of the report process and allowing you to cancel the process before it finishes. You can turn this off if you wish by turning off the Display progress during report runs setting in the Options dialog.
You can now configure Stonefield Query to retrieve records from the database in batches (also known as asynchronously). This gives you the ability to stop a long-running report while records are retrieved rather than having to wait a long time for retrieval to be complete.

Advanced Report Designer

Several of the object property dialogs in the Advanced Report Designer have some changes. The Rotation option no longer appears on the General page but on its own Rotation page because it now shows a sample of how the rotation will look. The properties dialogs for field, picture, rectangle, and line objects have a new Dynamics page that allows you to conditionally alter the appearance of the object. Because the conditions on the Dynamics page are more flexible than dynamic font and color settings, those two items have been removed from the Style page for field objects.
You can now use gradient colors for rectangles in the Advanced Report Designer, both for reports and templates. A couple of new sample templates, Gradient Template and Valencia Orange, show how these can be used to produce nice, professional effects in your reports.
If you use Windows Vista or later, you can now change the printer used for an advanced layout report in the Page Layout page of the Report Properties dialog (this option was previously and is still available for Windows XP and earlier).

Other Features

Stonefield Query for SageCRM now has enhanced support for the following custom SageCRM Field (Entry) Types: Multi-select, Date Only, Currency, Search Select Advanced, Currency Symbols, Check Box, Multiline text, Selection, User Select, Team Select, Numeric, Date & Time
You can now use fields from tables involved in the report for exclusion conditions. This means you can create a report that, for example, shows all customer who bought something last year (using a filter condition of sales date is between January 1 and December 31 of last year) but didn't this year (using an exclude condition of sales date is between January 1 and December 31 of this year).
The performance of certain types of formulas was improved.
The Formulas dialog now has a Copy function to make it easier to create a formula similar to an existing one.
The Formula Editor now has a Data group option so you can select the data group the tables in the Tables list are from.
The default name when you copy a report is now the existing report name with a "1" suffix; in previous versions, the default name was blank.
The login dialog now has a link to the Setup dialog. This is useful if you need to change something about the Stonefield Query setup before logging in.
You cannot schedule reports if you are running Stonefield Query on Windows Terminal Server or Citrix since those environments don't permit it.
The version number now displays in the Reports Explorer title bar so you can quickly see which version you are running.
You can now specify carbon copy (CC) addresses when sending emails.
If you're using Microsoft Outlook or some other MAPI email program, you can now enter the name of a distribution list in the To, CC, and BCC options to send the email to a group of people.
Importing several reports that use formulas at one time is now significantly faster than before.
Specifying "ALLOWDIALOGS" when running Stonefield Query from another application or the command line now causes a progress dialog to display as the report runs.
Diagnostic logging is now always performed. A file called Diagnostic.TXT is created in the Data subdirectory of the program folder and is overwritten every time you start Stonefield Query. This file is very useful for tracking down errors or performance issues, and previously was only created if a file named Log.TXT existed.
On 64-bit systems, the Manage Databases dialog brings up the 32-bit ODBC Administrator when you click the ODBC Admin button since Stonefield Query needs to work with 32-bit DSNs.
Stonefield Query now displays a message that it's retrieving news items while it does that task so you can see what's going on.

Stonefield Query for Sage Accpac ERP 4.0

2010-07-13T14:03:00.001-06:00

We are pleased to announce the immediate release of Stonefield Query for Sage Accpac ERP version 4.0. There are lots of new and improved features in version 4.0.

We have a video covering some of the new features in the Report Designer.

Report Wizards

You can now customize the relationships between tables in a report without having to edit the SQL statement for the report.
Support for Database View versus Application View in Step 2 of the report wizards. The difference between the two is that Database View displays a database-centric view of the data in your application--that is, organized the way the tables and fields are in the database--while Application View shows fields the way your application does in its various dialogs. Database View is useful if you are familiar with the structure of your application's database while Application View is better suited to those familiar with the user interface of the application
You can now turn on the Show percentage of total option when you use the Count and Count Distinct summary types in Quick and Cross-Tab reports.
You can now use the Highest and Lowest summary types on all fields, not just numeric ones.
You can now create a filter condition that compares a field in one table to a field in another table by using an expression condition.
Creating a formula by clicking the Formula button in Step 2 of the report wizards now automatically adds the new formula to the report.
The list displayed when you click the Values button in Step 2 of the report wizards or the Expression Builder now displays two columns of information for certain fields: the value displayed in reports and the actual value stored in the database.
If Stonefield Query closed due to a problem and you were in the middle of editing a report in a report wizard, the next time you start the program, it prompts if you want to recover and continue editing that report. Choosing No abandons the recovered report so the changes are lost.
You now have finer control over the placement of a report's filter in a custom SQL statement.

Quick Reports

You can now group on a field even if the Display this field in the report option is turned off. This is useful, for example, if you want to group on customer ID but display customer name in the group header.
You can now create bookmarks on fields that are included in the group header of another field.
You now get a warning in the Field Properties dialog if you turn on the Include this field in group header for option and select a grouped field in a different table than the current field.

Charts

New options in the Chart Wizard allow you to stack series in area, bar, and column charts and combine smaller slices into one "other" slice in pie charts.
You can now specify whether a chart added to a quick or cross-tab report appears at the top or bottom of the report using the new Position on report option.
The Total type option in the Field Properties dialog for the Chart Wizard has a new Count Distinct setting.
The Summary report option in Step 4 of the Chart Wizard has been removed. Instead, set Total type in the Field Properties dialog to None, meaning you want individual values plotted rather than summarized values.
The Multi-line option in the Labels page of Step 4 in the Chart Wizard is no longer available for Windows XP since that option is only supported in Windows Vista and later versions.
You now receive a warning if you create a quick or cross-tab report, add a chart to it, then remove one or more of the fields used in the chart.
Outputting a chart report to an image (such as GIF) now outputs just the chart, not an entire page with the template.

Cross-Tab Reports

You can now specify how a date field used in the row of a cross-tab report is formatted: as a date, hour, week, month, quarter, or year.
You can now specify the width and what to do if the width is too narrow in row and data fields in the Cross Tab Wizard.
The Field Properties dialog now has a Suppress repeating values option for row fields. If this option is turned on (which it is by default) and several records in a row have the same value in this field, only the first occurrence is printed; the field in subsequent records appears blank.
A new _TOTAL value is True only for the grand totals line in a cross-tab report, so you can use that in, for example, the Print When expression of an object in a template to output that object only for the totals line. Similarly, _SUBTOTAL can be used to output an object only in a subtotals line.

Preview and Output

A new file output type is available: Microsoft Excel PivotTable. This type, which is only available for cross-tab reports, creates an Excel PivotTable formatted the same as the cross-tab report, but you can use Excel to change or pivot the report as necessary.
You can now output cross-tabulation and advanced layout reports to more file types, including Microsoft Excel data-only and delimited.
The Embed fonts in the file option on the Output page allows you to embed the fonts used in the report, such as a barcode font, in a PDF file.
The Preview window now supports the same types of output types as the Output page of the Reports Explorer.
When you run a report, the Reports Explorer and any open report wizard windows become dim and a progress window appears, showing you the progress of the report process and allowing you to cancel the process before it finishes. You can turn this off if you wish by turning off the Display progress during report runs setting in the Options dialog.
You can now configure Stonefield Query to retrieve records from the database in batches (also known as asynchronously). This gives you the ability to stop a long-running report while records are retrieved rather than having to wait a long time for retrieval to be complete.

Advanced Report Designer

Several of the object property dialogs in the Advanced Report Designer have some changes. The Rotation option no longer appears on the General page but on its own Rotation page because it now shows a sample of how the rotation will look. The properties dialogs for field, picture, rectangle, and line objects have a new Dynamics page that allows you to conditionally alter the appearance of the object. Because the conditions on the Dynamics page are more flexible than dynamic font and color settings, those two items have been removed from the Style page for field objects.
You can now use gradient colors for rectangles in the Advanced Report Designer, both for reports and templates. A couple of new sample templates, Gradient Template and Valencia Orange, show how these can be used to produce nice, professional effects in your reports.
If you use Windows Vista or later, you can now change the printer used for an advanced layout report in the Page Layout page of the Report Properties dialog (this option was previously and is still available for Windows XP and earlier).

Other Features

The performance of some types of reports has been improved. This specifically applies to those where you're reporting on two or more tables, one of which has relatively few records and one that has a lot, and you're filtering on the few-records table but not the many-records one (e.g. customers and invoices with a filter on customers).
If you know you won't need access to Accpac optional fields, you can make Stonefield Query start up faster by adding a line with "CustomMeta=N" to the [Meta Data] section of SFQuery.INI.
The Item Pricing (ICPRIC) and Price List Codes (ICPCOD) tables now also appear in the UniSales module. Also, a relationship now exists between Added Item Pricing (ICPRIC) and Sales Analysis Details (UXDETAIL).
The caption for OEORDD was changed to Sales Order Details, the caption for OEORDH was changed to Sales Orders (Part 1), and the caption for OECOINO was changed to Sales Order Comments/Instructions.
The caption for ICITEM.FMTITEMNO was changed to Item Number (Formatted).
You can now use fields from tables involved in the report for exclusion conditions. This means you can create a report that, for example, shows all customer who bought something last year (using a filter condition of sales date is between January 1 and December 31 of last year) but didn't this year (using an exclude condition of sales date is between January 1 and December 31 of this year).
The performance of certain types of formulas was improved.
The Formulas dialog now has a Copy function to make it easier to create a formula similar to an existing one.
The Formula Editor now has a Data group option so you can select the data group the tables in the Tables list are from.
The default name when you copy a report is now the existing report name with a "1" suffix; in previous versions, the default name was blank.
The login dialog now has a link to the Setup dialog. This is useful if you need to change something about the Stonefield Query setup before logging in.
You cannot schedule reports if you are running Stonefield Query on Windows Terminal Server or Citrix since those environments don't permit it.
The version number now displays in the Reports Explorer title bar so you can quickly see which version you are running.
You can now specify carbon copy (CC) addresses when sending emails.
If you're using Microsoft Outlook or some other MAPI email program, you can now enter the name of a distribution list in the To, CC, and BCC options to send the email to a group of people.
Importing several reports that use formulas at one time is now significantly faster than before.
Specifying "ALLOWDIALOGS" when running Stonefield Query from another application or the command line now causes a progress dialog to display as the report runs.
Diagnostic logging is now always performed. A file called Diagnostic.TXT is created in the Data subdirectory of the program folder and is overwritten every time you start Stonefield Query. This file is very useful for tracking down errors or performance issues, and previously was only created if a file named Log.TXT existed.
Stonefield Query now displays a message that it's retrieving news items while it does that task so you can see what's going on.

Stonefield Query SDK 4.0

2010-07-13T13:30:00.001-06:00

We are pleased to announce the immediate release of the Stonefield Query SDK version 4.0. There are lots of new and improved features in version 4.0.

We have videos covering the new features in the SDK and in the Report Designer.

SDK

The most obvious change in the Stonefield Query SDK is that the Configuration Utility has been replaced by Stonefield Query Studio, which has a more modern user interface and much more functionality than the Configuration Utility had. Among the improvements are hyperlinks between related items, such as hyperlinks from a relation to the tables and fields involved in the relation, a Back button that takes you back to the item you were working with last, and organization of scripts by script type.
Stonefield Query 4.0 adds application views, a way you can display the data organization of your application to match the data entry screens the user sees in the application rather than a database-centric list of tables and fields. Programmatically, they're represented by new AppView and AppViewField objects, and AppViews and AppViewFields collections.
The Query Data Dictionary function allows you to view the raw records in the data dictionary for a project and make bulk changes if necessary.
Creating a new Stonefield Query project is much easier using the New Project Wizard.
The new Test All Relations function tests all relations in the data dictionary and displays a dialog showing any that did not succeed, making it much faster to look for problems than testing one relation at a time.
General fields can now be made reportable since you may want to use them for images in reports.
The Project Documentation function was removed since it was never used and required some major updates to support version 4.0.
Multiple relations between the same pair of tables is now supported if they have different version numbers.
The Test button on the relation properties page now displays a dialog with possible reasons why the relation test failed.
You now get a warning if a table was previously located in one database but now appears in a different database when you refresh the data dictionary.
You can now press Esc to cancel generating help files, and have the option to not generate screen shots.
The new Tag for News Feed configuration setting allows you to configure which topics the news reader displays initially.
Stonefield Query now supports Interbase databases better.
After generating help files, Stonefield Query Studio now prompts if you want to open the West Wind HTML Help Builder project. Choose No if you don't have West Wind HTML Help Builder installed or don't want to open the project at this time.
Both the Generate Setup function and Stonefield Query now also look for a custom CHM file in the project HTMLHelp folder so there's no need to copy that file to the project folder.
The new PrintReport and PreviewReport methods of the ReportEngine object allow you to print and preview reports from the SQProxy object.
The ODBCDataSource object now has a ConnectionString property.
The Database object no longer has a Description property since it wasn't used for anything.
The Advance property of the Report object was renamed to Advanced.
The Report object has new CCRecipients, CustomJoins, and Snapshot properties.
You can now return False from ReportEngine.SetReportProperties to make the selected report unavailable to the current user.
You can now return False from ReportEngine.BeforeRunReport to prevent the report from running.
The new DataEngine.BeforeSendSQLStatementToDatabase script allows customizing the SQL statement for a report, similar to DataEngine.FinalizeSQLStatement, but based on the current datasource if necessary (e.g. adding WHERE clause using something from current data source) when doing multi-datasource query.
You can now make programmatic changes to the fields in a report, such as adding fields, before it runs in the ReportEngine.BeforeRunReport script.

Report Wizards

You can now customize the relationships between tables in a report without having to edit the SQL statement for the report.
Support for Database View versus Application View in Step 2 of the report wizards. The difference between the two is that Database View displays a database-centric view of the data in your application--that is, organized the way the tables and fields are in the database--while Application View shows fields the way your application does in its various dialogs. Database View is useful if you are familiar with the structure of your application's database while Application View is better suited to those familiar with the user interface of the application
You can now turn on the Show percentage of total option when you use the Count and Count Distinct summary types in Quick and Cross-Tab reports.
You can now use the Highest and Lowest summary types on all fields, not just numeric ones.
You can now create a filter condition that compares a field in one table to a field in another table by using an expression condition.
Creating a formula by clicking the Formula button in Step 2 of the report wizards now automatically adds the new formula to the report.
The list displayed when you click the Values button in Step 2 of the report wizards or the Expression Builder now displays two columns of information for certain fields: the value displayed in reports and the actual value stored in the database.
If Stonefield Query closed due to a problem and you were in the middle of editing a report in a report wizard, the next time you start the program, it prompts if you want to recover and continue editing that report. Choosing No abandons the recovered report so the changes are lost.
You now have finer control over the placement of a report's filter in a custom SQL statement.

Quick Reports

You can now group on a field even if the Display this field in the report option is turned off. This is useful, for example, if you want to group on customer ID but display customer name in the group header.
You can now create bookmarks on fields that are included in the group header of another field.
You now get a warning in the Field Properties dialog if you turn on the Include this field in group header for option and select a grouped field in a different table than the current field.

Charts

New options in the Chart Wizard allow you to stack series in area, bar, and column charts and combine smaller slices into one "other" slice in pie charts.
You can now specify whether a chart added to a quick or cross-tab report appears at the top or bottom of the report using the new Position on report option.
The Total type option in the Field Properties dialog for the Chart Wizard has a new Count Distinct setting.
The Summary report option in Step 4 of the Chart Wizard has been removed. Instead, set Total type in the Field Properties dialog to None, meaning you want individual values plotted rather than summarized values.
The Multi-line option in the Labels page of Step 4 in the Chart Wizard is no longer available for Windows XP since that option is only supported in Windows Vista and later versions.
You now receive a warning if you create a quick or cross-tab report, add a chart to it, then remove one or more of the fields used in the chart.
Outputting a chart report to an image (such as GIF) now outputs just the chart, not an entire page with the template.

Cross-Tab Reports

You can now specify how a date field used in the row of a cross-tab report is formatted: as a date, hour, week, month, quarter, or year.
You can now specify the width and what to do if the width is too narrow in row and data fields in the Cross Tab Wizard.
The Field Properties dialog now has a Suppress repeating values option for row fields. If this option is turned on (which it is by default) and several records in a row have the same value in this field, only the first occurrence is printed; the field in subsequent records appears blank.
A new _TOTAL value is True only for the grand totals line in a cross-tab report, so you can use that in, for example, the Print When expression of an object in a template to output that object only for the totals line. Similarly, _SUBTOTAL can be used to output an object only in a subtotals line.

Preview and Output

A new file output type is available: Microsoft Excel PivotTable. This type, which is only available for cross-tab reports, creates an Excel PivotTable formatted the same as the cross-tab report, but you can use Excel to change or pivot the report as necessary.
You can now output cross-tabulation and advanced layout reports to more file types, including Microsoft Excel data-only and delimited.
The Embed fonts in the file option on the Output page allows you to embed the fonts used in the report, such as a barcode font, in a PDF file.
The Preview window now supports the same types of output types as the Output page of the Reports Explorer.
When you run a report, the Reports Explorer and any open report wizard windows become dim and a progress window appears, showing you the progress of the report process and allowing you to cancel the process before it finishes. You can turn this off if you wish by turning off the Display progress during report runs setting in the Options dialog.
You can now configure Stonefield Query to retrieve records from the database in batches (also known as asynchronously). This gives you the ability to stop a long-running report while records are retrieved rather than having to wait a long time for retrieval to be complete.

Advanced Report Designer

Several of the object property dialogs in the Advanced Report Designer have some changes. The Rotation option no longer appears on the General page but on its own Rotation page because it now shows a sample of how the rotation will look. The properties dialogs for field, picture, rectangle, and line objects have a new Dynamics page that allows you to conditionally alter the appearance of the object. Because the conditions on the Dynamics page are more flexible than dynamic font and color settings, those two items have been removed from the Style page for field objects.
You can now use gradient colors for rectangles in the Advanced Report Designer, both for reports and templates. A couple of new sample templates, Gradient Template and Valencia Orange, show how these can be used to produce nice, professional effects in your reports.
If you use Windows Vista or later, you can now change the printer used for an advanced layout report in the Page Layout page of the Report Properties dialog (this option was previously and is still available for Windows XP and earlier).

Other Features

You can now use fields from tables involved in the report for exclusion conditions. This means you can create a report that, for example, shows all customer who bought something last year (using a filter condition of sales date is between January 1 and December 31 of last year) but didn't this year (using an exclude condition of sales date is between January 1 and December 31 of this year).
The performance of certain types of formulas was improved.
The Formulas dialog now has a Copy function to make it easier to create a formula similar to an existing one.
The Formula Editor now has a Data group option so you can select the data group the tables in the Tables list are from.
The default name when you copy a report is now the existing report name with a "1" suffix; in previous versions, the default name was blank.
The login dialog now has a link to the Setup dialog. This is useful if you need to change something about the Stonefield Query setup before logging in.
You cannot schedule reports if you are running Stonefield Query on Windows Terminal Server or Citrix since those environments don't permit it.
The version number now displays in the Reports Explorer title bar so you can quickly see which version you are running.
You can now specify carbon copy (CC) addresses when sending emails.
If you're using Microsoft Outlook or some other MAPI email program, you can now enter the name of a distribution list in the To, CC, and BCC options to send the email to a group of people.
Importing several reports that use formulas at one time is now significantly faster than before.
Specifying "ALLOWDIALOGS" when running Stonefield Query from another application or the command line now causes a progress dialog to display as the report runs.
Diagnostic logging is now always performed. A file called Diagnostic.TXT is created in the Data subdirectory of the program folder and is overwritten every time you start Stonefield Query. This file is very useful for tracking down errors or performance issues, and previously was only created if a file named Log.TXT existed.
Stonefield Query now displays a message that it's retrieving news items while it does that task so you can see what's going on.

Stonefield Query for ALERE 3.3 Build 3792

2010-06-08T08:34:00.001-06:00

We released an update to Stonefield Query for ALERE version 3.3 today. This new release adds support for ALERE version 6.6 databases. For a list of other new features in this version please see our Online Help File.

Article on Sage Software

2010-04-30T11:26:00.001-06:00

Software Advice has an article discussing the features of some of Sage’s ERP offerings in the manufacturing and distribution software industries, specifically MAS, X3, Pro, and PFW. Although they missed discussing Accpac, it’s still a good overview of the products it does cover.

Stonefield Query for Sage Accpac ERP Version 3.3 Build 3756

2010-04-14T12:51:00.001-06:00

We released an update to Stonefield Query for Sage Accpac ERP version 3.3 today. It has the following new features:

The performance of optional fields containing character values was dramatically improved. For example, a report that used optional fields extensively used to take 2.5 hours to run but now takes 2.5 seconds!
You can now report on the Inventory Control Units of Measure table.
The relationships for the Order Entry Comments/Instructions tables (for example, Invoice Comments/Instructions) were changed so records from the other table appear regardless of whether there are Comments/Instructions records or not (in technical terms, they now use an outer join). Also, there's now a relationship between Cred. Note Comments/Instructions and Combined Invoice & Credit Note Details.
A relationship was added between Order Entry Posting Journals - Details and Sales History Details.
UniSales budget fields are handled better.
The Field Properties dialog now has a Suppress repeating values option for row fields. If this option is turned on (which it is by default) and several records in a row have the same value in this field, only the first occurrence is printed; the field in subsequent records appears blank.
Fields with drop-down lists in the Filter Condition dialog now have a blank value as an option. This allows you to blank previously entered values.

Stonefield Query for SageCRM Version 3.3 Build 3713

2010-03-23T14:43:00.000-06:00

We released an update to Stonefield Query for SageCRM version 3.3 today. This update adds support for SageCRM version 7.0.

Stonefield Query for Sage Accpac ERP Version 3.3 Build 3713

2010-03-04T16:18:00.001-06:00

We released an update to Stonefield Query for Sage Accpac ERP version 3.3 today. It has the following new features:

There are now relationships between the Order Entry Sales History Details table and the Credit/Debit Notes, Invoices, and Combined Invoices & Credit Notes tables, and the Accounts Receivable Document Details table and Item Pricing table.
There are a couple of new fields available in the Accounts Receivable Documents table: Document Amt (Functional) and Document Amt (Customer). These fields contains the document amount with taxes removed and retainage (if any) included.
There are three new fields available in the Accounts Receivable Document Details table: Extended Amt (Customer), Amt / Tax Base (Customer), and Amt / Tax Base (Functional). The latter two contain the detail line amount not including any taxes, and is also the amount the tax amounts are based on.
There are a couple of new fields available in the Accounts Payable Documents table: Document Amt (Functional) and Document Amt (Vendor). These fields contains the document amount with taxes removed and retainage (if any) included.
There are a couple of new fields available in the Accounts Payable Document Details table: Amt / Tax Base (Vendor), and Amt / Tax Base (Functional). These fields contain the detail line amount not including any taxes, and is also the amount the tax amounts are based on.

The Stonefield Query Alternative

2010-02-23T12:40:00.001-06:00

Stonefield Query is discussed as an alternative to Crystal Reports and SQL Server Reporting Services in this article on the Software for Enterprise site.

Stonefield Query for Sage Pro ERP Version 3.3 Build 3667

2010-01-18T15:29:00.001-06:00

We released an update to Stonefield Query for Sage Pro ERP version 3.3 today. It has the following new features:

Sage Pro 2010 is now supported.
Relationships were created between the PO Transaction File and the Inventory Transaction, Item at Location, and Purchase Order Master Files.
There's a new Quantity Open field (which is Qty Ordered - Qty Received) in the Order Entry Transactions File.
There are new On Order PO and Allocated SO fields in the Inventory Master File.
You can configure Stonefield Query to use the Sage Pro DSN directly instead of going through the Sage Pro COM component when accessing SQL Server. To do this, add the following to DATA.INI:

UseDSN=Y
In the Field Properties dialog, the Summary option has a new choice: Count Distinct. The difference between Count and Count Distinct is that Count counts the number of records while Count Distinct counts the number of records having unique values on this field. For example, if there are 100 order records but all orders were placed this week, using Count on the Order Date field would display 100 but Count Distinct would display 7 (assuming at least one order was placed every day this week). Also, the Summary option is now available for all field types, not just numeric fields.
The Display date as option in the Field Properties dialog has a new choice: Hour, which displays the hour portion of the datetime value.
If you use a date or datetime field in the X-axis, missing values are automatically added to the chart, and the range of those values respects any date filter you use. For example, in the following chart, the only dates that had orders were 07/04, 07/05, and 07/08, but the filter condition was Order Date is between 07/01/1996 and 07/08/1996, so all days between those dates appear whether they had any orders or not:
The Chart Type page in Step 4 of the Chart Wizard has a new Summary report option, which is turned on by default. Turn this option off if, instead of displaying summarized values, you want individual values charted.
The Formula Editor has a new Send formula to database engine option that allows you to specify whether the database engine evaluates the formula or whether Stonefield Query requests any fields used in the formula from the database engine and then evaluates the formula itself.
If you use an existing formula in a new formula, the existing formula is no longer expanded to show its definition in the new formula; instead, just its name appears, as it did when you created the new formula. For example, suppose a formula called Total Price is Unit Price * Quantity. If you create another formula called Commission, which is Total Price * 0.05, the formula displays as Total Price * 0.05 rather than Unit Price * Quantity * 0.05 as it used to in previous versions.
Cross-tab reports have a new "Show percentage of total" option.
Blank column headings now appear as "(None)" in cross-tab reports.
In a multiple database report, if the query for one database fails for a reason other than a connection problem, the report continues to run if the Continue multi-database report if cannot connect to one database setting in the Options dialog is turned on.

Stonefield Query SDK Version 3.3 Build 3667

2010-01-18T15:26:00.001-06:00

We released an update to the Stonefield Query SDK version 3.3 today. It has the following new features:

Report Designer

In the Field Properties dialog, the Summary option has a new choice: Count Distinct. The difference between Count and Count Distinct is that Count counts the number of records while Count Distinct counts the number of records having unique values on this field. For example, if there are 100 order records but all orders were placed this week, using Count on the Order Date field would display 100 but Count Distinct would display 7 (assuming at least one order was placed every day this week). Also, the Summary option is now available for all field types, not just numeric fields.
The Display date as option in the Field Properties dialog has a new choice: Hour, which displays the hour portion of the datetime value.
If you use a date or datetime field in the X-axis, missing values are automatically added to the chart, and the range of those values respects any date filter you use. For example, in the following chart, the only dates that had orders were 07/04, 07/05, and 07/08, but the filter condition was Order Date is between 07/01/1996 and 07/08/1996, so all days between those dates appear whether they had any orders or not:
The Chart Type page in Step 4 of the Chart Wizard has a new Summary report option, which is turned on by default. Turn this option off if, instead of displaying summarized values, you want individual values charted.
The Formula Editor has a new Send formula to database engine option that allows you to specify whether the database engine evaluates the formula or whether Stonefield Query requests any fields used in the formula from the database engine and then evaluates the formula itself.
If you use an existing formula in a new formula, the existing formula is no longer expanded to show its definition in the new formula; instead, just its name appears, as it did when you created the new formula. For example, suppose a formula called Total Price is Unit Price * Quantity. If you create another formula called Commission, which is Total Price * 0.05, the formula displays as Total Price * 0.05 rather than Unit Price * Quantity * 0.05 as it used to in previous versions.
Cross-tab reports have a new "Show percentage of total" option.
Blank column headings now appear as "(None)" in cross-tab reports.
In a multiple database report, if the query for one database fails for a reason other than a connection problem, the report continues to run if the Continue multi-database report if cannot connect to one database setting in the Options dialog is turned on.

SDK

Stonefield Query now supports the syntax for outer joins used by older versions of Oracle, such as SELECT SomeFields FROM SomeTable, SomeOtherTable WHERE SomeTable.SomeField = SomeOtherTable.SomeField (+).
You can now specify that a database login dialog should appear when the Configuration Utility connects to the database by adding DispLogins=2 to a [Settings] section in SFQEDITOR.INI (if that file doesn't exist, create it).

Stonefield Query for Sage Accpac ERP Version 3.3 Build 3667

2010-01-18T15:22:00.001-06:00

We released an update to Stonefield Query for Sage Accpac ERP version 3.3 today. It has the following new features:

Stonefield Query now supports optional fields in the Return Material Authorizations and Return Material Authorization Details tables.
There is now a relationship between the AR Ship-To Locations and OE Invoices, Credit/Debit Notes, and Combined Invoices & Credit Notes tables.
Each Uni Sales Analysis budget now appears as its own table named "Budget" followed by the budget name, and these tables are linked to the Sales Analysis Details table so you can include both budget and actual amounts on the same report.
In the Field Properties dialog, the Summary option has a new choice: Count Distinct. The difference between Count and Count Distinct is that Count counts the number of records while Count Distinct counts the number of records having unique values on this field. For example, if there are 100 order records but all orders were placed this week, using Count on the Order Date field would display 100 but Count Distinct would display 7 (assuming at least one order was placed every day this week). Also, the Summary option is now available for all field types, not just numeric fields.
The Display date as option in the Field Properties dialog has a new choice: Hour, which displays the hour portion of the datetime value.
If you use a date or datetime field in the X-axis, missing values are automatically added to the chart, and the range of those values respects any date filter you use. For example, in the following chart, the only dates that had orders were 07/04, 07/05, and 07/08, but the filter condition was Order Date is between 07/01/1996 and 07/08/1996, so all days between those dates appear whether they had any orders or not:
The Chart Type page in Step 4 of the Chart Wizard has a new Summary report option, which is turned on by default. Turn this option off if, instead of displaying summarized values, you want individual values charted.
The Formula Editor has a new Send formula to database engine option that allows you to specify whether the database engine evaluates the formula or whether Stonefield Query requests any fields used in the formula from the database engine and then evaluates the formula itself.
If you use an existing formula in a new formula, the existing formula is no longer expanded to show its definition in the new formula; instead, just its name appears, as it did when you created the new formula. For example, suppose a formula called Total Price is Unit Price * Quantity. If you create another formula called Commission, which is Total Price * 0.05, the formula displays as Total Price * 0.05 rather than Unit Price * Quantity * 0.05 as it used to in previous versions.
Cross-tab reports have a new "Show percentage of total" option.
Blank column headings now appear as "(None)" in cross-tab reports.
In a multiple database report, if the query for one database fails for a reason other than a connection problem, the report continues to run if the Continue multi-database report if cannot connect to one database setting in the Options dialog is turned on.

AccountMate 7.6 Now Supported

2009-12-14T10:37:00.003-06:00

A small update of Stonefield Query for AccountMate SQL is now available that supports the new versions that were recently released by AccountMate. This includes AccountMate 7.6 for SQL and AccountMate 7.6 for Express.

Stonefield Query Featured in StartUp Beat

2009-12-07T14:47:00.001-06:00

Stonefield Query and Stonefield Software were recently featured in an article on StartUp Beat: http://startupbeat.com/sub/2009/12/featured_pitch_stonefield_query_id2300.html

Stonefield Query for Sage Pro ERP Version 3.3 Build 3587

2009-11-27T13:18:00.001-06:00

We released an update to Stonefield Query for Sage Pro ERP version 3.3 today. See the general changes made to Stonefield Query for what’s new.

Stonefield Query for Sage Accpac ERP Version 3.3 Build 3587

2009-11-02T14:17:00.001-06:00

We released an update to Stonefield Query for Sage Accpac ERP version 3.3 today. In addition to the general changes made to Stonefield Query, it has the following new features:

Stonefield Query now supports Sage Accpac ERP version 5.6.
The Formula Editor now works with Accpac optional fields.
Stonefield Query now has better support for the Pervasive Client ODBC driver.

Stonefield Query SDK Version 3.3 Build 3587

2009-11-02T14:13:00.001-06:00

We released an update to Stonefield Query SDK version 3.3 today. It has the following new features and bug fixes.

Report Designer

Output to Microsoft Excel spreadsheets now supports memo fields.
You can now specify the SMTP port to use for email in the Email page of the Options dialog.
The Include all fields in same table in group header option in the Grouping page of the Field Properties dialog was removed because it conflicted with the Include this field in the group header for option. To include all fields from the same table as a grouped field in the group header for that field, select each field one at a time and set the Include this field in the group header for option to the name of the grouped field.
The Import function in the Template Editor is now available even if you're using a Report Viewer license.
The License Manager now has a Refresh button to refresh the display of the licenses.
Fields you've sorted on but with the Display this field in the report setting turned off are not sorted. Otherwise, a summary report with a non-grouped, non-summed field that's sorted on would be sorted on a field that isn't visible in the report rather than the group fields.
If you have expired subscription licenses, you can now remove them at startup rather than shutting down the application.
The Open Database function in the File menu is now disabled if any report wizard windows are open.
A bug that caused changes to which users belong to which groups in the Maintain Users and Groups dialog to be discarded was fixed.
A bug that prevented passwords of exactly ten characters from working correctly was fixed.
A bug that caused incorrect row totals in cross-tabulation reports when you included a field that doesn't appear in the report was fixed.
A bug that caused an error when printing certain types of currency values was fixed.
A bug that caused an error when using a date field in the data area of a cross-tab report was fixed.
A bug that caused date fields formatted as week, month, quarter, or year in the row of a cross-tab report to not output correctly was fixed.
A bug that caused an error under some conditions when using the "is between" operator with date fields in an exclusion filter was fixed.
A bug that caused an error with a template such as "Fancy Groups 1" with a report that has no groups but enough fields to move to the next row was fixed.
A bug that caused an error when clicking the Values button in the Filter dialog for exclusion conditions was fixed.
A bug that caused an error when outputting a summary report that has Show count in group footer turned on for a grouped field to file was fixed.
A bug that caused an error when importing an invalid template was fixed.
Turning off grouping for a formerly grouped field now removes all fields from the group header for that field.
A bug that caused a field with a space in the name to be grouped even if it isn't supposed to be when you save the layout in the Advanced Report Designer was fixed.
A bug that caused an error when a date field with a very long name is used in the row of a cross-tab report was fixed.
A bug that caused a column in a cross-tab report with a blank column header to be omitted but the values in that column to be included in row totals was fixed.
Microsoft Excel data-only and comma-delimited (CSV) output now works properly when a field has a character value that Excel may treat as scientific notation. Also, date values that could be valid regardless of the date format used (for example, 01/06/2009 is January 6, 2009 when the date is formatted as MM/DD/YYYY but June 1, 2009 when formatted as DD/MM/YYYY) are now output properly to Excel data-only files.
A bug that didn't display the steps in the ask-at-runtime filter dialog correctly when there are a lot of ask-at-runtime conditions was fixed.
A bug that caused an error when running a report if "&" appears in your temporary files folder name was fixed.

SDK

The new Share Database Connections configuration setting allows you to specify whether database connections are shared or not; previously, this was done automatically, but that caused a problem for some customers.
Fields with the Display field from related table setting turned on now support having a custom values method. This allows you to, for example, display a list of values in the Filter Condition dialog filtered on the value of a previous filter condition. For example, you may want the user to filter on a school name, then filter on a course name, but you want the list of courses displayed to only be those for the selected school.
You no longer need to call VBScript, JavaScript, VB.Net, or C# user-defined scripts using the RunScript function; you can now call them directly. For example, to call a C# script named GetCategory and pass it the value of the CategoryID for the current record in the result set, use GetCategory(CategoryID) rather than RunScript("GetCategory", CategoryID).
The new Use a Schema for Queries configuration setting allows you to fine-tune the result set retrieved from a database using an ADO connection.
There are several new classes in the Stonefield Query object model: Report, Sort, Sorts, ReportField, and ReportFields.
All help topics showing sample code now include VB.Net and C# examples.
.Net wrapper classes make it much easier to write script code in VB.Net and C#.
The new SQApplication.SetViewerLicenses method allows you to limit the number of Report Viewer licenses available to users.
The new Application.BeforeShowWizard event fires just before Stonefield Query displays a report wizard.
You can now define whether the data group control in Step 1 of the report wizards displays "All" as the last choice if there are two or more data groups or if it only shows defined data groups.
Some operating systems cause an error when you click the New project button in the Configuration Utility toolbar. To avoid this, create a file in the program folder called SFQEditor.INI and in a [Settings] section, add OldGetDir=Yes.
A bug that prevented testing the connection for certain databases was fixed.
A bug that caused an error when reading relationships from VFP databases was fixed.
Support for MySQL was improved.
A bug that caused an error under some conditions when calling SQApplication.GetRegistryKey or SetRegistryKey was fixed.
Stonefield Query now properly works with VFP tables names with begin with digits.

Stonefield Query for ALERE 3.3 Build 3510

2009-09-17T15:47:00.002-06:00

We released an update to Stonefield Query for ALERE version 3.3 today. This new release adds support for ALERE version 6.5 databases.

Stonefield Query for ALERE 3.3 Build 3497

2009-08-10T12:24:00.002-06:00

We released an update to Stonefield Query for ALERE version 3.3 today. It has the same new features and bug fixes as the general release and also now supports ALERE version 5.0 to 6.0 databases.

Stonefield in the News

2009-08-04T10:48:00.001-06:00

Grant Buckler of SoftwareCEO wrote an extensive article on Stonefield Software that was published today. It’s very well written and does a nice job of presenting business tips we’ve learned over the years.

Stonefield Query for Sage Pro ERP 3.3 Build 3497

2009-07-31T13:18:00.001-06:00

We released an update to Stonefield Query for Sage Pro ERP version 3.3 today. It has the same new features and bug fixes as the general release.

Stonefield Query for Sage Accpac ERP 3.3 Build 3497

2009-07-31T13:10:00.001-06:00

We released an update to Stonefield Query for Sage Accpac ERP version 3.3 today. In addition to the general changes made to Stonefield Query, it has the following new features and bug fixes.

Stonefield Query now supports the Return Material Authorization module and Norming Fixed Assets.
New fields in Account Fiscal Sets (General Ledger) allow you to report on the balance for each period.
You can now report on the Fiscal Calendars table (General Ledger).
The new built-in AccpacDateToRealDate function converts Accpac-formatted dates (which are stored as numeric values, such as 20090625 for 06/25/2009) into real date values. This function is useful when you create your own formulas that perform date math.
Relationships between for Location Item Details (Inventory Control) and Purchase History Detail (Purchase Orders), Contract Resource (Project and Job Costing), and Contract Resource Category (Project and Job Costing) were improved.
The relationship between Posting Journal Details and Posting Journal Entries (Accounts Payable) was corrected.
Optional fields now work for tables in the Project and Job Costing Module.
Formulas using fields from the Order Entry Combined Invoice & Credit Note Details table now work correctly, as do formulas using fields with the name "DESC."
A problem with the Extended Amount Less Discount field in the Order Entry Combined Invoice & Credit Note Details table was fixed.
The descriptions for the APOBLJ and AROBLJ tables were changed to "Document Details" to be more consistent with other table descriptions.

Stonefield Query SDK Version 3.3 Build 3497

2009-07-30T16:13:00.001-06:00

We released an update to Stonefield Query SDK version 3.3 today. It has the following new features and bug fixes.

Report Designer

The same preview window is now used in the Advanced Report Designer as the rest of the program.
You can now create formulas that don't query the database, such as "This is some text". Also, if the formula isn't valid, you're now shown the reason. Also, changing the expression for the formula no longer changes the width and decimals unless the data type also changes.
When you use a formula in the expression for another formula, the expression for the other formula is inserted into the expression (that hasn't changed) surrounded with parentheses (the new feature). That prevents a problem with this scenario: suppose you have a formula named Formula1 with an expression of SomeTable.Field1 + SomeTable.Field2, and you use that formula in the expression of another formula: Formula1 * 0.15. In previous versions, that would be expanded to SomeTable.Field1 + SomeTable.Field2 * 0.15, which isn't correct. Now it's expanded to (SomeTable.Field1 + SomeTable.Field2) * 0.15.
The default format for point labels in charts is now Value rather than Category because that's more commonly used.
You can now specify whether a field should stretch if its contents take more than one line in the Properties dialog for the Label Wizard.
The Commonly Used Functions list in the Expression Builder is now always available, not just when you're working with date fields. Also, it includes several new week-related functions.
The Expression Builder no longer adds table names to field names in the Advanced Report Designer. This allows previewing from the Advanced Report Designer to work better.
If you rename a report in the Reports Explorer or a report wizard, the new name appears immediately in the title bar of the window.
The Select Database dialog now has an "All" option. Turn this on to automatically select all databases or off to deselect all databases.
The Options dialog has a new Continue multi-database report if cannot connect to one database setting. If this setting is turned off (the default), when you run a multi-database report and it cannot connect to one or more of the specified databases, the program asks you if you want to continue (the current behavior). If this setting is turned on, the report continues to run without asking you.
Stonefield Query now returns -29 if you run a multi-database report from the command line or the report is scheduled and it cannot connect to one or more of the databases specified in the report and the new Continue multi-database report if cannot connect to one database setting is turned off.
A bug that caused an error when scheduled reports (or reports called from the command line) try to email the report and a file name is specified was fixed.
A bug that caused multi-table reports to fail under some conditions was fixed.
The Values button in Step 2 of the report wizards is now properly disabled if you select a memo field in either the available or selected field lists.
You can no longer move to Step 2 of the External Report Wizard until you've specified the name of the report file.
A bug that caused dates formatted as weeks (such as "Week of 12/31/2009") to be cut off (e.g. "Week of 12/31/200") when you use a date format that has only one digit for day, month, or both (e.g. M/D/YYYY) was fixed.
Microsoft Excel data-only and comma-delimited (CSV) output now works properly when a field has a double quote (") in it. Also, leading zeros (such as "0012345") are now preserved for character fields output to Microsoft Excel data-only files, and character values that Excel may consider to be dates (such as "10/5") are no longer converted to dates.
A bug that caused an error in a linked report when the value of the filter condition passed to the linked report contains a comma was fixed.
Charts using aggregate dates (such as month) in the X-axis are now sorted by date rather than alphabetically.
A bug that caused an error after importing a report containing formulas that didn't exist in your copy of the program was fixed.
Formulas using double quotes for strings (such as "Contact: " + CUSTOMERS.CONTACT) now work correctly.
Setting Summary to "None" in the Field Properties dialog now turns off Show percentage of total to avoid an error that occurs if that's turned on for non-summed fields.
The Formula Editor now properly displays formulas with multi-line headings.
The SQL statements for some types of complex queries—where the query is on tables A, B, and C and B and C are directly related to each other but A isn't directly related to either—are now created properly.
If you have a summary report and one of the grouped fields has the Show count in group footer option turned on, the group count is now shown properly when the Send summary queries to database engine setting in the Options dialog is turned on.
A bug that caused passwords to be invalid under some conditions was fixed.
A bug that caused an error if you formatted a date field as something other than Date (for example, as Month) and didn't group on that field in a summary report was fixed.
A bug that removed fields that are neither grouped nor summed from summary reports was fixed.
A bug that prevented the proper security settings for a report being displayed in Step 6 of the report wizards when you edited the report was fixed.
A bug that caused a schedule created for a report using a specified day of the month to use the first day of the month instead in Windows XP was fixed.
A bug that caused an error for some types of reports (such as charts) when the Send summary queries to database engine setting in the Options dialog is turned on was fixed.
A bug that caused an error in the ask-at-runtime dialog when a field caption has a comma in it was fixed.
Outputting to a text file now respects the setting of the width for each field as specified in the Field Properties dialog if you turn off the Auto-fit column setting.
A bug that caused an error when adding to a report a field in a table that isn't already in the report and the report has a filter on a calculated field was fixed.
If a report fails to run due to an error in the report layout (typically with advanced layout reports), the error message now contains more information about what went wrong.
A bug that prevented using the "top" clause for the SQL statement of a report when the Send summary queries to database engine setting in the Options dialog is turned on was fixed.
You can no longer create an invalid report name by pasting a name with illegal characters.
Turning on the Select only top setting in the Customize dialog for a chart now bases the "top" calculation on the value field rather than the category field.
A bug that caused an error if you created a group in the Advanced Report Designer on concatenated fields (such as COMPANY + CITY), turned off Advanced layout, and tried to run the report was fixed.
A bug that caused an error when you ran a report with a date field as the second field in the row of a cross-tab report and turned on the Place subtotals above details setting was fixed.
The Template Editor now saves comments and report designer captions for fields in the Advanced Report Designer.
A bug that caused a scheduled report to be printed rather than emailed when a field is specified for the Get email address from option was fixed.
You no longer get an error starting Stonefield Query if the "Start in" setting of the desktop shortcut contains something other than the correct program directory.
A bug that caused an error if you included a date field in a report, didn't group on that field but did on other fields, and turned on the Summary report option was fixed.
A bug that caused an error if you grouped on several fields and the first grouped field isn't the first field in the Selected Fields list was fixed.
Formerly, outputting to a text file caused all fields to be left aligned. The desired alignment of each field is now respected.
A bug that caused an error if you imported a Crystal report but don't have the Crystal runtimes installed was fixed.
A bug that caused an error importing a report that contained calculated fields when reports are stored in a different directory than the default was fixed.
Rebuilding the reports table from existing SFX files if the table is deleted or corrupted no longer causes duplicate SFX files to be created in the root of the Reports folder. Also, a bug that caused an error if any of the SFX files contains a formula was fixed.
Numbers formatted to display both a currency symbol and blank if zero are now output correctly to Microsoft Excel data-only files.
A bug that caused several problems if your system is configured for a language other than English (for example, Simplified Chinese) was fixed.
In previous versions, adding a new field to a report that already has a grouped field with the Include all fields in same table in group header setting turned on, then grouping on the new field and moving the group above the former first group caused fields in same table as the former first group to appear in the group header of the new field. This has been fixed.
Formulas are now included when you turn on the "show favorites" button in Step 2 of the report wizards.
A bug that caused a series of error messages if an error occurred in a function called from a field in an advanced layout report was fixed.
A bug that selected the first database in the list rather than the database used the last time in the Login dialog was fixed.
A bug that caused the same data to be displayed in a Crystal report if you ran it then opened a different database and ran it again was fixed.
The news reader now properly displays "smart quotes" in the content.

SDK

If you have more than one database in your data dictionary and those databases use the same database engine on the same server, Stonefield Query will automatically share the connection between the two databases, resulting in fewer connections to the database and significantly faster queries.
The Import Data Dictionary function now support all types of Microsoft Excel files (previous versions didn't work with Excel 2007) and allows you to specify the comment, heading, and enumeration values for fields.
The new ODBCFilterToLocalFilter method of the DataEngine object can be used in Select scripts to ensure the correct filter format is used for a query.
Closing the zoom window for a script now saves it immediately.
The Expression Builder now shows tables from all databases rather than just the one the selected object is in.
A bug that caused multi-table reports to fail with some types of database engines when the Include joins in the WHERE clause configuration setting is turned on was fixed.
The Version property of tables, fields, and relations now supports a comma-delimited list of values. This is useful if the object was added in one version of the application and later removed. For example, "5.3+,5.5-" means it was added in version 5.3 and removed in version 5.6.
Stonefield Query now handles fields with periods in their names, such as MyTable.[SomeName.MoreName].
If you originally had the User Can Manage Data Sources configuration setting turned on and then later turn it off, Stonefield Query no longer uses the DSNs you defined in the Manage Databases dialog.
A bug that caused the wrong table to be shown in the drop down list for the Table to Test configuration setting was fixed.
SQOutput.EXE and SQPreview.EXE are no longer needed or distributed.
A bug that caused 0 to be entered when you typed a value for the join weight of a relation was fixed.
A bug that caused an error if you had diagnostic logging turned on and refreshed a database more than once was fixed.
A bug that caused an error if you referenced the FilterConditions collection in a DataEngine.FilterChanged script was fixed.
Stonefield Query now works better with the Progress database engine.
A bug that caused an error after encrypting or decrypting a project was fixed.

Stonefield Query for Sage MAS 90-200 3.3

2009-07-08T09:54:00.001-06:00

We released version 3.3 of Stonefield Query for Sage MAS 90-200 today. The list of new and enhanced features in version 3.3 is extensive; see the online help for complete details. Here are the major new features.

Report Designer

The new Formula Editor allows you to create your own formulas without using the Advanced Report Designer or customizing the data dictionary.
The new Show percentage of total option in the Format page of the Field Properties dialog automatically adds a new column to the report showing the percentage that the field is of the subtotal in detail lines, of the next level of grouping in subgroup footers, and of the grand total for group footers.
Turn on the new Show totals in group headers option in Step 5 of the Quick Report Wizard and the Options page of the Reports Explorer to display group totals in the group header rather than the group footer.
Stonefield Query now supports Crystal Reports reports. You can add them to Stonefield Query using the External Report Wizard.
The Preview window is no longer modal, meaning you can open multiple instances. Also, the new Preview reports in tabbed pages setting in the Options dialog allows you to determine whether different preview windows are used when you run more than one report or whether the reports appear as different tabs in the same preview window.
There are several new output options available. You can specify that a timestamp is added to the file created to prevent overwriting existing files, that the file emailed to someone shouldn't be deleted after the email is sent, and what filename to use for the emailed file.
Previous versions of Stonefield Query create a report as a PDF file when emailing the report to someone. You can now specify the type of file used as an attachment.
You can now specify that each group in a report should be output to a separate file or email and that the email address should come from a field in the report itself. This can be used, for example, to email invoices to customers; the report is grouped by customer name and includes the customer's email address, so each customer's records are emailed to them.
You can now sort fields in database order or alphabetical order in Step 2 of the report wizards.
You can now tell Stonefield Query to display in the Tables drop-down list only those tables related to tables already appearing in the selected list.
Reports are now stored as export files with an SFX extension in a folder structure that exactly matches the folders in the Reports Explorer.
The new Send summary queries to database engine setting in the Options dialog allows you to specify whether Stonefield Query or the database engine does data summarization. This may significantly improve the performance of certain types of reports.
The new Run report with no records option in Step 5 of the report wizards and the Options page in the Reports Explorer allows you to run a report when there are no records that match your conditions.

Stonefield Query for AccountMate 3.3

2009-07-08T09:49:00.001-06:00

We released version 3.3 of Stonefield Query for AccountMate LAN and SQL today. The list of new and enhanced features in version 3.3 is extensive; see the online help for complete details. Here are the major new features.

Report Designer

The new Formula Editor allows you to create your own formulas without using the Advanced Report Designer or customizing the data dictionary.
The new Show percentage of total option in the Format page of the Field Properties dialog automatically adds a new column to the report showing the percentage that the field is of the subtotal in detail lines, of the next level of grouping in subgroup footers, and of the grand total for group footers.
Turn on the new Show totals in group headers option in Step 5 of the Quick Report Wizard and the Options page of the Reports Explorer to display group totals in the group header rather than the group footer.
Stonefield Query now supports Crystal Reports reports. You can add them to Stonefield Query using the External Report Wizard.
The Preview window is no longer modal, meaning you can open multiple instances. Also, the new Preview reports in tabbed pages setting in the Options dialog allows you to determine whether different preview windows are used when you run more than one report or whether the reports appear as different tabs in the same preview window.
There are several new output options available. You can specify that a timestamp is added to the file created to prevent overwriting existing files, that the file emailed to someone shouldn't be deleted after the email is sent, and what filename to use for the emailed file.
Previous versions of Stonefield Query create a report as a PDF file when emailing the report to someone. You can now specify the type of file used as an attachment.
You can now specify that each group in a report should be output to a separate file or email and that the email address should come from a field in the report itself. This can be used, for example, to email invoices to customers; the report is grouped by customer name and includes the customer's email address, so each customer's records are emailed to them.
You can now sort fields in database order or alphabetical order in Step 2 of the report wizards.
You can now tell Stonefield Query to display in the Tables drop-down list only those tables related to tables already appearing in the selected list.
Reports are now stored as export files with an SFX extension in a folder structure that exactly matches the folders in the Reports Explorer.
The new Send summary queries to database engine setting in the Options dialog allows you to specify whether Stonefield Query or the database engine does data summarization. This may significantly improve the performance of certain types of reports.
The new Run report with no records option in Step 5 of the report wizards and the Options page in the Reports Explorer allows you to run a report when there are no records that match your conditions.

Stonefield Query Version 3.3 Build 3436

2009-05-29T15:34:00.001-06:00

We don’t normally release an update just a couple of days after the previous one, but a change we made in how summary reports are handled wasn’t very popular with some customers! Also, we made a few other improvements and bug fixes:

Some customers didn’t like a change we made regarding the treatment of non-grouped non-totalled fields in a quick report with "Summary report" turned on (it added those fields to the group header and it affected grouping totals), so we changed it back the way it was.
Stonefield Query can now handle Crystal reports that report on tables that aren’t in the data dictionary, such as custom views in your database.
In Step 2 of the External Report Wizard, you can now indicate that you want to use the Crystal report’s connection information rather than the current database open in Stonefield Query. That’s important if the report should always connect to a specific database regardless of what’s open in Stonefield Query.
You now get a warning message if you try to add a Crystal data pipe report to Stonefield Query, since those types of reports aren’t supported.
A problem that prevented scheduled reports from sending emails unless a BCC recipient was specified was fixed.
Stonefield Query can now handle semicolons between email addresses (it previously expected you to use commas).
Stonefield Query now handles custom SQL statements with ORDER BY or GROUP BY in a subquery properly.
A bug that caused the FilterConditions collection of report objects retrieved using the SQProxy object from being properly initialized was fixed.
If you selected a report using a data group/module (for example, Accounts Receivable), then added a new formula and in the Expression Builder chose a table from a different data group/module, the fields for that table didn’t appear. That was fixed.

Stonefield Query for HEAT Version 3.3

2009-05-29T10:48:00.002-06:00

We released version 3.3 of Stonefield Query for HEAT today. The list of new and enhanced features in version 3.3 is extensive; see the online help for complete details. Here are the major new features.

Report Designer

The new Formula Editor allows you to create your own formulas without using the Advanced Report Designer or customizing the data dictionary.
The new Show percentage of total option in the Format page of the Field Properties dialog automatically adds a new column to the report showing the percentage that the field is of the subtotal in detail lines, of the next level of grouping in subgroup footers, and of the grand total for group footers.
Turn on the new Show totals in group headers option in Step 5 of the Quick Report Wizard and the Options page of the Reports Explorer to display group totals in the group header rather than the group footer.
Stonefield Query now supports Crystal Reports reports. You can add them to Stonefield Query using the External Report Wizard.
The Preview window is no longer modal, meaning you can open multiple instances. Also, the new Preview reports in tabbed pages setting in the Options dialog allows you to determine whether different preview windows are used when you run more than one report or whether the reports appear as different tabs in the same preview window.
There are several new output options available. You can specify that a timestamp is added to the file created to prevent overwriting existing files, that the file emailed to someone shouldn't be deleted after the email is sent, and what filename to use for the emailed file.
Previous versions of Stonefield Query create a report as a PDF file when emailing the report to someone. You can now specify the type of file used as an attachment.
You can now specify that each group in a report should be output to a separate file or email and that the email address should come from a field in the report itself. This can be used, for example, to email invoices to customers; the report is grouped by customer name and includes the customer's email address, so each customer's records are emailed to them.
You can now sort fields in database order or alphabetical order in Step 2 of the report wizards.
You can now tell Stonefield Query to display in the Tables drop-down list only those tables related to tables already appearing in the selected list.
Reports are now stored as export files with an SFX extension in a folder structure that exactly matches the folders in the Reports Explorer.
The new Send summary queries to database engine setting in the Options dialog allows you to specify whether Stonefield Query or the database engine does data summarization. This may significantly improve the performance of certain types of reports.
The new Run report with no records option in Step 5 of the report wizards and the Options page in the Reports Explorer allows you to run a report when there are no records that match your conditions.
You can now report on HEAT "First Level Support" tables.
Added new "Latest Group Assigned" field to the "Call Log" table that will give you the name of the most recent Group that a Call has been assigned to. This is available so that you do not need to include the "Assignments" table in the report as this would give you multiple records for each Call, one for each assignment that the Call has.
Added a new "Latest Assignee" field to the "Call Log" table that tells you who the latest assignee is for that particular call.
Table captions are now of the form: TABLEDESC[TABLETYPE]. Where TABLEDESC is the table caption from the HEAT database and TABLETYPE is the table type (both set by the HEAT administrator). This is to avoid the confusing issue of table listings that have the exact same caption for different tables. You can further narrow down the list of available tables by turning on the "Exclude Supplementary Tables" option in the Tools->Options menu.

Stonefield Query for Sage BusinessVision Version 3.3

2009-05-27T15:58:00.000-06:00

We released version 3.3 of Stonefield Query for Sage BusinessVision today. The list of new and enhanced features in version 3.3 is extensive; see the online help for complete details. Here are the major new features.

Report Designer

The new Formula Editor allows you to create your own formulas without using the Advanced Report Designer or customizing the data dictionary.
The new Show percentage of total option in the Format page of the Field Properties dialog automatically adds a new column to the report showing the percentage that the field is of the subtotal in detail lines, of the next level of grouping in subgroup footers, and of the grand total for group footers.
Turn on the new Show totals in group headers option in Step 5 of the Quick Report Wizard and the Options page of the Reports Explorer to display group totals in the group header rather than the group footer.
Stonefield Query now supports Crystal Reports reports. You can add them to Stonefield Query using the External Report Wizard.
The Preview window is no longer modal, meaning you can open multiple instances. Also, the new Preview reports in tabbed pages setting in the Options dialog allows you to determine whether different preview windows are used when you run more than one report or whether the reports appear as different tabs in the same preview window.
There are several new output options available. You can specify that a timestamp is added to the file created to prevent overwriting existing files, that the file emailed to someone shouldn't be deleted after the email is sent, and what filename to use for the emailed file.
Previous versions of Stonefield Query create a report as a PDF file when emailing the report to someone. You can now specify the type of file used as an attachment.
You can now specify that each group in a report should be output to a separate file or email and that the email address should come from a field in the report itself. This can be used, for example, to email invoices to customers; the report is grouped by customer name and includes the customer's email address, so each customer's records are emailed to them.
You can now sort fields in database order or alphabetical order in Step 2 of the report wizards.
You can now tell Stonefield Query to display in the Tables drop-down list only those tables related to tables already appearing in the selected list.
Reports are now stored as export files with an SFX extension in a folder structure that exactly matches the folders in the Reports Explorer.
The new Send summary queries to database engine setting in the Options dialog allows you to specify whether Stonefield Query or the database engine does data summarization. This may significantly improve the performance of certain types of reports.
The new Run report with no records option in Step 5 of the report wizards and the Options page in the Reports Explorer allows you to run a report when there are no records that match your conditions.
Stonefield Query is now compatible with BusinessVision version 7.3.

Stonefield Query for GoldMine Version 3.3

2009-05-27T14:20:00.000-06:00

We released version 3.3 of Stonefield Query for GoldMine today. The list of new and enhanced features in version 3.3 is extensive; see the online help for complete details. Here are the major new features.

Report Designer

The new Formula Editor allows you to create your own formulas without using the Advanced Report Designer or customizing the data dictionary.
The new Show percentage of total option in the Format page of the Field Properties dialog automatically adds a new column to the report showing the percentage that the field is of the subtotal in detail lines, of the next level of grouping in subgroup footers, and of the grand total for group footers.
Turn on the new Show totals in group headers option in Step 5 of the Quick Report Wizard and the Options page of the Reports Explorer to display group totals in the group header rather than the group footer.
Stonefield Query now supports Crystal Reports reports. You can add them to Stonefield Query using the External Report Wizard.
The Preview window is no longer modal, meaning you can open multiple instances. Also, the new Preview reports in tabbed pages setting in the Options dialog allows you to determine whether different preview windows are used when you run more than one report or whether the reports appear as different tabs in the same preview window.
There are several new output options available. You can specify that a timestamp is added to the file created to prevent overwriting existing files, that the file emailed to someone shouldn't be deleted after the email is sent, and what filename to use for the emailed file.
Previous versions of Stonefield Query create a report as a PDF file when emailing the report to someone. You can now specify the type of file used as an attachment.
You can now specify that each group in a report should be output to a separate file or email and that the email address should come from a field in the report itself. This can be used, for example, to email invoices to customers; the report is grouped by customer name and includes the customer's email address, so each customer's records are emailed to them.
You can now sort fields in database order or alphabetical order in Step 2 of the report wizards.
You can now tell Stonefield Query to display in the Tables drop-down list only those tables related to tables already appearing in the selected list.
Reports are now stored as export files with an SFX extension in a folder structure that exactly matches the folders in the Reports Explorer.
The new Send summary queries to database engine setting in the Options dialog allows you to specify whether Stonefield Query or the database engine does data summarization. This may significantly improve the performance of certain types of reports.
The new Run report with no records option in Step 5 of the report wizards and the Options page in the Reports Explorer allows you to run a report when there are no records that match your conditions.
Stonefield Query for GoldMine now supports GoldMine version 8.5. GoldMine 8.5 has a new format for storing notes fields in the database, and allows 12 details fields rather than 8 as in previous versions. These changes are supported in Query.
New Notes Including Email fields are available in the Calendar, History, and Combined Pending and History tables.

Stonefield Query Version 3.3 Build 3433

2009-05-27T11:54:00.001-06:00

We released an update to Stonefield Query version 3.3 today. It has the following new features and bug fixes.

Report Designer

The Formula Editor now allows you to specify what table the formula appears in, as well as its data type, size, and number of decimals. In previous versions, it determined these things automatically but didn't allow you to change them. In addition to letting you edit them if necessary, it now does a better job of determining the defaults for these settings.
The Formula Editor also allows you to save formulas that aren't valid in the Formula Editor but might be when running a report. This allows you to use much more complex formulas, such as using the RunSQL or SQLookup functions.
The new SQLookup function allows you to retrieve a value from another table without doing a join to that table.
Using a date field in the X axis of a chart report now automatically formats it to display the year. You can, of course, change that to another type of format.
Linking now works for fields in group headers.
Grouping on a field that appears later in the field list than numeric fields with "Show percentage of total" turned on no longer gives an error.
You now longer get an error if a non-grouped non-totalled field appears in a quick report with "Summary report" turned on and one or more fields having "Show percentage of total" turned on.
A bug that prevented the Values button in Step 2 of the report wizards from working under some conditions was fixed.
The news reader now shows the correct date for news items.
A bug that prevented a file from being created when you're emailing a report and outputting each group to a separate file and you didn't specify the file name and the "Erase file after email sent" option is turned on was fixed.
A bug that preventing a field with "Show percentage of total" turned on from working properly in a report that has no grouped fields was fixed.
You now get a warning if you try to run a chart report that has too many data points.
A bug that caused an error or didn't size fields properly when running a report with fields that have "illegal" characters (such as dashes) in their names was fixed.
A bug that under some conditions caused a field to be retrieved from the wrong table after editing the report in the Advanced Report Designer was fixed.
A bug that displayed only a single value in a chart when you used a date field in the X axis and formatted it to display something other than date (such as Month or Quarter) was fixed.
A bug that caused an error when you filter a summary report on a logical field was fixed.
A bug that caused connection problems with some types of Crystal reports was fixed.

SDK

A bug that caused an error when doing screen shots during help generation was fixed.
A bug that prevented displaying a database defined in the first meta data table when you're using multiple meta data tables after refreshing the data dictionary was fixed.
Refreshing a data dictionary no longer causes certain objects that didn't have any changes from being added to the last meta data table when you're using multiple meta data tables.
Removing an object from the data dictionary now removes it from all meta data tables when you're using multiple meta data tables.

Stonefield Query for ACT! Version 3.3

2009-05-25T14:18:00.008-06:00

We released version 3.3 of Stonefield Query for ACT! today. The list of new and enhanced features in version 3.3 is extensive; see the online help for complete details. Here are the major new features.

Report Designer

The new Formula Editor allows you to create your own formulas without using the Advanced Report Designer or customizing the data dictionary.
The new Show percentage of total option in the Format page of the Field Properties dialog automatically adds a new column to the report showing the percentage that the field is of the subtotal in detail lines, of the next level of grouping in subgroup footers, and of the grand total for group footers.
Turn on the new Show totals in group headers option in Step 5 of the Quick Report Wizard and the Options page of the Reports Explorer to display group totals in the group header rather than the group footer.
Stonefield Query now supports Crystal Reports reports. You can add them to Stonefield Query using the External Report Wizard.
The Preview window is no longer modal, meaning you can open multiple instances. Also, the new Preview reports in tabbed pages setting in the Options dialog allows you to determine whether different preview windows are used when you run more than one report or whether the reports appear as different tabs in the same preview window.
There are several new output options available. You can specify that a timestamp is added to the file created to prevent overwriting existing files, that the file emailed to someone shouldn't be deleted after the email is sent, and what filename to use for the emailed file.
Previous versions of Stonefield Query create a report as a PDF file when emailing the report to someone. You can now specify the type of file used as an attachment.
You can now specify that each group in a report should be output to a separate file or email and that the email address should come from a field in the report itself. This can be used, for example, to email invoices to customers; the report is grouped by customer name and includes the customer's email address, so each customer's records are emailed to them.
You can now sort fields in database order or alphabetical order in Step 2 of the report wizards.
You can now tell Stonefield Query to display in the Tables drop-down list only those tables related to tables already appearing in the selected list.
Reports are now stored as export files with an SFX extension in a folder structure that exactly matches the folders in the Reports Explorer.
The new Send summary queries to database engine setting in the Options dialog allows you to specify whether Stonefield Query or the database engine does data summarization. This may significantly improve the performance of certain types of reports.
The new Run report with no records option in Step 5 of the report wizards and the Options page in the Reports Explorer allows you to run a report when there are no records that match your conditions.
Stonefield Query now supports the changes made in the ACT! 11.1 update.
The new field Contact in Current Lookup has been added to the Contact table. This field allows reports to be filtered based on the current ACT! lookup.
The new table Contact Related Contacts is now available. This table was added in ACT! 11.1, so it will only be available in Query when connected to an ACT! 11.1 or later database.
The Add Report to ACT! Menu function has been improved, and now offers many more options for specifying settings for these reports.

Stonefield Query for Sage Timberline Office 3.3

2009-05-20T11:23:00.001-06:00

We released version 3.3 of Stonefield Query for Sage Timberline Office today. The list of new and enhanced features in version 3.3 is extensive; see the online help for complete details. Here are the major new features.

Report Designer

The new Formula Editor allows you to create your own formulas without using the Advanced Report Designer or customizing the data dictionary.
The new Show percentage of total option in the Format page of the Field Properties dialog automatically adds a new column to the report showing the percentage that the field is of the subtotal in detail lines, of the next level of grouping in subgroup footers, and of the grand total for group footers.
Turn on the new Show totals in group headers option in Step 5 of the Quick Report Wizard and the Options page of the Reports Explorer to display group totals in the group header rather than the group footer.
Stonefield Query now supports Crystal Reports reports. You can add them to Stonefield Query using the External Report Wizard.
The Preview window is no longer modal, meaning you can open multiple instances. Also, the new Preview reports in tabbed pages setting in the Options dialog allows you to determine whether different preview windows are used when you run more than one report or whether the reports appear as different tabs in the same preview window.
There are several new output options available. You can specify that a timestamp is added to the file created to prevent overwriting existing files, that the file emailed to someone shouldn't be deleted after the email is sent, and what filename to use for the emailed file.
Previous versions of Stonefield Query create a report as a PDF file when emailing the report to someone. You can now specify the type of file used as an attachment.
You can now specify that each group in a report should be output to a separate file or email and that the email address should come from a field in the report itself. This can be used, for example, to email invoices to customers; the report is grouped by customer name and includes the customer's email address, so each customer's records are emailed to them.
You can now sort fields in database order or alphabetical order in Step 2 of the report wizards.
You can now tell Stonefield Query to display in the Tables drop-down list only those tables related to tables already appearing in the selected list.
Reports are now stored as export files with an SFX extension in a folder structure that exactly matches the folders in the Reports Explorer.
The new Send summary queries to database engine setting in the Options dialog allows you to specify whether Stonefield Query or the database engine does data summarization. This may significantly improve the performance of certain types of reports.
The new Run report with no records option in Step 5 of the report wizards and the Options page in the Reports Explorer allows you to run a report when there are no records that match your conditions.

Stonefield Query for SalesLogix Version 3.3

2009-05-19T13:43:00.002-06:00

We released version 3.3 of Stonefield Query for SalesLogix today. The list of new and enhanced features in version 3.3 is extensive; see the online help for complete details. Here are the major new features.

Report Designer

The new Formula Editor allows you to create your own formulas without using the Advanced Report Designer or customizing the data dictionary.
The new Show percentage of total option in the Format page of the Field Properties dialog automatically adds a new column to the report showing the percentage that the field is of the subtotal in detail lines, of the next level of grouping in subgroup footers, and of the grand total for group footers.
Turn on the new Show totals in group headers option in Step 5 of the Quick Report Wizard and the Options page of the Reports Explorer to display group totals in the group header rather than the group footer.
Stonefield Query now supports Crystal Reports reports. You can add them to Stonefield Query using the External Report Wizard.
The Preview window is no longer modal, meaning you can open multiple instances. Also, the new Preview reports in tabbed pages setting in the Options dialog allows you to determine whether different preview windows are used when you run more than one report or whether the reports appear as different tabs in the same preview window.
There are several new output options available. You can specify that a timestamp is added to the file created to prevent overwriting existing files, that the file emailed to someone shouldn't be deleted after the email is sent, and what filename to use for the emailed file.
Previous versions of Stonefield Query create a report as a PDF file when emailing the report to someone. You can now specify the type of file used as an attachment.
You can now specify that each group in a report should be output to a separate file or email and that the email address should come from a field in the report itself. This can be used, for example, to email invoices to customers; the report is grouped by customer name and includes the customer's email address, so each customer's records are emailed to them.
You can now sort fields in database order or alphabetical order in Step 2 of the report wizards.
You can now tell Stonefield Query to display in the Tables drop-down list only those tables related to tables already appearing in the selected list.
Reports are now stored as export files with an SFX extension in a folder structure that exactly matches the folders in the Reports Explorer.
The new Send summary queries to database engine setting in the Options dialog allows you to specify whether Stonefield Query or the database engine does data summarization. This may significantly improve the performance of certain types of reports.
The new Run report with no records option in Step 5 of the report wizards and the Options page in the Reports Explorer allows you to run a report when there are no records that match your conditions.

Stonefield Query for ALERE Version 3.3

2009-05-19T13:02:00.002-06:00

We released version 3.3 of Stonefield Query for ALERE today. The list of new and enhanced features in version 3.3 is extensive; see the online help for complete details. Here are the major new features.

Report Designer

The new Formula Editor allows you to create your own formulas without using the Advanced Report Designer or customizing the data dictionary.
The new Show percentage of total option in the Format page of the Field Properties dialog automatically adds a new column to the report showing the percentage that the field is of the subtotal in detail lines, of the next level of grouping in subgroup footers, and of the grand total for group footers.
Turn on the new Show totals in group headers option in Step 5 of the Quick Report Wizard and the Options page of the Reports Explorer to display group totals in the group header rather than the group footer.
Stonefield Query now supports Crystal Reports reports. You can add them to Stonefield Query using the External Report Wizard.
The Preview window is no longer modal, meaning you can open multiple instances. Also, the new Preview reports in tabbed pages setting in the Options dialog allows you to determine whether different preview windows are used when you run more than one report or whether the reports appear as different tabs in the same preview window.
There are several new output options available. You can specify that a timestamp is added to the file created to prevent overwriting existing files, that the file emailed to someone shouldn't be deleted after the email is sent, and what filename to use for the emailed file.
Previous versions of Stonefield Query create a report as a PDF file when emailing the report to someone. You can now specify the type of file used as an attachment.
You can now specify that each group in a report should be output to a separate file or email and that the email address should come from a field in the report itself. This can be used, for example, to email invoices to customers; the report is grouped by customer name and includes the customer's email address, so each customer's records are emailed to them.
You can now sort fields in database order or alphabetical order in Step 2 of the report wizards.
You can now tell Stonefield Query to display in the Tables drop-down list only those tables related to tables already appearing in the selected list.
Reports are now stored as export files with an SFX extension in a folder structure that exactly matches the folders in the Reports Explorer.
The new Send summary queries to database engine setting in the Options dialog allows you to specify whether Stonefield Query or the database engine does data summarization. This may significantly improve the performance of certain types of reports.
The new Run report with no records option in Step 5 of the report wizards and the Options page in the Reports Explorer allows you to run a report when there are no records that match your conditions.

Stonefield Query for SageCRM Released

2009-05-15T12:12:00.005-06:00

Stonefield Software Inc. is pleased to announce the first release of Stonefield Query for SageCRM (version 3.30.3420).

Below is a list of just some of the features in this release, please see the online help for a complete list of features.

SageCRM Specific Features

Stonefield Query for SageCRM supports SageCRM version 6.1 to 6.2 databases.
Comes with over 60 pre-defined reports! Almost all of the SageCRM Sample Reports have been recreated for you.
All SageCRM tables and fields will use your custom captions as defined by the SageCRM Administrator. This makes it easy to find the table or field that you are looking for.
Stonefield Query for SageCRM can report on custom SageCRM tables and fields as defined by the SageCRM Administrator.
Stonefield Query for SageCRM supports SageCRM 6.2 Related Entities (through the "Related A to B (6.2 and later)" tables where A is the first table in the relationship and B is the second table). In SageCRM 6.2, the Relationships tab is available in the context of Companies, People, Leads, Opportunities, Quotes, Orders, and Cases.
Stonefield Query for SageCRM supports SageCRM 6.1 and earlier "Related List Actions" (through the "Related * (6.1 and Earlier)" tables).
Stonefield Query for SageCRM automatically provides custom currency fields that convert from the SageCRM Base Currency (as set by the SageCRM Administrator) to the Preferred Currency that you have selected in the Stonefield Query "Tool->Options" menu.
SageCRM stores Date/Time fields in GMT(Greenwich Mean Time) in the database records and only converts these to your local time zone when you see these fields on screen in SageCRM. Stonefield Query provides "(GMT)" and "(Local Time)" versions of each Date/Time field in your database for this purpose.
SageCRM does not actually delete any records from the database when you delete a record in a SageCRM screen. Instead, these records have their "_Deleted" fields set to 1 indicating that they are deleted. Stonefield Query automatically hides these records for you so you do not see them in your reports.

Other Stonefield Query Features

Powerful query and reporting tool designed with the end-user in mind. Design reports in minutes, not hours or days.
Simple "wizard" interface. After selecting a report from the list of available reports, you can select the sort order, enter filter conditions, and specify where the output goes (printer, text file, spreadsheet, screen preview, etc.).
Full English descriptions for all fields and tables rather than cryptic names and symbols. English operators such as "equals" and "greater than" instead of "=" and ">."
Handles complex join conditions between tables automatically.
Create great-looking charts and graphs, either by themselves or included in other reports.
The Formula Editor allows you to define your own custom calculations to use in any report.
Templates give your reports a common appearance, such as following corporate style guidelines.
Easily create labels, including mailing labels, product labels, or barcode labels, without worrying about field positioning or label dimensions. All the common Avery label sizes are built-in.
Drilldown from a report to see details.
Click the "values" button to get a list of all possible values for any field.
Control font, color, alignment, heading, and column width for each field. Group on any field with a mouse click.
Automatically adjusts column widths to match the data in the column.
The Advanced Report Designer allows you to lay out the report exactly as you want, including company logos, lines, boxes, etc.
Output to Microsoft Excel, PDF, HTML, Microsoft Word, comma-delimited, or other types of files. You can also email reports.
Knows your data. You don't have to know how your data is stored or how tables are joined (you don't even have to know what a "join" is).
Schedule reports to run at any time you need.
Display "real" table and field names so it's easier to locate the table or field you want if you're familiar with these names.

Stonefield Query for Sage Pro ERP Version 3.3

2009-05-13T15:38:00.001-06:00

We released version 3.3 of Stonefield Query for Sage Pro ERP today. The list of new and enhanced features in version 3.3 is extensive; see the online help for complete details. Here are the major new features.

Report Designer

The new Formula Editor allows you to create your own formulas without using the Advanced Report Designer or customizing the data dictionary.
The new Show percentage of total option in the Format page of the Field Properties dialog automatically adds a new column to the report showing the percentage that the field is of the subtotal in detail lines, of the next level of grouping in subgroup footers, and of the grand total for group footers.
Turn on the new Show totals in group headers option in Step 5 of the Quick Report Wizard and the Options page of the Reports Explorer to display group totals in the group header rather than the group footer.
Stonefield Query now supports Crystal Reports reports. You can add them to Stonefield Query using the External Report Wizard.
The Preview window is no longer modal, meaning you can open multiple instances. Also, the new Preview reports in tabbed pages setting in the Options dialog allows you to determine whether different preview windows are used when you run more than one report or whether the reports appear as different tabs in the same preview window.
There are several new output options available. You can specify that a timestamp is added to the file created to prevent overwriting existing files, that the file emailed to someone shouldn't be deleted after the email is sent, and what filename to use for the emailed file.
Previous versions of Stonefield Query create a report as a PDF file when emailing the report to someone. You can now specify the type of file used as an attachment.
You can now specify that each group in a report should be output to a separate file or email and that the email address should come from a field in the report itself. This can be used, for example, to email invoices to customers; the report is grouped by customer name and includes the customer's email address, so each customer's records are emailed to them.
You can now sort fields in database order or alphabetical order in Step 2 of the report wizards.
You can now tell Stonefield Query to display in the Tables drop-down list only those tables related to tables already appearing in the selected list.
Reports are now stored as export files with an SFX extension in a folder structure that exactly matches the folders in the Reports Explorer.
The new Send summary queries to database engine setting in the Options dialog allows you to specify whether Stonefield Query or the database engine does data summarization. This may significantly improve the performance of certain types of reports.
The new Run report with no records option in Step 5 of the report wizards and the Options page in the Reports Explorer allows you to run a report when there are no records that match your conditions.

Stonefield Query for Sage Accpac ERP Version 3.3

2009-05-13T15:20:00.001-06:00

We released version 3.3 of Stonefield Query for Sage Accpac ERP today. The list of new and enhanced features in version 3.3 is extensive; see the online help for complete details. Here are the major new features.

Report Designer

The new Formula Editor allows you to create your own formulas without using the Advanced Report Designer or customizing the data dictionary.
The new Show percentage of total option in the Format page of the Field Properties dialog automatically adds a new column to the report showing the percentage that the field is of the subtotal in detail lines, of the next level of grouping in subgroup footers, and of the grand total for group footers.
Turn on the new Show totals in group headers option in Step 5 of the Quick Report Wizard and the Options page of the Reports Explorer to display group totals in the group header rather than the group footer.
Stonefield Query now supports Crystal Reports reports. You can add them to Stonefield Query using the External Report Wizard.
The Preview window is no longer modal, meaning you can open multiple instances. Also, the new Preview reports in tabbed pages setting in the Options dialog allows you to determine whether different preview windows are used when you run more than one report or whether the reports appear as different tabs in the same preview window.
There are several new output options available. You can specify that a timestamp is added to the file created to prevent overwriting existing files, that the file emailed to someone shouldn't be deleted after the email is sent, and what filename to use for the emailed file.
Previous versions of Stonefield Query create a report as a PDF file when emailing the report to someone. You can now specify the type of file used as an attachment.
You can now specify that each group in a report should be output to a separate file or email and that the email address should come from a field in the report itself. This can be used, for example, to email invoices to customers; the report is grouped by customer name and includes the customer's email address, so each customer's records are emailed to them.
You can now sort fields in database order or alphabetical order in Step 2 of the report wizards.
You can now tell Stonefield Query to display in the Tables drop-down list only those tables related to tables already appearing in the selected list.
Reports are now stored as export files with an SFX extension in a folder structure that exactly matches the folders in the Reports Explorer.
The new Send summary queries to database engine setting in the Options dialog allows you to specify whether Stonefield Query or the database engine does data summarization. This may significantly improve the performance of certain types of reports.
The new Run report with no records option in Step 5 of the report wizards and the Options page in the Reports Explorer allows you to run a report when there are no records that match your conditions.

Sage Accpac Specific

New fields in Account Fiscal Sets (General Ledger) allow you to report on the balance for each period.
You can now report on the Fiscal Calendars table (General Ledger).

Stonefield Query Version 3.3 Build 3418

2009-05-12T14:32:00.001-06:00

We posted an update to Stonefield Query version 3.3 today. It has the following new features and bug fixes:

You can now use expressions in subtable filters and the relationship for complex joins. Do this by preceding the expression with "=" or enclosing the expression in curly braces ({ and }).
A new ReportEngine.SetupCrystalReport event script allows you to customize the set up of a Crystal report object just prior to running the report.
Months displayed when dates are formatted to display as Month are now localized.
A message box that displayed if you used the dynamic font style feature in a report was removed.
A bug that caused an error when bringing up the About dialog for an unactivated Configuration Utility was fixed.
Stonefield Query now uses 18 decimals places when retrieving data from the database to prevent decimal values from being rounded.
A bug that caused an error when reactivating an expired Configuration Utility license was fixed.
You no longer get an error if fields are included in the group header of a summary report (for example, because "Include all fields in same table in group header" is turned on) and you have a field with "Show percentage of total" turned on.
A bug that caused an error when Stonefield Query is run for the first time and a second user runs it without the first user closing it was fixed.
A bug that caused the wrong record to be used when evaluating expressions in the subject or body of an email when "Output each group as a separate email" is turned on was fixed.
The recipient for an email is blanked at the end of a report run when "Output each group as a separate email" and "Get email address from" are turned on.
A bug that caused an error when using a DateTime field formatted as Week in the column of a cross-tab report was fixed.
A bug that caused an error when there's a field with "Show % of total" turned on, "Run report with no records" is turned on, and the filter condition is such that there are no records was fixed.
The column headings in a cross-tab report created in earlier versions of Stonefield Query no longer display " / / ".
A bug that caused an error when a field has "Show percentage of total" turned on and you sort on that field in descending order was fixed.
A bug that caused an error when a calculated date field is displayed as Week in a report with "Summary report" turned off was fixed.
The percentage value for a field with "Show percentage of total" turn on no longer appears formatted as the field (e.g. $999,999.99) but as expected (that is, 999.9%) when the report is converted to an advanced layout report.
A bug that caused an error when using a subtable with VFP data was fixed.
You no longer get an error in the Configuration Utility editing a field that has “Display field from related table” turned on and the name of the field to display from the related table has delimiters (for example, “DESC”).
Dragging a report or folder to a blank part of the reports list in the Reports Explorer no longer makes the report or folder disappear (it was a display issue only in previous versions: the report or folder reappeared the next time you started Stonefield Query).
The default setting for the “Preview reports in tabbed pages” option in the Options dialog is now turned on so it’s consistent with the behavior in version 3.2.
A bug that caused an error if you have a report with a numeric field with "Show percentage of total" turned on and a date field formatted to display as Month or Week was fixed.
Negative percentage values for fields with "Show percentage of total" turned on are now formatted properly.
Grouping on a field that’s in the same table as another grouped field that has “Include all fields in same table in group header” turned on now works properly.
Stonefield Query no longer gives a warning if you try to output more than 65,536 rows to a Microsoft Excel 2007 spreadsheet, since the limit is 1,048,576 (you will get a warning if you exceed that number). It will automatically change the file extension to “XLSX” because Excel requires that.

Stonefield Query 3.3 Video

2009-05-07T09:14:00.001-06:00

We posted a 25-minute video showing some of the new features in Stonefield Query version 3.3.

Stonefield Query SDK Version 3.3 Released

2009-05-04T16:50:00.001-06:00

We released version 3.3 of the Stonefield Query SDK today. Other versions, such as for Sage Accpac ERP, Sage Pro, ACT!, and so on will be released over the next few weeks; watch our blog for release information.

The list of new and enhanced features in version 3.3 is extensive; see the online versions of the end-user help and SDK help for complete details. Here are the major new features.

Report Designer

The new Formula Editor allows you to create your own formulas without using the Advanced Report Designer or customizing the data dictionary.
The new Show percentage of total option in the Format page of the Field Properties dialog automatically adds a new column to the report showing the percentage that the field is of the subtotal in detail lines, of the next level of grouping in subgroup footers, and of the grand total for group footers.
Turn on the new Show totals in group headers option in Step 5 of the Quick Report Wizard and the Options page of the Reports Explorer to display group totals in the group header rather than the group footer.
Stonefield Query now supports Crystal Reports reports. You can add them to Stonefield Query using the External Report Wizard.
The Preview window is no longer modal, meaning you can open multiple instances. Also, the new Preview reports in tabbed pages setting in the Options dialog allows you to determine whether different preview windows are used when you run more than one report or whether the reports appear as different tabs in the same preview window.
There are several new output options available. You can specify that a timestamp is added to the file created to prevent overwriting existing files, that the file emailed to someone shouldn't be deleted after the email is sent, and what filename to use for the emailed file.
Previous versions of Stonefield Query create a report as a PDF file when emailing the report to someone. You can now specify the type of file used as an attachment.
You can now specify that each group in a report should be output to a separate file or email and that the email address should come from a field in the report itself. This can be used, for example, to email invoices to customers; the report is grouped by customer name and includes the customer's email address, so each customer's records are emailed to them.
You can now sort fields in database order or alphabetical order in Step 2 of the report wizards.
You can now tell Stonefield Query to display in the Tables drop-down list only those tables related to tables already appearing in the selected list.
Reports are now stored as export files with an SFX extension in a folder structure that exactly matches the folders in the Reports Explorer.
The new Send summary queries to database engine setting in the Options dialog allows you to specify whether Stonefield Query or the database engine does data summarization. This may significantly improve the performance of certain types of reports.
The new Run report with no records option in Step 5 of the report wizards and the Options page in the Reports Explorer allows you to run a report when there are no records that match your conditions.

SDK

The data dictionary now supports versioning. This is useful if tables and fields were added to or removed from the database between versions and you have some users using an older version and some using a newer version but they're all using the latest version of your customized Stonefield Query. To prevent users from selecting tables and fields that may not exist in their version of the database, you can specify the version number for each table and field that doesn't exist in all versions.
Stonefield Query now supports scripting in VB.Net and C#.
Like us, you may have a blog or news feed describing changes to your application. However, most users don't read blogs. So, Stonefield Query now includes a built-in news reader. If you fill in the URL for News Feeds configuration setting with the URL for an RSS feed, the news reader is available to your users.
The Create Help Files function in the Configuration Utility now runs Stonefield Query and automates the generation of all customized screen shots, so there's no need to do that manually any more. That can save you a considerable amount of time.
You can now refresh a single database rather than all databases if you wish by selecting the Refresh Database function from the Objects or shortcut menus.
The new Number of Days for Demo Version configuration setting allows you to create a shorter demo period than the default 30 days if you wish.
The code window opened when you right-click the code for a script and choose Zoom now supports find capability. Right-click in the code window and choose Find from the shortcut menu. Also, when you choose Build Expression from the shortcut menu, the Stonefield Query Expression Builder is now used.
A new Test button in the database properties page of the Configuration Utility allows you to test that the connection settings are correct.

Stonefield Software Inks Australian Distribution Deal with Sage

2009-04-23T09:40:00.001-06:00

Stonefield Software has signed a distribution deal with Sage Business Solutions to expand the distribution of our popular database reporting software, Stonefield Query, to the Australian, NZ and Pacific Island Market. The new agreement builds on our dramatic growth as the premier end-user focused database reporting software solution in the U.S. and Canada, and expands into the Australian and New Zealand region with a prospective market share of tens of thousands of Sage Software users.

For details, see our press release page or press release itself.

Stonefield Query for Sage Accpac ERP Version 3.2 Build 3362

2009-03-27T10:53:00.001-06:00

We posted an updated version of Stonefield Query for Sage Accpac ERP today with the following changes.

A new Extended Amount Less Discount field in Order Entry Invoice Details, Credit Note Details, Combined Invoice & Credit Note Details, and Order Details shows the net amount of the transaction.
There are now direct relationships between Accounts Receivable Documents and Order Entry Invoices, Credit Notes, and Combined Invoices & Credit Notes, so reporting on these tables works better.
A bug that caused an error when reporting on both Invoices and Invoice Details in Order Entry was fixed.
A bug that caused an error when reporting on Combined Invoices & Credit Notes and Combined Invoice & Credit Note Details tables in Order Entry was fixed.
A bug that prevented exclusion filters from working under some unique circumstances was fixed.
A bug that prevented GROUP BY and ORDER BY clauses from being handled properly in custom SQL statements was fixed.
A bug that caused numeric values to appear without any decimals when the first value in the result set is null was fixed.
A bug that caused an error when opening or closing the preview window under rare circumstances was fixed.

Stonefield Query Version 3.2 Build 3362

2009-03-16T12:21:00.001-06:00

We posted an updated versions of the Stonefield Query SDK today with the following changes:

The Test button for relationships in the Configuration Utility now respects the setting of the Include Joins in the WHERE Clause configuration setting.
Stonefield Query user names and passwords, database connection information, and email information are no longer decrypted into variables in memory so they never exist in clear text anywhere, including memory dumps or error logs.
The Configuration Utility now supports databases with a period in the name (for example, "My.Database").
A bug that prevented exclusion filters from working under some unique circumstances was fixed.
A bug that prevented GROUP BY and ORDER BY clauses from being handled properly in custom SQL statements was fixed.
A bug that prevented enumerated fields that contain illegal characters (such as a dash) from working properly was fixed.
A bug that caused numeric values to appear without any decimals when the first value in the result set is null was fixed.
A bug that caused the SQL statement for a report to be truncated when one or more of the tables is a virtual table was fixed.
Stonefield Query now properly handles custom SQL statements involving subtables.
A bug that caused an error when opening or closing the preview window under rare circumstances was fixed.
A bug that caused an error when adding a VFP database to the Configuration Utility was fixed.
A bug that caused an error when running a report involving subtables in a VFP database was fixed.