Thursday, December 6, 2012

Stonefield Query SDK Version 4.3

We are pleased to announce the release of version 4.3 of the Stonefield Query SDK. Here are the new features in this version.

Report Designer

  • You can now create batch reports. A batch report automatically runs several reports, outputting each to the desired destination. This is handy if, for example, you normally run the same three reports at the end of every week. Rather than choosing them one at a time, you can create a batch report that combines those three reports and just run it. You can even schedule batch reports.
  • You can now append the output of a report to an existing Microsoft Excel output file. In that case, the report appears in a new worksheet (tab) within the spreadsheet. This even works if the file is already open in Excel. You can also now choose XLSX or XLS as the extension for a Microsoft Excel output file.
  • Turning on the new Start each group on a new page option for the first row field in a cross-tab report causes each group of records to appear on its own page. You can also now turn on the Output each group as a separate file and Output each group as a separate email settings so each group is output to its own file or email.
  • The new Delimited - Microsoft Excel Format output type outputs to a comma-separated values (CSV) file but uses Excel formatting so things like leading zeros are preserved when the file is opened in Excel.
  • Formulas are now stored in the same folder as reports (in a file named CalcFields.DBF) so if the program runs on a workstation but reports are shared on a server, so are the formulas. For backward compatibility, the program will still look for CalcFields in the Data subdirectory of the program folder so you won't lose your formulas, so this works better for new installations rather than existing ones.
  • You can now enter a formatted SQL statement in the SQL Statement step of the Customize Report dialog. For example, carriage returns and tabs are now permitted. This makes it easier to take a SQL statement from another application and paste it into a report's SQL statement. Note that this change now requires you to prefix procedural code with "*-" if you want to use code rather than a SQL statement (a rare occurrence).
  • Microsoft Excel full-format output works better now: the output has a single page header at the top of the document and a single page footer at the bottom rather than header/footer sections where the pages would normally break, and the use of empty columns and rows for positioning is minimized.
  • Stonefield Query now handles font scripts other than Western, such as Cyrillic or Greek. You can select the desired script in the Font dialog that appears when you click the font button in the Field Properties dialog of a report wizard or in the Advanced Report Designer.
  • Clicking the Add All or Remove All buttons in Step 2 of the report wizards now display a prompt asking you to confirm if you want to do that to prevent inadvertently adding all fields in a table to a report or removing all fields from a report.
  • The application no longer erases the diagnostic log (Diagnostic.txt in the Data subdirectory of the program folder) if KeepLog=Y is in Data.INI. This is useful for checking diagnostics over multiple runs, such as for scheduled reports.
  • You can now resize dashboard windows to a much smaller size than before.
  • You can now edit a chart that's included in a quick report with an advanced layout. The Size page in Step 4 of the Chart Wizard is now disabled in that case, since you cannot change the chart size.
  • You can now click the serial number in the About dialog (available from the Help menu) to copy your serial number to the clipboard. This makes it easier to enter the serial number when creating a ticket in our online support ticket system.

Studio

  • Each database can now have its own specific name delimiters (used to delimit table and field names containing spaces, dashes, or other illegal characters) and you can edit the delimiters in the Database properties page.
  • The Subtable properties page now has a link to jump to the original table for the subtable.
  • The new Update Virtual/Subtable to Match Main Table function updates the selected virtual or subtable to have the same fields as the main table the virtual or subtable was created from.
  • You can now specify that certain tables should be handled differently when reading the structure of a database to Stonefield Query Studio by adding a "NoNative" section to SFQuery.INI. This prevents untrappable errors in the MySQL 5.1 driver on specific tables.
  • Stonefield Query now automatically ignores Oracle system tables when reading the structure of a database.
  • A new file, FoxTools.FLL, must be distributed with Stonefield Query.

Tuesday, October 30, 2012

Stonefield Query for GoldMine version 4.2.4603

Version 4.2.4603 has several great new features.
  • Stonefield Query now supports the new GoldMine version 9.2.
  • The new Auto-fit to page setting for quick reports automatically reduces the font when fields would normally be moved to a second row because there are too many to fit on one. This makes it possible for the fields to fit on a single row.
  • The new Find Field button in step 2 of the report wizards makes it easier to find a field by part of the caption.
  • Reports can be combined into a single PDF output by specifying the same file name for each report and turning on the new Append to existing file setting.
  • The Dashboard window now supports outputting all charts to a single PDF file.
  • You can now sort a chart by values rather than the default alphabetically by category by setting the Sort setting in the Field Properties dialog to Ascending or Descending Order.
  • You can now define multi-line point labels for charts in Windows XP (it was only available in previous versions for Windows Vista and 7).
  • You now get a warning if you copy an expression from the Expression Builder and paste it into a place where real table and field names are required, such as the expression for a formula or a field in the Advanced Report Designer. Previously, you would get an error when running the report.
  • You can now define user group names up to 60 characters (the previous limit was 20).
  • You can now define report names up to 100 characters (the previous limit was 60).
  • You can now create an advanced layout report from a report with Summary turned on.

Stonefield Query for Sage BusinessVision version 4.2.4603

