Stonefield Query for Sage Timberline Office 3.2 Released

Stonefield Software Inc. is pleased to announce the release of version 3.2 of Stonefield Query for Sage Timberline Office.

Stonefield Query is a user-friendly report writing, business intelligence, query, and data mining tool. With its intuitive wizard driven design, Stonefield Query makes report writing a snap for even the most novice user. Elegant and persuasive reports can be created in minutes with little or no technical knowledge required.

Some of the new features in this release are:

• New field: Transaction Amount, is available in the GL Transaction table. This field contains the amount of both debit and credit transactions in the same column.
• New function: GetAgingDate(), is now available. This function helps make creating an aging report easier, by prompting the report user for a date, and then evaluating to that date for the report run. The function can be used in expressions in the advanced report designer to set up the various aging columns.
• New options: The tools->options dialog has several new options. You can now decide whether or not you want to be prompted for which field you want to join to the GL Account table on, in cases where fields from GL Account are involved in the report. Additionally, you can now decide whether you want to see Account Numbers instead of Account Descriptions.
• New relationships: Several new cross-module relationships are now available, which include AR Customer to Billing Invoice, and Job Cost Job to Project Manangement Job.
• Exclusion filters: this allows you to query on the absence of data, such as "give me a list of customers I didn't contact last year" or "give me a list of everyone who did not buy product X". Behind the scenes, Stonefield Query generates a NOT IN subquery, but from the end-user's perspective, it's just as easy as creating a normal filter.
• Modeless report wizards: the report wizards are no longer modal, so you can modify more than one report at a time.
  Single ask-at-runtime dialog: all ask-at-runtime filter conditions now appear in a single, wizard-like dialog rather than one dialog per condition.
• Workstation installer: Stonefield Query now has a separate WSSetup.EXE installer, installed by Setup.EXE, that does workstation installations with the minimum of user interaction.
• More grouping options: you can now specify that a non-grouped field should be included in the group header for another field, you can have all fields in the group header on a single line rather than stacked on separate lines, and all fields in the group header now appear in summary reports.
• Multi-line headings: many fields now have multi-line headings so they don't take up as much room in a report, and you can change field headings to use multiple lines.
• Customize Report Wizard for all report types: all report wizards now have an Advanced button, allowing access to TOP N, custom SQL statements, and other features.
  

There are dozens of other new features and bug fixes. For more information about version 3.2, please see the What's New in This Version topic in the online documentation.

Stonefield Query for ACT! 3.2 Released

Stonefield Software Inc. is pleased to announce the release of version 3.2 of Stonefield Query for ACT!.

Stonefield Query is a user-friendly report writing, business intelligence, query, and data mining tool. With its intuitive wizard driven design, Stonefield Query makes report writing a snap for even the most novice user. Elegant and persuasive reports can be created in minutes with little or no technical knowledge required.

Some of the new features in this release are:

• Swiftpage support: Stonefield Query now has specific support for reporting on Swiftpage data stored in an ACT! database.
• Navigate ACT! from Query reports: Stonefield Query reports now support links to navigate the ACT! interface. With these links in a report, clicking a contact, company, or group in a report will display that item in ACT! itself.
• Custom subentities support: Support has been added for ACT!'s new custom subentities feature, which was added in ACT! version 10.02.
• New tables: The new tables Opportunity History and Logon History have been added, for ACT! databases supporting these items.
• Stonefield Query items in ACT! menus: Stonefield Query is now able to add menu items to ACT!'s interface. Menu items can be added to launch Query, or to run specific Query reports.
• Import ACT! Advanced Queries: Advanced Queries from ACT! 2005 and later can now be imported as Stonefield Query reports.
• New sample reports: More than 20 new sample reports have been added, bringing the total number to over 160.
• Exclusion filters: this allows you to query on the absence of data, such as "give me a list of customers I didn't contact last year" or "give me a list of everyone who did not buy product X". Behind the scenes, Stonefield Query generates a NOT IN subquery, but from the end-user's perspective, it's just as easy as creating a normal filter.
• Modeless report wizards: the report wizards are no longer modal, so you can modify more than one report at a time.
• Single ask-at-runtime dialog: all ask-at-runtime filter conditions now appear in a single, wizard-like dialog rather than one dialog per condition.
• Workstation installer: Stonefield Query now has a separate WSSetup.EXE installer, installed by Setup.EXE, that does workstation installations with the minimum of user interaction.
• More grouping options: you can now specify that a non-grouped field should be included in the group header for another field, you can have all fields in the group header on a single line rather than stacked on separate lines, and all fields in the group header now appear in summary reports.
• Multi-line headings: many fields now have multi-line headings so they don't take up as much room in a report, and you can change field headings to use multiple lines.
• Customize Report Wizard for all report types: all report wizards now have an Advanced button, allowing access to TOP N, custom SQL statements, and other features.

