Thursday, January 7, 2021

Stonefield Query for ALERE Version 7.6

We are pleased to announce the release of version 7.6 of Stonefield Query for ALERE. Here are the new features.

  • You can add a new data source to report on, such as another database or a Microsoft Excel document. Note: you have to be an Administrative user with an Ultimate license to use this feature.

  • Related to the previous item, if there is no relationship between the tables used in a report when you add a field in step 2 of the report wizard, you are now prompted to create one rather than just being given a warning.

  • You can now visually see the relationships for the tables in a SQL statement by clicking the View button in the Customize SQL Statement step of the Customize Wizard.

  • You can now prevent a user running a report from ignoring an ask-at-runtime filter condition.

  • The Reports Explorer now shows how long the last run of a report took. This is also available in Usage Reporting.

  • You can now force all users to log out by choosing Display Logged in Users from the Tools menu and clicking the Shutdown button. Users have three minutes to finish what they're doing and exit the program or it is terminated. This is handy if you need to install a new version or perform some maintenance that requires all users to be out of the program.

  • You can now use Microsoft SQL Server or some other database to host Stonefield Query's data tables, such as Users and Reports, rather than them being DBF files on disk.

  • You no longer get a warning message if the Everyone group doesn't have any data sources selected in the Maintain Users and Groups dialog. That allows you to turn off all data sources for all users and then turn it on group by group.

  • By default, the Login dialog displays the name of the last user who logged in. You can prevent that by adding AutoLoginName=N to Data.ini.

  • Previously, the Login dialog showed a list of data sources available to the system, whether the user who logs in can access them or not. Now, it doesn't display any data sources until the user name is entered and then only shows the data sources that user can access.

  • The Logged In Users menu item is now only available for Administrator users.

  • You can now specify whether you want to support newer email protocols or not (some mail servers require it) in the Options dialog. You can also now turn on email logging, which is helpful if emails cannot be sent for some reason. You can also determine which of several SSL/TLS settings should be used rather than just on or off.

  • You can now customize the subtotals line in the group footer of a report using a template.

  • The new SpelledOut function spells out a numeric value. For example, SpelledOut(5.25) returns "Five dollars and 25 cents".

  • You can now specify whether a cross-tab report with a page field has column totals or not.

  • A message is now displayed if login fails.

  • The Windows account a scheduled report runs under no longer has to have run the application to specify email settings. Instead, the email settings for the user who scheduled the report are used.

  • The image in the Sample page of the Reports Explorer is now scrollable.

  • You can now access our Customer Portal from an item in the Help menu.

Stonefield Query for AccountMate 7.6

We are pleased to announce the release of version 7.6 of Stonefield Query for AccountMate. Here are the new features.

  • You can add a new data source to report on, such as another database or a Microsoft Excel document. Note: you have to be an Administrative user with an Ultimate license to use this feature.

  • Related to the previous item, if there is no relationship between the tables used in a report when you add a field in step 2 of the report wizard, you are now prompted to create one rather than just being given a warning.

  • You can now visually see the relationships for the tables in a SQL statement by clicking the View button in the Customize SQL Statement step of the Customize Wizard.

  • You can now prevent a user running a report from ignoring an ask-at-runtime filter condition.

  • The Reports Explorer now shows how long the last run of a report took. This is also available in Usage Reporting.

  • You can now force all users to log out by choosing Display Logged in Users from the Tools menu and clicking the Shutdown button. Users have three minutes to finish what they're doing and exit the program or it is terminated. This is handy if you need to install a new version or perform some maintenance that requires all users to be out of the program.

  • You can now use Microsoft SQL Server or some other database to host Stonefield Query's data tables, such as Users and Reports, rather than them being DBF files on disk.

  • You no longer get a warning message if the Everyone group doesn't have any data sources selected in the Maintain Users and Groups dialog. That allows you to turn off all data sources for all users and then turn it on group by group.

  • By default, the Login dialog displays the name of the last user who logged in. You can prevent that by adding AutoLoginName=N to Data.ini.

  • Previously, the Login dialog showed a list of data sources available to the system, whether the user who logs in can access them or not. Now, it doesn't display any data sources until the user name is entered and then only shows the data sources that user can access.

  • The Logged In Users menu item is now only available for Administrator users.

  • You can now specify whether you want to support newer email protocols or not (some mail servers require it) in the Options dialog. You can also now turn on email logging, which is helpful if emails cannot be sent for some reason. You can also determine which of several SSL/TLS settings should be used rather than just on or off.

  • You can now customize the subtotals line in the group footer of a report using a template.

  • The new SpelledOut function spells out a numeric value. For example, SpelledOut(5.25) returns "Five dollars and 25 cents".

  • You can now specify whether a cross-tab report with a page field has column totals or not.

  • A message is now displayed if login fails.

  • The Windows account a scheduled report runs under no longer has to have run the application to specify email settings. Instead, the email settings for the user who scheduled the report are used.

  • The image in the Sample page of the Reports Explorer is now scrollable.

  • You can now access our Customer Portal from an item in the Help menu.

