AccountMate 7.6 Now Supported

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

Stonefield Query Version 3.2 Build 3321

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

All Versions

• Microsoft Word documents generated from Stonefield Query now have the proper margins and orientation.
• Stonefield Query now properly handles custom SQL statements with spaces after commas between fields and is no longer case-sensitive for field and table names.
• Linking on non-character fields is now supported.
• Exporting a folder that contains a folder that contains reports without expanding all levels of folders in the Export dialog no longer gives an error.
• Passing less than 10 values for Is One Of conditions when calling Stonefield Query from the command line no longer causes a problem.
• Custom SQL statements with SUM() no longer fail. Also, the order of ORDER BY and GROUP BY clauses is no longer important.
• The Is One Of condition for numeric fields no longer shows "0" for values you do not enter; for example, specifying only 1 and 2 as the values now displays the condition as "Field Is One of 1,2" rather than "Field Is One of 1,2,0,0,0,0,0,0,0,0".
• The default location to export reports to is no longer the program folder but your Documents folder.
• Outputting to a table now outputs variable-length character fields (also known as Varchar) as character rather than memo fields.
• A summary report with multiple groups and sorted on a summed field now displays properly sorted.
• You no longer get an error if a grouped field is listed after a calculated field in Step 2 of the Quick Report Wizard for a summary report.
• You no longer get an error filtering on certain types of calculated fields that don't appear in the report.
• Stonefield Query now supports online activation and maintenance renewal when a proxy server is used.
• The Analyze Database function now adds new tables and fields in the data dictionary to the "favorites" set.

SDK

• The new Active property of the Database object allows you to programmatically disable a database under certain conditions, such as if the database is optional and isn't available for this particular user.
• The Test button on the relations page of the Configuration Utility now works with tables in different databases and with database engines that don't support the SQL TOP clause.
• The GetFolders method of the ReportEngine object now returns all folders when you don't pass a user name and password to the LoadProject method of an SQProxy object.
• Several bugs in the ImportFF and ImportFFXML utility functions were fixed (including updating reports security so they are available to everyone) and they work more reliably with different types of reports.
• If an error occurs when running a report using SQProxy, an error is raised in the calling application, so you should use error handing in your applications using SQProxy. Also, if an error occurs when calling LoadProject, ErrorMessage contains information about the error and the new ErrorCode property returns the same value SFQuery.EXE returns when running a report from the command line.
• Calculated date fields are now handled properly when used in the column of cross-tab reports.
• Returning an empty string from DataEngine.FinalizeSQLStatement tells Stonefield Query not to continue running the report.
• Stonefield Query now works with the SQLite database engine.

Sage Accpac ERP

• Uni Sales Analysis is now supported.
• All Rate Operator fields now use the same list of possible values.
• The Audit Time fields now display times as HH:MM:SS.
• The relationship between Inventory Control Transfer Headers and Transfer Details was fixed.
• The Payroll Employee Tax Information table is now available for reporting.
• "Refund" is now available as a value for Document Type and "Debit Note - Advance Claim Credit" and "Refund - Posted" are available for Transaction Type in Accounts Receivable Documents.
• ICILOC now appears as "Location Item Details" since that's the type of information contained in that table.
• Most relations from tables to Inventory Control Locations were changes to Location Item Details instead.
• A bug that caused fields in Inventory Control Sales Statistics to appear as if they came from Transaction Statistics was fixed.

Sage Pro ERP

• Several bugs in the Import ACCPAC Report Writer Reports function were fixed (including updating reports security so they are available to everyone) and it works more reliably with different types of reports.
• Numeric fields now use 999,999,999.99 as the format in the Advanced Report Designer rather than 9999999999999999999.999999.
• The caption of the ICISUM was changed to Inventory Sales/Usage History File since both it and ICHIST had same caption (Inventory History File).
• There's now a direct relationship between the Inventory Summary File and the Inventory Master File. Also, there are new Year and Period fields in the Inventory Summary File to make filtering on, for example, a specific year easier.
• Filters on certain values of certain fields, such as Type of Invoice (in the Accounts Receivable Invoice Transaction File) equals Normal Invoice, now work properly.
• Inventory History File is no longer listed for Sage Pro ERP version 7.5 or later since that table was removed.
• Errors in the relationships between the GL Posted Transaction Headers and Details Files and between GL Unposted Transaction Headers and Details Files were fixed.
• Drop Shipment is now available as one of the choices for Type of PO in the PO Transaction File.