There are dozens of other new features and bug fixes. For more information about version 3.2, please see the What's New in This Version topic in the online documentation.

Stonefield Query Version 3.2 Update

We posted updated versions of the Stonefield Query SDK, Stonefield Query for Sage Accpac ERP, Stonefield Query for Sage Pro ERP, Stonefield Query for GoldMine, and Stonefield Query for HEAT today with the following changes.

All Versions

• Thanks to Boudewijn Lutgerink, the Dutch version of Stonefield Query is now current with version 3.2.
• An error that occurred if you ran a report that uses the RunSQL function in the Advanced Report Designer was fixed. Also, editing a field using that function no longer executes the function.
• A bug that caused an error if you created a new report then right-clicked in the Reports Explorer on a folder was fixed.
• A bug that caused the Favorites folder to appear as "Favorites" in some dialogs rather than the localized equivalent when the language is set to something other than English was fixed.
• Stonefield Query now has consistent behavior if you try closing it by clicking the Close button, right-clicking and choosing Exit, or choosing Exit from the File menu when a report wizard is open.
• You no longer get an error if you press Esc during the "processing records" step when running a long report.

Sage Pro

• The Analyze Database function now works correctly with Sage Pro databases.
• The Pay Priority field in the Accounts Payable Master File in the Sage Pro version now supports a value of 0 for Payment Hold.
• Stonefield Query now supports the case where you've customized the SQL statement for a report and used code that includes multiple SQL statements.
• It now does a better job when updating from an older ACCPAC Query version.

Sage Accpac

• Date fields in the Sage Accpac version now display as true date values rather than numeric values.
• Some joins were optimized in the Sage Accpac data dictionary, making some reports (especially those involving Accounts Receivable Items) faster.
• A bug that prevented reports involving Order Entry Invoices and Invoice Details from working correctly when you have more than one data dictionary was fixed.
• It now does a better job when updating from an older ACCPAC Query version.

SDK

• A bug that gave an error when creating help files for a project when you're running the Configuration Utility on Windows Vista or Windows XP using a limited user account was fixed. Also, it now gives a warning rather than an unexpected error if the folder for the help files is read-only.
• The update process now displays the correct name of the updater application if you've changed it when the user runs the Check for Updates function and an update is available on a Windows Vista system.
• Stonefield Query now supports updating project components, such as the data dictionary files.

Stonefield Query for HEAT 3.2 Released

Stonefield Software Inc. is pleased to announce the release of version 3.2 of Stonefield Query for HEAT.

Stonefield Query is a user-friendly report writing, business intelligence, query, and data mining tool. With its intuitive wizard driven design, Stonefield Query makes report writing a snap for even the most novice user. Elegant and persuasive reports can be created in minutes with little or no technical knowledge required.

Some of the new features in this release are:

• The performance of queries involving a filter on a date field is now dramatically faster than before. However, this will require you to change any dynamic Date expression filters to use the new built-in HEATDate function.
• New Elapsed Hours (Based on Help Desk Hours) and Elapsed Days/Hours (Based on Help Desk Hours) fields in the Call Logging and Call Assignments tables show the elapsed hours for a call taking the hours of operation of your Helpdesk (rather than total elapsed time) into account.
• You now have the option of choosing a calendar type in the Tools=>Options menu if you have multiple "Help Desk Hours of Operation" calendars created for your HEAT database. This data is used when calculating the Elapsed Hours (Based on Help Desk Hours) and Elapsed Days/Hours (Based on Help Desk Hours) fields in the Call Logging and Call Assignments tables.
• Exclusion filters: this allows you to query on the absence of data, such as "give me a list of customers I didn't contact last year" or "give me a list of everyone who did not buy product X". Behind the scenes, Stonefield Query generates a NOT IN subquery, but from the end-user's perspective, it's just as easy as creating a normal filter.
• Modeless report wizards: the report wizards are no longer modal, so you can modify more than one report at a time.
• Single ask-at-runtime dialog: all ask-at-runtime filter conditions now appear in a single, wizard-like dialog rather than one dialog per condition.
• Workstation installer: Stonefield Query now has a separate WSSetup.EXE installer, installed by Setup.EXE, that does workstation installations with the minimum of user interaction.
• More grouping options: you can now specify that a non-grouped field should be included in the group header for another field, you can have all fields in the group header on a single line rather than stacked on separate lines, and all fields in the group header now appear in summary reports.
• Multi-line headings: many fields now have multi-line headings so they don't take up as much room in a report, and you can change field headings to use multiple lines.
• Customize Report Wizard for all report types: all report wizards now have an Advanced button, allowing access to TOP N, custom SQL statements, and other features.