Friday, December 18, 2020

Stonefield Query for Sage Pro ERP Version 7.6

We are pleased to announce the release of version 7.6 of Stonefield Query for Sage Pro ERP. Here are the new features.

  • You can add a new data source to report on, such as another database or a Microsoft Excel document. Note: you have to be an Administrative user with an Ultimate license to use this feature.

  • Related to the previous item, if there is no relationship between the tables used in a report when you add a field in step 2 of the report wizard, you are now prompted to create one rather than just being given a warning.

  • You can now visually see the relationships for the tables in a SQL statement by clicking the View button in the Customize SQL Statement step of the Customize Wizard.

  • You can now prevent a user running a report from ignoring an ask-at-runtime filter condition.

  • The Reports Explorer now shows how long the last run of a report took. This is also available in Usage Reporting.

  • You can now force all users to log out by choosing Display Logged in Users from the Tools menu and clicking the Shutdown button. Users have three minutes to finish what they're doing and exit the program or it is terminated. This is handy if you need to install a new version or perform some maintenance that requires all users to be out of the program.

  • You can now use Microsoft SQL Server or some other database to host Stonefield Query's data tables, such as Users and Reports, rather than them being DBF files on disk.

  • You no longer get a warning message if the Everyone group doesn't have any data sources selected in the Maintain Users and Groups dialog. That allows you to turn off all data sources for all users and then turn it on group by group.

  • By default, the Login dialog displays the name of the last user who logged in. You can prevent that by adding AutoLoginName=N to Data.ini.

  • Previously, the Login dialog showed a list of data sources available to the system, whether the user who logs in can access them or not. Now, it doesn't display any data sources until the user name is entered and then only shows the data sources that user can access.

  • The Logged In Users menu item is now only available for Administrator users.

  • You can now specify whether you want to support newer email protocols or not (some mail servers require it) in the Options dialog. You can also now turn on email logging, which is helpful if emails cannot be sent for some reason. You can also determine which of several SSL/TLS settings should be used rather than just on or off.

  • You can now customize the subtotals line in the group footer of a report using a template.

  • The new SpelledOut function spells out a numeric value. For example, SpelledOut(5.25) returns "Five dollars and 25 cents".

  • You can now specify whether a cross-tab report with a page field has column totals or not.

  • A message is now displayed if login fails.

  • The Windows account a scheduled report runs under no longer has to have run the application to specify email settings. Instead, the email settings for the user who scheduled the report are used.

  • The image in the Sample page of the Reports Explorer is now scrollable.

  • You can now access our Customer Portal from an item in the Help menu.

Wednesday, December 16, 2020

Stonefield Query for Sage 300 Version 7.6