Version 4.2.4603 has several great new features.
  • A large number of system tables are now available for reporting. These are included in Query's new System data group.
  • The MISC_1 and MISC_2 fields in the INVENTORY table now appear with the custom caption defined for them in the BusinessVision database.
  • A new "Vendor Pricing" table is available, for reporting on only the vendor records from the Special Pricing table.
  • Several tables were added to appropriate data groups.
  • The new Auto-fit to page setting for quick reports automatically reduces the font when fields would normally be moved to a second row because there are too many to fit on one. This makes it possible for the fields to fit on a single row.
  • The new Find Field button in step 2 of the report wizards makes it easier to find a field by part of the caption.
  • Reports can be combined into a single PDF output by specifying the same file name for each report and turning on the new Append to existing file setting.
  • The Dashboard window now supports outputting all charts to a single PDF file.
  • You can now sort a chart by values rather than the default alphabetically by category by setting the Sort setting in the Field Properties dialog to Ascending or Descending Order.
  • You can now define multi-line point labels for charts in Windows XP (it was only available in previous versions for Windows Vista and 7).
  • You now get a warning if you copy an expression from the Expression Builder and paste it into a place where real table and field names are required, such as the expression for a formula or a field in the Advanced Report Designer. Previously, you would get an error when running the report.
  • You can now define user group names up to 60 characters (the previous limit was 20).
  • You can now define report names up to 100 characters (the previous limit was 60).
  • You can now create an advanced layout report from a report with Summary turned on.

Tuesday, October 16, 2012

Stonefield Query for AccountMate SQL 4.2.4603

Version 4.2.4603 has several great new features.
  • Stonefield Query now supports the new AccountMate 8.3 for SQL release.
  • The new Auto-fit to page setting for quick reports automatically reduces the font when fields would normally be moved to a second row because there are too many to fit on one. This makes it possible for the fields to fit on a single row.
  • The new Find Field button in step 2 of the report wizards makes it easier to find a field by part of the caption.
  • Reports can be combined into a single PDF output by specifying the same file name for each report and turning on the new Append to existing file setting.
  • The Dashboard window now supports outputting all charts to a single PDF file.
  • You can now sort a chart by values rather than the default alphabetically by category by setting the Sort setting in the Field Properties dialog to Ascending or Descending Order.
  • You can now define multi-line point labels for charts in Windows XP (it was only available in previous versions for Windows Vista and 7).
  • You now get a warning if you copy an expression from the Expression Builder and paste it into a place where real table and field names are required, such as the expression for a formula or a field in the Advanced Report Designer. Previously, you would get an error when running the report.
  • You can now define user group names up to 60 characters (the previous limit was 20).
  • You can now define report names up to 100 characters (the previous limit was 60).
  • You can now create an advanced layout report from a report with Summary turned on.

Tuesday, September 25, 2012

Stonefield Query for ACT! version 4.2.4603

Version 4.2.4603 has several great new features.
  • Stonefield Query is now compatible with the new Sage ACT! 2013.
  • Four new sample reports have been added for ACT! 2010 and later databases.
  • The performance of reports using the Details or Notes fields in the ACT! 2010+ data provider has been greatly improved.
  • New "Organizer Phone" fields are available in the activity tables in the ACT! 2010+ data provider, similar to the existing "Organizer Email" fields.
  • The new Auto-fit to page setting for quick reports automatically reduces the font when fields would normally be moved to a second row because there are too many to fit on one. This makes it possible for the fields to fit on a single row.
  • The new Find Field button in step 2 of the report wizards makes it easier to find a field by part of the caption.
  • Reports can be combined into a single PDF output by specifying the same file name for each report and turning on the new Append to existing file setting.
  • The Dashboard window now supports outputting all charts to a single PDF file.
  • You can now sort a chart by values rather than the default alphabetically by category by setting the Sort setting in the Field Properties dialog to Ascending or Descending Order.
  • You can now define multi-line point labels for charts in Windows XP (it was only available in previous versions for Windows Vista and 7).
  • You now get a warning if you copy an expression from the Expression Builder and paste it into a place where real table and field names are required, such as the expression for a formula or a field in the Advanced Report Designer. Previously, you would get an error when running the report.

Thursday, August 23, 2012

Stonefield Query for Sage Accpac/300 ERP Version 4.2.4603