There are dozens of other new features and bug fixes. For more information about version 3.2, please see the What's New in This Version topic in the online documentation.

Stonefield Query for GoldMine 3.2 Released

Stonefield Software Inc. is pleased to announce the release of version 3.2 of Stonefield Query for GoldMine.

Stonefield Query is a user-friendly report writing, business intelligence, query, and data mining tool. With its intuitive wizard driven design, Stonefield Query makes report writing a snap for even the most novice user. Elegant and persuasive reports can be created in minutes with little or no technical knowledge required.

Some of the new features in this release are:

• Exclusion filters: this allows you to query on the absence of data, such as "give me a list of customers I didn't contact last year" or "give me a list of everyone who did not buy product X". Behind the scenes, Stonefield Query generates a NOT IN subquery, but from the end-user's perspective, it's just as easy as creating a normal filter.
• Modeless report wizards: the report wizards are no longer modal, so you can modify more than one report at a time.
• Single ask-at-runtime dialog: all ask-at-runtime filter conditions now appear in a single, wizard-like dialog rather than one dialog per condition.
• Workstation installer: Stonefield Query now has a separate WSSetup.EXE installer, installed by Setup.EXE, that does workstation installations with the minimum of user interaction.
• More grouping options: you can now specify that a non-grouped field should be included in the group header for another field, you can have all fields in the group header on a single line rather than stacked on separate lines, and all fields in the group header now appear in summary reports.
• Multi-line headings: many fields now have multi-line headings so they don't take up as much room in a report, and you can change field headings to use multiple lines.
• Customize Report Wizard for all report types: all report wizards now have an Advanced button, allowing access to TOP N, custom SQL statements, and other features.

There are dozens of other new features and bug fixes. For more information about version 3.2, please see the What's New in This Version  topic in the online documentation.

Stonefield Query for Sage Pro ERP Version 3.2 Released

Stonefield Software Inc. is pleased to announce the release of version 3.2 of Stonefield Query for Sage Pro ERP.

Stonefield Query is a user-friendly report writing, business intelligence, query, and data mining tool. With its intuitive wizard driven design, Stonefield Query makes report writing a snap for even the most novice user. Elegant and persuasive reports can be created in minutes with little or no technical knowledge required.

Stonefield Query for Sage Pro ERP was formerly available from Sage Software as ACCPAC Query. Since ACCPAC Query was returned to us, we've rebranded it as Stonefield Query and synchronized the version number with our other customized versions.

Some of the new features in this release are:

• Charting: you can now quickly create charts and graphs such as these sales by salesperson charts in just a few mouse clicks:

 

• Drilldowns: you can, for example, create a report that when you click on the customer name drills down to show the orders for that customer.
• Exclusion filters: this allows you to query on the absence of data, such as "give me a list of customers I didn't contact last year" or "give me a list of everyone who did not buy product X". Behind the scenes, Stonefield Query generates a NOT IN subquery, but from the end-user's perspective, it's just as easy as creating a normal filter.
• Modeless report wizards: the report wizards are no longer modal, so you can modify more than one report at a time.
• Single ask-at-runtime dialog: all ask-at-runtime filter conditions now appear in a single, wizard-like dialog rather than one dialog per condition.
• Workstation installer: Stonefield Query now has a separate WSSetup.EXE installer, installed by Setup.EXE, that does workstation installations with the minimum of user interaction.
• More grouping options: you can now specify that a non-grouped field should be included in the group header for another field, you can have all fields in the group header on a single line rather than stacked on separate lines, and all fields in the group header now appear in summary reports.
• Multi-line headings: many fields now have multi-line headings so they don't take up as much room in a report, and you can change field headings to use multiple lines.
• Eliminate tables and fields you don't use: unless you use every single feature in Accpac (and who does?), you see a lot of tables and fields in Stonefield Query that don't contain meaningful data. Use the Analyze Database function to hide things you don't care about.
• Customize Report Wizard for all report types: all report wizards now have an Advanced button, allowing access to TOP N, custom SQL statements, and other features.

There are dozens of other new features and bug fixes. For more information about version 3.2, please see the What's New in This Version topic in the online documentation.