We are pleased to announce the release of version 7.6 of Stonefield Query for Sage 300. Here are the new features.

  • Stonefield Query now works with Sage 300 2021 (version 6.8).

  • If you are using Stonefield Query with a newer version of Sage 300 than it was created for, you are now prompted if you want to check for an update.

  • In the Payroll Fields tab in the Options dialog, you can now specify which value a custom payroll field should to report on: the Employee Amount, Employer Amount, or Hours. There is also a lot more room to enter the list of Earning/Deductions codes used for the field. Custom payroll field also now properly handle Earning/Deduction Type set to N/A.

  • You can now access our Customer Portal from an item in the Help menu.

  • You can add a new data source to report on, such as another database or a Microsoft Excel document. Note: you have to be an Administrative user with an Ultimate license to use this feature.

  • Related to the previous item, if there is no relationship between the tables used in a report when you add a field in step 2 of the report wizard, you are now prompted to create one rather than just being given a warning.

  • You can now visually see the relationships for the tables in a SQL statement by clicking the View button in the Customize SQL Statement step of the Customize Wizard.

  • You can now prevent a user running a report from ignoring an ask-at-runtime filter condition.

  • The Reports Explorer now shows how long the last run of a report took. This is also available in Usage Reporting.

  • You can now force all users to log out by choosing Display Logged in Users from the Tools menu and clicking the Shutdown button. Users have three minutes to finish what they're doing and exit the program or it is terminated. This is handy if you need to install a new version or perform some maintenance that requires all users to be out of the program.

  • You can now use Microsoft SQL Server or some other database to host Stonefield Query's data tables, such as Users and Reports, rather than them being DBF files on disk.

  • You no longer get a warning message if the Everyone group doesn't have any data sources selected in the Maintain Users and Groups dialog. That allows you to turn off all data sources for all users and then turn it on group by group.

  • By default, the Login dialog displays the name of the last user who logged in. You can prevent that by adding AutoLoginName=N to Data.ini.

  • Previously, the Login dialog showed a list of data sources available to the system, whether the user who logs in can access them or not. Now, it doesn't display any data sources until the user name is entered and then only shows the data sources that user can access.

  • The Manage Databases and Logged In Users menu items are now only available for Administrator users.

  • You can now specify whether you want to support newer email protocols or not (some mail servers require it) in the Options dialog. You can also now turn on email logging, which is helpful if emails cannot be sent for some reason. You can also determine which of several SSL/TLS settings should be used rather than just on or off.

  • You can now customize the subtotals line in the group footer of a report using a template.

  • The new SpelledOut function spells out a numeric value. For example, SpelledOut(5.25) returns "Five dollars and 25 cents".

  • You can now specify whether a cross-tab report with a page field has column totals or not.

  • A message is now displayed if login fails.

  • The Windows account a scheduled report runs under no longer has to have run the application to specify email settings. Instead, the email settings for the user who scheduled the report are used.

  • The image in the Sample page of the Reports Explorer is now scrollable.

Thursday, December 10, 2020

Stonefield Query SDK Version 7.6

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

Report Designer

  • You can add a new data source to report on, such as another database or a Microsoft Excel document. Note: you have to be an Administrative user with an Ultimate license to use this feature.
  • Related to the previous item, if there is no relationship between the tables used in a report when you add a field in step 2 of the report wizard, you are now prompted to create one rather than just being given a warning.
  • You can now visually see the relationships for the tables in a SQL statement by clicking the View button in the Customize SQL Statement step of the Customize Wizard.
  • You can now prevent a user running a report from ignoring an ask-at-runtime filter condition.
  • The Reports Explorer now shows how long the last run of a report took. This is also available in Usage Reporting.
  • You can now force all users to log out by choosing Display Logged in Users from the Tools menu and clicking the Shutdown button. Users have three minutes to finish what they're doing and exit the program or it is terminated. This is handy if you need to install a new version or perform some maintenance that requires all users to be out of the program.
  • You can now use Microsoft SQL Server or some other database to host Stonefield Query's data tables, such as Users and Reports, rather than them being DBF files on disk.
  • You no longer get a warning message if the Everyone group doesn't have any data sources selected in the Maintain Users and Groups dialog. That allows you to turn off all data sources for all users and then turn it on group by group.
  • By default, the Login dialog displays the name of the last user who logged in. You can prevent that by adding AutoLoginName=N to Data.ini.
  • Previously, the Login dialog showed a list of data sources available to the system, whether the user who logs in can access them or not. Now, it doesn't display any data sources until the user name is entered and then only shows the data sources that user can access.
  • The Logged In Users menu item is now only available for Administrator users.
  • You can now specify whether you want to support newer email protocols or not (some mail servers require it) in the Options dialog. You can also now turn on email logging, which is helpful if emails cannot be sent for some reason. You can also determine which of several SSL/TLS settings should be used rather than just on or off.
  • You can now customize the subtotals line in the group footer of a report using a template.
  • The new SpelledOut function spells out a numeric value. For example, SpelledOut(5.25) returns "Five dollars and 25 cents".
  • You can now specify whether a cross-tab report with a page field has column totals or not.
  • A message is now displayed if login fails.
  • The Windows account a scheduled report runs under no longer has to have run the application to specify email settings. Instead, the email settings for the user who scheduled the report are used.
  • The image in the Sample page of the Reports Explorer is now scrollable.

