Stonefield Query SDK Version 8.0

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

Report Designer

• You can now choose to display a Microsoft Office-like ribbon rather than a toolbar and menu at the top of the Reports Explorer.

• The Microsoft Excel - Data Only and Microsoft Excel - Data-Only (Fast) output types were replaced with a single Microsoft Excel - Data Format output type. Any reports or scheduled tasks using Microsoft Excel - Data Only or Microsoft Excel - Data Only (Fast) now automatically use Microsoft Excel - Data Format instead.

• You can now specify that a field should be output as a bar code in quick and label reports.

• You can now use multiple page columns in a quick report. This is useful for reports that don't have many fields: rather than having the right side of the page empty, another column of records can be output there.

• A new date format is available: Abbrev. Month/Year. This displays a three-letter abbreviation for a month, such as "Jan 2021" for "January", which allows columns in a report, especially a cross-tab report, to be narrower.

• You can now use a dynamic expression for both the foreground (text) and background colors of a field in a report. Also, dynamic colors and font styles are now supported when you output to Microsoft Excel - Data Format.

• You can now specify an email address to be notified when a scheduled report fails due to an error.

• The Scheduled Tasks dialog has three new features: you can stop a running task, you can disable a task without deleting it, and you can select multiple tasks and delete or disable/re-enable them.

• The Preview window has some new features:

  • The new left panel, which can be expanded or collapsed, contains bookmarks, page thumbnails, and search results.
  • The mouse wheel move to the next or previous page when zoom is set to 100% or less, or scrolls within the page when it's more than 100%.
  • There are more choices for Pages to Display: all the way up to 11x5.
  • You can now zoom a report up to 6,000%.

• You can now get the CC email address to use for a report from a field.

• Fields in the group header of a quick report are now left-aligned with each other if they appear on separate lines.

• Turning on the Auto-Fit to Page setting for a cross-tab report now causes the font to be reduced automatically if it can fit all of the columns on one page.

• The GetValueForParameter function now accepts a format parameter.

• Hovering your mouse over the file name in the Output page of the Reports Explorer now shows the type of output as a tooltip. This is helpful because, for example, several output types use XLSX as a file extension.

• The SQL statement generated for a report can now be up to 16,000 characters; previously, the limit was 8,000.

Stonefield Query Studio

• A new file has to be distributed with Stonefield Query: VFPAR.dll. Be sure to update or regenerate your installer script.

• The new GetSQL script for a table returns the SQL statement to use for the table rather than a simple SELECT SomeFields FROM TableName. The benefit of this is that if a virtual table simply needs a single SQL statement, such as a UNION between two real tables, you can avoid creating a Select script for the table. Select scripts cause a query to be split into individual tables when a report is run, which can make a report run slower, especially with tables with a lot of records. A GetSQL script can potentially be significantly faster since the query isn't split in that case but instead the returned SQL statement is used as a subquery for the main SQL statement for the report.

• You can customize the ribbon displayed in the Reports Explorer in the Application.ReportsExplorerReady script.

• A new Build button appears when you choose Connection String for an ODBC connection to a database. Clicking this button displays the Connection String Builder which makes it easier to enter a connection string.

• Online help generated by Stonefield Query Studio has much better searching so there's no need for Google Custom Search. As a result, the Google Custom Search ID configuration setting was removed.

• The Application object has a new RibbonVisible property.

• The Report object has a new CCEMailField property.

• The DataEngine object has a new GetWhereFromSQLStatement method.

• The GetValueForParameter function now accepts a format parameter.

Reporting4Act! Version 7.6.7743

We are pleased to announce the release of version 7.6.7743 of Reporting4Act!. This is a small maintenance release. Its main purpose is to add compatibility with Act! v23. Here are the new changes:

• Reporting4Act! is now compatible with Act! v23.

• An issue causing formatting codes to be displayed incorrectly in the Contact Related Contacts Details field was corrected.

This release also includes all the new features from the previous version 7.6 release.

Reporting4Act! Version 7.6

We are pleased to announce the release of version 7.6 of Reporting4Act!. 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.

• If the new Overwrite Reports Catalog with Server Version setting in the Locations page of the Options dialog is turned on, workstations and the server contain the exact same set of reports; at startup, the workstation's reports are overwritten with those on the server. With this setting turned off (and the way it worked before this version), it's possible for the workstation to have more reports than the server since syncing is from the server to the workstation and not vice versa.

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

• The new functions AddDocumentToActContact, AddDocumentToActCompany, and AddDocumentToActGroup allow you to attach a file to the Documents tab in Act!. The new Add Document To Act Example sample report demonstrates the use of these functions.

• 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 GoldMine Version 7.6

We are pleased to announce the release of version 7.6 of Stonefield Query for GoldMine. 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 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.

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.

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.

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.

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.