Stonefield Query for Sage Accpac ERP Version 3.2 Released

Stonefield Software Inc. is pleased to announce the release of version 3.2 of Stonefield Query for Sage Accpac ERP.

Stonefield Query is a user-friendly report writing, business intelligence, query, and data mining tool. With its intuitive wizard driven design, Stonefield Query makes report writing a snap for even the most novice user. Elegant and persuasive reports can be created in minutes with little or no technical knowledge required.

Stonefield Query for Sage Accpac ERP was formerly available from Sage Software as ACCPAC Query. Since ACCPAC Query was returned to us, we've rebranded it as Stonefield Query and synchronized the version number with our other customized versions.

Some of the new features in this release are:

• Charting: you can now quickly create charts and graphs such as these sales by salesperson charts in just a few mouse clicks:

• Drilldowns: you can, for example, create a report that when you click on the customer name drills down to show the orders for that customer.
• Exclusion filters: this allows you to query on the absence of data, such as "give me a list of customers I didn't contact last year" or "give me a list of everyone who did not buy product X". Behind the scenes, Stonefield Query generates a NOT IN subquery, but from the end-user's perspective, it's just as easy as creating a normal filter.
• Modeless report wizards: the report wizards are no longer modal, so you can modify more than one report at a time.
• Single ask-at-runtime dialog: all ask-at-runtime filter conditions now appear in a single, wizard-like dialog rather than one dialog per condition.
• Workstation installer: Stonefield Query now has a separate WSSetup.EXE installer, installed by Setup.EXE, that does workstation installations with the minimum of user interaction.
• More grouping options: you can now specify that a non-grouped field should be included in the group header for another field, you can have all fields in the group header on a single line rather than stacked on separate lines, and all fields in the group header now appear in summary reports.
• Multi-line headings: many fields now have multi-line headings so they don't take up as much room in a report, and you can change field headings to use multiple lines.
• Eliminate tables and fields you don't use: unless you use every single feature in Accpac (and who does?), you see a lot of tables and fields in Stonefield Query that don't contain meaningful data. Use the Analyze Database function to hide things you don't care about.
• Customize Report Wizard for all report types: all report wizards now have an Advanced button, allowing access to TOP N, custom SQL statements, and other features.

There are dozens of other new features and bug fixes. For more information about version 3.2, please see the What's New in This Version topic in the online documentation.

Stonefield Query SDK Version 3.2 Released

Stonefield Software Inc. is pleased to announce the release of version 3.2 of the Stonefield Query SDK.

Stonefield Query is a user-friendly report writing, business intelligence, query, and data mining tool. With its intuitive wizard driven design, Stonefield Query makes report writing a snap for even the most novice user. Elegant and persuasive reports can be created in minutes with little or no technical knowledge required.

You can use the Stonefield Query SDK to create your own custom reporting solutions for nearly any type of data. Stonefield Query supports Microsoft SQL Server, Oracle, MySQL, DB2, Sybase, Pervasive, Access, FoxPro, and Progress just to name a few!

Some of the new features in this release are:

• Exclusion filters: this allows you to query on the absence of data, such as "give me a list of customers I didn't contact last year" or "give me a list of everyone who did not buy product X". Behind the scenes, Stonefield Query generates a NOT IN subquery, but from the end-user's perspective, it's just as easy as creating a normal filter.
• Stand-alone windows: Stonefield Query no longer has a "background" window. Instead, each window appears directly on the user's Windows desktop. This makes it easier to have Stonefield Query appear to be integrated with your application.
• Modeless report wizards: the report wizards are no longer modal, so you can modify more than one report at a time.
• Single ask-at-runtime dialog: all ask-at-runtime filter conditions now appear in a single, wizard-like dialog rather than one dialog per condition.
• Workstation installer: Stonefield Query now has a separate WSSetup.EXE installer, installed by Setup.EXE, that does workstation installations with the minimum of user interaction.
• More grouping options: you can now specify that a non-grouped field should be included in the group header for another field, you can have all fields in the group header on a single line rather than stacked on separate lines, and all fields in the group header now appear in summary reports.
• Multi-line headings: you can define multiple line headings for fields in the Configuration Utility and the user can change field headings to use multiple lines.
• Customize Report Wizard for all report types: all report wizards now have an Advanced button, allowing access to TOP N, custom SQL statements, and other features.

There are dozens of other new features and bug fixes. For more information about version 3.2, please see the What's New in This Version  topic in the online SDK documentation for changes in the Configuration Utility and the What's New in This Version topic in the online end-user documentation for changes in the Report Designer.