Stonefield Query Studio

  • Three new files have to be distributed with Stonefield Query: SMTPLibrary2.dll, Library32.fll, and WinGraphViz.dll. Be sure to update or regenerate your installer script.
  • You can now visually see the relationships for a table by clicking the View Relations button in the Properties pane for a table.
  • ODBCDataSource has a new property: ConnectionFailureMessage, which is the text of any error that occurs when connecting to the database.
  • The new ReportEngine.OnFinishWizard script allows you to execute code when the user clicks the Finish button in a report wizard.
  • The new Quiet property of the Application object allows you to determine when Stonefield Query is running without displaying any user interface, such as when running a scheduled report.
  • The Log method of the Application object can now handle format strings. This saves having to concatenate strings together for more complex log entries.
  • The SaveEmailSettings method of the Application object now accepts Timeout, UseMailKit, and Logging parameters.
  • Field captions are now read from IBM DB2 databases.
  • The Options.Settings script can now access the Options dialog using the OptionsForm object. This allows you, for example, to programmatically remove a page from the Options dialog.
  • The GetReportHeader method of the Report object now accepts a parameter indicating that only the header should be returned, omitting the filter.

Friday, September 11, 2020

Stonefield Query for GoldMine Version 7.5.7557 Released

We are pleased to announce the release of version 7.5.7557 of Stonefield Query for GoldMine. This is a small maintenance release. Its main purpose is to add compatibility with GoldMine 2020. This release includes all the new features from the earlier version 7.5 release.

Tuesday, June 23, 2020

Reporting4Act! Version 7.5.7455 Released

We are pleased to announce the release of version 7.5.7455 of Reporting4Act!. This is a small maintenance release. Its main purpose is to add compatibility with Act! v22.1. This release includes all the new features from the earlier version 7.5 release.

Tuesday, June 9, 2020

Stonefield Query for ALERE Version 7.5

We are pleased to announce the release of version 7.5 of Stonefield Query for ALERE. Here are the new features.
  • Clicking a data point in a chart in a dashboard may now refresh other charts in the dashboard. This allows you, for example, to have a chart showing sales by year and another chart showing sales by month in a specific year. Clicking a year in the first chart changes the year used in the second one.
  • Related to the previous feature, you can have a chart in a dashboard automatically cycle through its X-axis values as filter values for other reports in the dashboard.
  • You can now specify that a chart included in a quick or cross-tab report should appear on its own page.
  • Charts now show "(None)" instead of a blank series.
  • The Output each group as a separate file option for outputting to file or email is now supported for chart reports.
  • The paging control in a chart now only appears if there's more than one page of data points.
  • Column heading objects no longer appear on the last page of a report containing a chart at the bottom.
  • Negative numbers formatted to display with parentheses are now right-justified on the last numeric position rather than on the closing parenthesis.
  • You can now specify vertical alignment for objects—top, middle, or bottom—in the Advanced Report Designer.
  • Microsoft Excel documents created by outputting a report using Excel Data-Only (Fast) output now support the desired font and size for each column and display fields formatted as % properly.
  • Tooltips are now supported. You can specify the tooltip for a field in the Properties dialog and that tooltip appears when you hover the mouse over a value for that field in the Preview window, in a PDF file, and in a HTML file.
  • You can now enter comments for a folder when you create or edit it and the comments are shown on the Information page of the Reports Explorer.
  • The default value for the Weeks starts on setting in the Options dialog is now the same as your Windows Regional Settings.
  • You can now report on several fields in the reports table, including Comments, Created By, and Created At, in the usage reporting module.
  • Preview functionality in the Advanced Report Designer that was removed in version 7.2 was restored.
  • The default for the Display grid lines setting is now turned on.
  • Cross-tab reports output to Excel Data-Only (Fast) now handle numeric row fields as numeric and don't include subtotals.
  • You can now optionally sum a numeric field in the row of a cross-tab report.
  • You can now specify a list of values for the user to choose from in the GetValuesForParameter function.
  • You can now create and populate a ValuesCollection object using the new ValuesCollection function.
  • Emailing using SMTP now handles email servers that use a newer protocol for SSL.

Stonefield Query for AccountMate Version 7.5