Version 4.2.4603 has several great new features.

  • Stonefield Query for Sage Accpac ERP has been renamed to Stonefield Query for Sage 300 ERP because Sage renamed Sage Accpac ERP to Sage 300 ERP. Please note that regardless of the name, Stonefield Query works with Sage 300 ERP and Sage Accpac ERP versions 6.0 and earlier.
  • The new Auto-fit to page setting for quick reports automatically reduces the font when fields would normally be moved to a second row because there are too many to fit on one. This makes it possible for the fields to fit on a single row.
  • The new Find Field button in step 2 of the report wizards makes it easier to find a field by part of the caption.
  • Reports can be combined into a single PDF output by specifying the same file name for each report and turning on the new Append to existing file setting.
  • The Dashboard window now supports outputting all charts to a single PDF file.
  • You can now sort a chart by values rather than the default alphabetically by category by setting the Sort setting in the Field Properties dialog to Ascending or Descending Order.
  • Stonefield Query now supports printer custom forms specified in templates. This allows you to, for example, create a template that's very wide (using Tabloid size paper) so fields don't wrap onto a second row when there are lots of fields.
  • You can now define multi-line point labels for charts in Windows XP (it was only available in previous versions for Windows Vista and 7).
  • You now get a warning if you copy an expression from the Expression Builder and paste it into a place where real table and field names are required, such as the expression for a formula or a field in the Advanced Report Designer. Previously, you would get an error when running the report.
  • Relationships were added between the Accounts Receivable Receipt/Adjustments (ARTCR) and Invoices (ARIBH) tables, the Accounts Receivable Applied Receipt/Adjustments (ARTCP) and Order Entry Invoices (OEINVH) tables, and the Accounts Receivable Invoices (ARIBH) and Order Entry Invoices (OEINVH) tables.
  • The Applied Receipt/Adjustments (ARTCP) table now appears in the Order Entry module as well as Accounts Receivable.
  • The Payroll Fields settings in the Options dialog can now accept longer lists of code values.

Thursday, August 16, 2012

Stonefield Query SDK version 4.2.4603

Version 4.2.4603 has several great new features.

Report Designer
  • The new Auto-fit to page setting for quick reports automatically reduces the font when fields would normally be moved to a second row because there are too many to fit on one. This makes it possible for the fields to fit on a single row.
  • The new Find Field button in step 2 of the report wizards makes it easier to find a field by part of the caption.
  • Reports can be combined into a single PDF output by specifying the same file name for each report and turning on the new Append to existing file setting.
  • The Dashboard window now supports outputting all charts to a single PDF file.
  • You can now sort a chart by values rather than the default alphabetically by category by setting the Sort setting in the Field Properties dialog to Ascending or Descending Order.
  • Stonefield Query now supports printer custom forms specified in templates. This allows you to, for example, create a template that's very wide (using Tabloid size paper) so fields don't wrap onto a second row when there are lots of fields.
  • You can now define multi-line point labels for charts in Windows XP (it was only available in previous versions for Windows Vista and 7).
  • You now get a warning if you copy an expression from the Expression Builder and paste it into a place where real table and field names are required, such as the expression for a formula or a field in the Advanced Report Designer. Previously, you would get an error when running the report.
Stonefield Query Studio

Friday, May 25, 2012

Stonefield Query for Sage Accpac ERP version 4.2.4526

Version 4.2.4526 is mostly a maintenance release, but there are a few new features:

  • There are now relationships between Purchase Order Requisitions (PORQNH1) and Requisition Vendors (PORQNLV), Accounts Receivable Receipts/Adjustments (ARTCR) and Account Sets (ARRAS), Receipts/Adjustments (ARTCR) and Documents (AROBL), and Applied Receipts/Adjustments (ARTCP) and Documents (AROBL).
  • The Payroll Check Advice report now includes the same information the Sage Accpac report does, including balances and accruals.
  • There is now an Earning/Deduction Balance field in the Payroll Check Details table and a Net Balance field in the Employee Earnings/Deductions table.
  • You can now define user group names up to 60 characters (the previous limit was 20).
  • You can now define report names up to 100 characters (the previous limit was 60).
  • You can now create an advanced layout report from a report with Summary turned on.

Stonefield Query SDK version 4.2.4526

Version 4.2.4526 is mostly a maintenance release, but there are a few new features:

  • You can now define user group names up to 60 characters (the previous limit was 20).
  • You can now define report names up to 100 characters (the previous limit was 60).
  • You can now create an advanced layout report from a report with Summary turned on.
  • Stonefield Query now allows the same field to appear in both parent and child application views.
  • The ReportEngine object has new EditReport and NewReport methods.
  • The Import Data Dictionary function can now handle calculated fields.

Wednesday, May 2, 2012

Stonefield Query for Sage BusinessVision version 4.2

We are pleased to announce the immediate release of Stonefield Query for Sage BusinessVision 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.

Tuesday, April 17, 2012

Stonefield Query for GoldMine version 4.2

We are pleased to announce the immediate release of Stonefield Query for GoldMine 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.
  • The Calendar Recurrences table (added in GoldMine 9.0) is now available in Query, when Query is connected to a GoldMine 9.0+ database.
  • The Product Name field (added in GoldMine 8.5) is now available in Query's Opportunities table, Projects table, and Opportunity/Project table, when Query is connected to a GoldMine 8.5+ database.
  • Query now has a relationship defined between the Case Contacts Link table and the Combined Main and Other Contacts table. This allows for the proper reporting of the data shown on the Contacts tab in GoldMine's Cases view, using Query's Cases table and Combined Main and Other Contacts table.
  • A new Secondary Contact ID field is now available in the Combined Main and Other Contacts table. This field shows the ID for secondary contacts, and is blank for main contacts.

Tuesday, March 20, 2012

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.

Thursday, March 15, 2012

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.

Wednesday, March 14, 2012

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.

Wednesday, March 7, 2012

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.