Stonefield Query for HEAT version 4.2

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

• You can now edit formulas from Step 2 in the report wizards. When a formula is selected, click the Edit Formula button to edit it. Otherwise, that button appears as "New Formula", so clicking it creates a new formula.
• Formulas now appear in report wizards with "[Formula]" after the name so you can distinguish them from real fields.
• You can now specify the order that a formula appears in its table when fields are displayed in table order. This is useful if you want a formula to appear somewhere other than at the end of the list of fields.
• You can now specify the number of rows a dashboard has. For example, if there are four charts in a dashboard and you specify two rows, the dashboard will have two rows of two charts each.
• Two new templates are available:
  • Modern: this template has alternating light and dark rounded rectangles in the detail band and a blue rounded rectangle for column headers.
  • Modern with Title: this template is similar to Modern but with a title page showing the report name, comment, user, date, and filter.

  To add these to the list of available templates, choose Template Editor from the Tools menu, click Import, and select these templates from the Sample Templates folder.

• Objects in templates have a new Center option, which is useful for images such as logos that you want to be centered horizontally on the page.
• Stonefield Query can now automatically sum numeric fields when you add them to a report. Turn on the Automatically sum numeric fields setting in the Options dialog to use this feature.
• The Format page of the Field Properties dialog of the Advanced Report Designer now has a Display date only setting that works like the same setting in the Properties dialog of the report wizards: turn this setting on to display the date only or turn it off to display the date and time.
• You can now specify whether missing date values are included in a chart when a date field is used in as the category (X-axis) field.
• The License Manager now includes a Copy button to copy the selected serial number to the Clipboard. This makes it easier to specify your serial number when requesting technical support.
• You now get a warning if you try to schedule a report that has ask-at-runtime filter conditions, since that prevents a scheduled report from running.
• Because exclude filter conditions are often erroneously used in place of a normal "not equals" filter (for example, you want a list of customers who aren't in Germany and use an exclude condition of Country equals Germany rather than the correct way, with a normal filter condition of Country does not equal Germany), you now get a warning if you try to create an exclude condition of this type, although that doesn't prevent you from using it.
• Most cross-tab reports run faster now.
• You can now output cross-tab reports that have Show Change or Show % Change turned on to Microsoft Excel, CVS, or PivotTable files even when the report can't be previewed or printed because it has too many columns.
• Stonefield Query starts up faster than before.
• The setting of the "display only directly related tables" button is no longer remembered because it was easy to miss that this option was turned on and then wonder why all of the tables weren't displayed.
• Turning on Use same options next time report is run on the Output page of the Reports Explorer now saves the selected printer if it isn't the default printer. This allows you to always print the report to the same printer, such as sending mailing labels to a label printer.
• You can now specify the name of a report to edit or that a report should be created with the New Report Wizard with command-line parameters.

Stonefield Query for AccountMate version 4.2

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

• Stonefield Query for AccountMate supports AccountMate for SQL 8.2 and AccountMate for LAN 7.4.
• You can now edit formulas from Step 2 in the report wizards. When a formula is selected, click the Edit Formula button to edit it. Otherwise, that button appears as "New Formula", so clicking it creates a new formula.
• Formulas now appear in report wizards with "[Formula]" after the name so you can distinguish them from real fields.
• You can now specify the order that a formula appears in its table when fields are displayed in table order. This is useful if you want a formula to appear somewhere other than at the end of the list of fields.
• You can now specify the number of rows a dashboard has. For example, if there are four charts in a dashboard and you specify two rows, the dashboard will have two rows of two charts each.
• Two new templates are available:
  • Modern: this template has alternating light and dark rounded rectangles in the detail band and a blue rounded rectangle for column headers.
  • Modern with Title: this template is similar to Modern but with a title page showing the report name, comment, user, date, and filter.

  To add these to the list of available templates, choose Template Editor from the Tools menu, click Import, and select these templates from the Sample Templates folder.

• Objects in templates have a new Center option, which is useful for images such as logos that you want to be centered horizontally on the page.
• Stonefield Query can now automatically sum numeric fields when you add them to a report. Turn on the Automatically sum numeric fields setting in the Options dialog to use this feature.
• The Format page of the Field Properties dialog of the Advanced Report Designer now has a Display date only setting that works like the same setting in the Properties dialog of the report wizards: turn this setting on to display the date only or turn it off to display the date and time.
• You can now specify whether missing date values are included in a chart when a date field is used in as the category (X-axis) field.
• The License Manager now includes a Copy button to copy the selected serial number to the Clipboard. This makes it easier to specify your serial number when requesting technical support.
• You now get a warning if you try to schedule a report that has ask-at-runtime filter conditions, since that prevents a scheduled report from running.
• Because exclude filter conditions are often erroneously used in place of a normal "not equals" filter (for example, you want a list of customers who aren't in Germany and use an exclude condition of Country equals Germany rather than the correct way, with a normal filter condition of Country does not equal Germany), you now get a warning if you try to create an exclude condition of this type, although that doesn't prevent you from using it.
• Most cross-tab reports run faster now.
• You can now output cross-tab reports that have Show Change or Show % Change turned on to Microsoft Excel, CVS, or PivotTable files even when the report can't be previewed or printed because it has too many columns.
• Stonefield Query starts up faster than before.
• The setting of the "display only directly related tables" button is no longer remembered because it was easy to miss that this option was turned on and then wonder why all of the tables weren't displayed.
• Turning on Use same options next time report is run on the Output page of the Reports Explorer now saves the selected printer if it isn't the default printer. This allows you to always print the report to the same printer, such as sending mailing labels to a label printer.
• You can now specify the name of a report to edit or that a report should be created with the New Report Wizard with command-line parameters.

Stonefield Query for ACT! version 4.2

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

• Several new sample reports have been added for ACT! 2010 and later databases.
• Stonefield Query now supports relationships between two subentites defined using TopLine Designer.
• You can now edit formulas from Step 2 in the report wizards. When a formula is selected, click the Edit Formula button to edit it. Otherwise, that button appears as "New Formula", so clicking it creates a new formula.
• Formulas now appear in report wizards with "[Formula]" after the name so you can distinguish them from real fields.
• You can now specify the order that a formula appears in its table when fields are displayed in table order. This is useful if you want a formula to appear somewhere other than at the end of the list of fields.
• You can now specify the number of rows a dashboard has. For example, if there are four charts in a dashboard and you specify two rows, the dashboard will have two rows of two charts each.
• Two new templates are available:
  • Modern: this template has alternating light and dark rounded rectangles in the detail band and a blue rounded rectangle for column headers.
  • Modern with Title: this template is similar to Modern but with a title page showing the report name, comment, user, date, and filter.
  To add these to the list of available templates, choose Template Editor from the Tools menu, click Import, and select these templates from the Sample Templates folder.
  
• Objects in templates have a new Center option, which is useful for images such as logos that you want to be centered horizontally on the page.
• Stonefield Query can now automatically sum numeric fields when you add them to a report. Turn on the Automatically sum numeric fields setting in the Options dialog to use this feature.
• The Format page of the Field Properties dialog of the Advanced Report Designer now has a Display date only setting that works like the same setting in the Properties dialog of the report wizards: turn this setting on to display the date only or turn it off to display the date and time.
• You can now specify whether missing date values are included in a chart when a date field is used in as the category (X-axis) field.
• The License Manager now includes a Copy button to copy the selected serial number to the Clipboard. This makes it easier to specify your serial number when requesting technical support.
• You now get a warning if you try to schedule a report that has ask-at-runtime filter conditions, since that prevents a scheduled report from running.
• Because exclude filter conditions are often erroneously used in place of a normal "not equals" filter (for example, you want a list of customers who aren't in Germany and use an exclude condition of Country equals Germany rather than the correct way, with a normal filter condition of Country does not equal Germany), you now get a warning if you try to create an exclude condition of this type, although that doesn't prevent you from using it.
• Most cross-tab reports run faster now.
• You can now output cross-tab reports that have Show Change or Show % Change turned on to Microsoft Excel, CVS, or PivotTable files even when the report can't be previewed or printed because it has too many columns.
• Stonefield Query starts up faster than before.
• The setting of the "display only directly related tables" button is no longer remembered because it was easy to miss that this option was turned on and then wonder why all of the tables weren't displayed.
• Turning on Use same options next time report is run on the Output page of the Reports Explorer now saves the selected printer if it isn't the default printer. This allows you to always print the report to the same printer, such as sending mailing labels to a label printer.
• You can now specify the name of a report to edit or that a report should be created with the New Report Wizard with command-line parameters.

Stonefield Query for Sage Accpac ERP version 4.2

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

• You can now edit formulas from Step 2 in the report wizards. When a formula is selected, click the Edit Formula button to edit it. Otherwise, that button appears as "New Formula", so clicking it creates a new formula.
• Formulas now appear in report wizards with "[Formula]" after the name so you can distinguish them from real fields.
• You can now specify the order that a formula appears in its table when fields are displayed in table order. This is useful if you want a formula to appear somewhere other than at the end of the list of fields.
• You can now specify the number of rows a dashboard has. For example, if there are four charts in a dashboard and you specify two rows, the dashboard will have two rows of two charts each.
• Two new templates are available:
  • Modern: this template has alternating light and dark rounded rectangles in the detail band and a blue rounded rectangle for column headers.
  • Modern with Title: this template is similar to Modern but with a title page showing the report name, comment, user, date, and filter.

  To add these to the list of available templates, choose Template Editor from the Tools menu, click Import, and select these templates from the Sample Templates folder.

• Objects in templates have a new Center option, which is useful for images such as logos that you want to be centered horizontally on the page.
• Stonefield Query can now automatically sum numeric fields when you add them to a report. Turn on the Automatically sum numeric fields setting in the Options dialog to use this feature.
• The Format page of the Field Properties dialog of the Advanced Report Designer now has a Display date only setting that works like the same setting in the Properties dialog of the report wizards: turn this setting on to display the date only or turn it off to display the date and time.
• You can now specify whether missing date values are included in a chart when a date field is used in as the category (X-axis) field.
• The License Manager now includes a Copy button to copy the selected serial number to the Clipboard. This makes it easier to specify your serial number when requesting technical support.
• You now get a warning if you try to schedule a report that has ask-at-runtime filter conditions, since that prevents a scheduled report from running.
• Because exclude filter conditions are often erroneously used in place of a normal "not equals" filter (for example, you want a list of customers who aren't in Germany and use an exclude condition of Country equals Germany rather than the correct way, with a normal filter condition of Country does not equal Germany), you now get a warning if you try to create an exclude condition of this type, although that doesn't prevent you from using it.
• Most cross-tab reports run faster now.
• You can now output cross-tab reports that have Show Change or Show % Change turned on to Microsoft Excel, CVS, or PivotTable files even when the report can't be previewed or printed because it has too many columns.
• Stonefield Query starts up faster than before.
• The setting of the "display only directly related tables" button is no longer remembered because it was easy to miss that this option was turned on and then wonder why all of the tables weren't displayed.
• Turning on Use same options next time report is run on the Output page of the Reports Explorer now saves the selected printer if it isn't the default printer. This allows you to always print the report to the same printer, such as sending mailing labels to a label printer.
• You can now specify the name of a report to edit or that a report should be created with the New Report Wizard with command-line parameters.

Stonefield Query for Sage Pro ERP version 4.2

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

• You can now edit formulas from Step 2 in the report wizards. When a formula is selected, click the Edit Formula button to edit it. Otherwise, that button appears as "New Formula", so clicking it creates a new formula.
• Formulas now appear in report wizards with "[Formula]" after the name so you can distinguish them from real fields.
• You can now specify the order that a formula appears in its table when fields are displayed in table order. This is useful if you want a formula to appear somewhere other than at the end of the list of fields.
• You can now specify the number of rows a dashboard has. For example, if there are four charts in a dashboard and you specify two rows, the dashboard will have two rows of two charts each.
• Two new templates are available:
  • Modern: this template has alternating light and dark rounded rectangles in the detail band and a blue rounded rectangle for column headers.
  • Modern with Title: this template is similar to Modern but with a title page showing the report name, comment, user, date, and filter.

  To add these to the list of available templates, choose Template Editor from the Tools menu, click Import, and select these templates from the Sample Templates folder.

• Objects in templates have a new Center option, which is useful for images such as logos that you want to be centered horizontally on the page.
• Stonefield Query can now automatically sum numeric fields when you add them to a report. Turn on the Automatically sum numeric fields setting in the Options dialog to use this feature.
• The Format page of the Field Properties dialog of the Advanced Report Designer now has a Display date only setting that works like the same setting in the Properties dialog of the report wizards: turn this setting on to display the date only or turn it off to display the date and time.
• You can now specify whether missing date values are included in a chart when a date field is used in as the category (X-axis) field.
• The License Manager now includes a Copy button to copy the selected serial number to the Clipboard. This makes it easier to specify your serial number when requesting technical support.
• You now get a warning if you try to schedule a report that has ask-at-runtime filter conditions, since that prevents a scheduled report from running.
• Because exclude filter conditions are often erroneously used in place of a normal "not equals" filter (for example, you want a list of customers who aren't in Germany and use an exclude condition of Country equals Germany rather than the correct way, with a normal filter condition of Country does not equal Germany), you now get a warning if you try to create an exclude condition of this type, although that doesn't prevent you from using it.
• Most cross-tab reports run faster now.
• You can now output cross-tab reports that have Show Change or Show % Change turned on to Microsoft Excel, CVS, or PivotTable files even when the report can't be previewed or printed because it has too many columns.
• Stonefield Query starts up faster than before.
• The setting of the "display only directly related tables" button is no longer remembered because it was easy to miss that this option was turned on and then wonder why all of the tables weren't displayed.
• Turning on Use same options next time report is run on the Output page of the Reports Explorer now saves the selected printer if it isn't the default printer. This allows you to always print the report to the same printer, such as sending mailing labels to a label printer.
• You can now specify the name of a report to edit or that a report should be created with the New Report Wizard with command-line parameters.

Stonefield Query SDK version 4.2

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

Report Designer

• You can now edit formulas from Step 2 in the report wizards. When a formula is selected, click the Edit Formula button to edit it. Otherwise, that button appears as "New Formula", so clicking it creates a new formula.
• Formulas now appear in report wizards with "[Formula]" after the name so you can distinguish them from real fields.
• You can now specify the order that a formula appears in its table when fields are displayed in table order. This is useful if you want a formula to appear somewhere other than at the end of the list of fields.
• You can now specify the number of rows a dashboard has. For example, if there are four charts in a dashboard and you specify two rows, the dashboard will have two rows of two charts each.
• Two new templates are available:
  • Modern: this template has alternating light and dark rounded rectangles in the detail band and a blue rounded rectangle for column headers.
  • Modern with Title: this template is similar to Modern but with a title page showing the report name, comment, user, date, and filter.

  To add these to the list of available templates, choose Template Editor from the Tools menu, click Import, and select these templates from the Sample Templates folder.

• Objects in templates have a new Center option, which is useful for images such as logos that you want to be centered horizontally on the page.
• Stonefield Query can now automatically sum numeric fields when you add them to a report. Turn on the Automatically sum numeric fields setting in the Options dialog to use this feature.
• The Format page of the Field Properties dialog of the Advanced Report Designer now has a Display date only setting that works like the same setting in the Properties dialog of the report wizards: turn this setting on to display the date only or turn it off to display the date and time.
• You can now specify whether missing date values are included in a chart when a date field is used in as the category (X-axis) field.
• The License Manager now includes a Copy button to copy the selected serial number to the Clipboard. This makes it easier to specify your serial number when requesting technical support.
• You now get a warning if you try to schedule a report that has ask-at-runtime filter conditions, since that prevents a scheduled report from running.
• Because exclude filter conditions are often erroneously used in place of a normal "not equals" filter (for example, you want a list of customers who aren't in Germany and use an exclude condition of Country equals Germany rather than the correct way, with a normal filter condition of Country does not equal Germany), you now get a warning if you try to create an exclude condition of this type, although that doesn't prevent you from using it.
• Most cross-tab reports run faster now.
• You can now output cross-tab reports that have Show Change or Show % Change turned on to Microsoft Excel, CVS, or PivotTable files even when the report can't be previewed or printed because it has too many columns.
• Stonefield Query starts up faster than before.
• The setting of the "display only directly related tables"  button is no longer remembered because it was easy to miss that this option was turned on and then wonder why all of the tables weren't displayed.
• Turning on Use same options next time report is run on the Output page of the Reports Explorer now saves the selected printer if it isn't the default printer. This allows you to always print the report to the same printer, such as sending mailing labels to a label printer.
• You can now specify the name of a report to edit or that a report should be created with the New Report Wizard with command-line parameters.

Stonefield Query Studio

• It's now much easier to create a relationship between tables that matches more than one field from each table: rather than typing the join expression, you can use field drop-down lists to choose up to five fields from each table.
• The Import Data Dictionary function can now add tables and fields to the data dictionary, and supports the data type, size, decimals, and picture for fields. It also now supports subtables and application views.
• Stonefield Query can now accept XML created by the WriteXML method of an ADO.Net DataTable from the Select script for a table.
• The Report object has a new Template property that allows you to programmatically determine or change the template used for a report.
• The description applied to SFQuery.EXE by the Change SFQuery.exe Description function in the File menu is no longer padded with spaces and terminated with periods.
• You can now specify the order of a field in the table. This is useful if you want some calculated fields to appear somewhere other than at the end of the list of fields when fields are displayed in database order.
• If you specify a value for the new URL for Knowledgebase configuration setting, the Stonefield Query Help menu has a Knowledgebase function that navigates the user's browser to that URL.
• If the new Application.SubmitTicket script has any code, that script is executed when an error occurs and the user clicks the Send button in the error dialog. This script can be used to automatically create support tickets in your support system if you have such a system and it has an API or some other automated mechanism for creating tickets.
• The new DataEngine.SetOperatorList script allows you to customize the list of filter operators available for a specific field or data type.
• Stonefield Query now correctly handles fields defined with more than 18 decimal places.
• The About dialog, available in the Help menu, now displays the serial number.
• You no longer need to create a GetDataSources script for a database that has its connection type set to "None". In that case, you will need Select scripts for all of the tables since Stonefield Query doesn't connect to any database.
• Turning off the Reportable property for a field no longer disables the Filterable and Allow Values properties. This allows you to turn these properties on, meaning a user can't report on the field but can filter on it.

Stonefield Query for Sage Pro ERP version 4.1.4246

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

Stonefield Query for Sage Accpac ERP version 4.1.4246

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

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

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

Stonefield Query SDK version 4.1.4246

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

Stonefield Query SDK Version 4.1.4171

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

Report Designer

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

SDK

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