We are pleased to announce the release of version 7.5 of Stonefield Query for AccountMate. Here are the new features.
  • Clicking a data point in a chart in a dashboard may now refresh other charts in the dashboard. This allows you, for example, to have a chart showing sales by year and another chart showing sales by month in a specific year. Clicking a year in the first chart changes the year used in the second one.
  • Related to the previous feature, you can have a chart in a dashboard automatically cycle through its X-axis values as filter values for other reports in the dashboard.
  • You can now specify that a chart included in a quick or cross-tab report should appear on its own page.
  • Charts now show "(None)" instead of a blank series.
  • The Output each group as a separate file option for outputting to file or email is now supported for chart reports.
  • The paging control in a chart now only appears if there's more than one page of data points.
  • Column heading objects no longer appear on the last page of a report containing a chart at the bottom.
  • Negative numbers formatted to display with parentheses are now right-justified on the last numeric position rather than on the closing parenthesis.
  • You can now specify vertical alignment for objects—top, middle, or bottom—in the Advanced Report Designer.
  • Microsoft Excel documents created by outputting a report using Excel Data-Only (Fast) output now support the desired font and size for each column and display fields formatted as % properly.
  • Tooltips are now supported. You can specify the tooltip for a field in the Properties dialog and that tooltip appears when you hover the mouse over a value for that field in the Preview window, in a PDF file, and in a HTML file.
  • You can now enter comments for a folder when you create or edit it and the comments are shown on the Information page of the Reports Explorer.
  • The default value for the Weeks starts on setting in the Options dialog is now the same as your Windows Regional Settings.
  • You can now report on several fields in the reports table, including Comments, Created By, and Created At, in the usage reporting module.
  • Preview functionality in the Advanced Report Designer that was removed in version 7.2 was restored.
  • The default for the Display grid lines setting is now turned on.
  • Cross-tab reports output to Excel Data-Only (Fast) now handle numeric row fields as numeric and don't include subtotals.
  • You can now optionally sum a numeric field in the row of a cross-tab report.
  • You can now specify a list of values for the user to choose from in the GetValuesForParameter function.
  • You can now create and populate a ValuesCollection object using the new ValuesCollection function.
  • Emailing using SMTP now handles email servers that use a newer protocol for SSL.

Tuesday, May 26, 2020

Reporting4Act! Version 7.5 Released

We are pleased to announce the release of version 7.5 of Reporting4Act!. Here are the new features.
  • Clicking a data point in a chart in a dashboard may now refresh other charts in the dashboard. This allows you, for example, to have a chart showing sales by year and another chart showing sales by month in a specific year. Clicking a year in the first chart changes the year used in the second one.
  • Related to the previous feature, you can have a chart in a dashboard automatically cycle through its X-axis values as filter values for other reports in the dashboard.
  • You can now specify that a chart included in a quick or cross-tab report should appear on its own page.
  • Charts now show "(None)" instead of a blank series.
  • The Output each group as a separate file option for outputting to file or email is now supported for chart reports.
  • The paging control in a chart now only appears if there's more than one page of data points.
  • Column heading objects no longer appear on the last page of a report containing a chart at the bottom.
  • Negative numbers formatted to display with parentheses are now right-justified on the last numeric position rather than on the closing parenthesis.
  • You can now specify vertical alignment for objects—top, middle, or bottom—in the Advanced Report Designer.
  • Reporting4Act! is now better able to handle certain issues with the Act! data provider.
  • The list of available Act! databases is now always shown in alphabetical order.
  • Reporting4Act! now detects when certain sets of incompatible tables are added to a report, and displays a warning in that case.
  • Handling for HTML and RTF formatted text in details fields was improved.
  • Microsoft Excel documents created by outputting a report using Excel Data-Only (Fast) output now support the desired font and size for each column and display fields formatted as % properly.
  • Tooltips are now supported. You can specify the tooltip for a field in the Properties dialog and that tooltip appears when you hover the mouse over a value for that field in the Preview window, in a PDF file, and in a HTML file.
  • You can now enter comments for a folder when you create or edit it and the comments are shown on the Information page of the Reports Explorer.
  • The default value for the Weeks starts on setting in the Options dialog is now the same as your Windows Regional Settings.
  • You can now report on several fields in the reports table, including Comments, Created By, and Created At, in the usage reporting module.
  • Preview functionality in the Advanced Report Designer that was removed in version 7.2 was restored.
  • The default for the Display grid lines setting is now turned on.
  • Cross-tab reports output to Excel Data-Only (Fast) now handle numeric row fields as numeric and don't include subtotals.
  • You can now optionally sum a numeric field in the row of a cross-tab report.
  • You can now specify a list of values for the user to choose from in the GetValuesForParameter function.
  • You can now create and populate a ValuesCollection object using the new ValuesCollection function.
  • Emailing using SMTP now handles email servers that use a newer protocol for SSL.