Tuesday, June 11, 2019

Customer Portal Update

We’ve added a couple of new features to our Customer Portal:

  • The new Comments setting for each license allows you to enter anything you wish, such as who a license was assigned to.
  • The license list now shows the Company and Contact names that were entered when a license was activated.

These changes make it easier to keep track of which licenses are assigned to which users.

Wednesday, May 22, 2019

Stonefield Query Enterprise Version 5.0

We are pleased to announce the release of version 5.0 of Stonefield Query Enterprise. There are lots of new features in this release.

  • Two factor authentication is now available for users that require additional security. You can enable it via a new tab in options.

  • Improved loading times when initially opening a report for the first time.

  • Administrator users can now specify that their email settings be used as the default settings. Any users that don't have email settings specified will use the default settings when sending emails.

  • It's now much easier to create a SQL Passthrough report with parameters. Stonefield Query will detect each '?' placeholder in the SQL Statement and prompt for a caption and parameter value for it.

  • User names with backslashes are now supported.

  • When entering a server address for FTP, you can now optionally specify a ftp:// prefix if you'd like.

  • The author and title properties are now set on generated Excel documents.

  • Stonefield Query now supports multiple schedules with the same name (even across tenants).

  • The user interface has several new progress indicators.

  • The scheduler has a new "New schedule" button.

  • When registering for a new user account, you can now choose the password rather than one being generated automatically.

  • You now get a warning if you try to edit a report that is already being edited by another user.

  • The properties dialog now includes the table each field is from to make fields with the same name easier to identify.

  • The ask-at-runtime filter display now includes the connection for a filter condition.

  • The ability to email and upload (to FTP) reports can now be restricted by role.

  • The tooltip for a formula in the formulas list will display all reports a formula is being used in.

  • A new button in step 2 of the report wizards will filter the list of tables to only those tables related to tables already appearing in the selected list.

  • Stonefield Query is now built using ASP.NET Core. The new platform has a number of benefits, including greatly improved loading performance, the ability to self host, and support for additional hosting platforms.

  • The Stonefield Query Enterprise installer no longer installs IIS Express since that's no longer needed. When testing a project locally from Stonefield Query Enterprise Studio, the new self-hosting option is used.

  • Stonefield Query is now available in 64-bit and 32-bit versions, the latter necessary if you have to connect to a 32-bit data source. By default, the Launch Stonefield Query function in Stonefield Query Studio launches the 64-bit version, but if you want to be prompted for which version to use, turn on the Prompt For 32-bit vs 64-bit setting in the Options page.

  • The Refresh dialog has a new Extended Logging option that, if turned on, performs additional diagnostic logging in case issues arise.

  • External authentication via Open ID 2.0 is no longer supported, and has been replaced with Open ID Connect instead. In addition, you can also enable external authentication using Google, Twitter, Facebook, and Active Directory Federated Services.

  • The Open Project dialog now has a text box so you can type a path if desired.

  • If you use the SQL Server ODBC driver to connect to a database, you are now asked if you want to the use SqlClient provider instead, since it works better.

  • The Select Table dialog now shows the type of each object: table, view, or "sproc" for stored procedure.

  • If a table uses StoredProcedurePlugin as its plugin, you are prompted to refresh the table so the list of fields is correct.

  • Added additional logging to various scenarios.

  • A new provider is available for SQLite data sources.

  • Field values retrieved from the database are now converted to the type stored in the data dictionary for that field.

  • Added better support for field names that begin with a digit.

  • A new configuration option is available to skip retrieving the schema for a query.

  • You can now specify a complex join that includes additional tables in the join. This is useful if you need to specify a join that must always include a third table, for example.

  • User themes are now loaded from an xml file (themes.xml). Add any additional themes to this file to make them available to the end user.

  • Stonefield Query now supports encrypted query strings in the URL.

Tuesday, May 21, 2019

Reporting4Act! version 7.2.7003

Note that as of version 7.0, Stonefield Query for Act! is now known as Reporting4Act! - Powered by Stonefield Query.

We are pleased to announce the release of version 7.2.7003 of Reporting4Act!. This release adds compatibility with the new Act! v21.1, and also includes all the previous version 7.2 features.

Thursday, November 29, 2018

Stonefield Query for ALERE Version 7.2

We are pleased to announce the release of version 7.2 of Stonefield Query for ALERE. There are lots of new features in this release.

  • A new script is available for reports in the Customize Report Wizard: BeforeOutput. This script allows you to change output settings for the report before it's output to file or email.

  • If a subreport has an ask-at-runtime filter condition that matches a filter condition in the main report, the value of that filter condition for the main report is used for the subreport and you are no longer prompted for the value (similar to the way this works for linked reports).

  • Cross-tab reports can now have a page field, which appears in the page header and causes a page break when its value changes.

  • You can now specify the number of points per page in a chart that's part of a quick or cross-tab report.

  • You can now specify whether the Y-axis scale of a chart is determined automatically and, if not, what the minimum and maximum values are.

  • Gauges are now centered in their preview window.

  • The Scheduled Tasks dialog has a Diagnostic button that displays the content of the most recent diagnostic file for the selected task.

  • You can now append to an existing Microsoft Excel document when outputting to Excel full format.

  • You can now specify whether an Excel document has gridlines.

  • You can now choose the merge type, Letter or Directory, when outputting to Microsoft Word Merge. This affects where pages break in the generated Word documents.

  • The new Shadowed setting allow you to specify whether the data shapes in bar, column, pie, and donut charts are shadowed.

  • A chart in a quick or cross-tab report can now be different than the main report. For example, a cross-tab with Country in the row, Order Date (displayed as Year) in the column, and Sales Amount in the data can have a chart has Order Date (displayed as Quarter) as the x-axis and Sales Amount as the Y-axis (that is, Country isn't used in the chart).

  • You can now turn on Subtotal on This Field for a date field formatted as an aggregate date (such as Quarter or Year) in the rows of a cross-tab report.

  • You can now create a template that displays only the page header rather than both the page header and report filter.

  • You can now press Enter to add a line break in the Expression Builder for report headers and footers, the message of an email, and the Customize Report Wizard.

  • The Expression Builder button is now available for the custom description of a filter condition.

  • In the Expression Builder, clicking the Values button to display the Values dialog and selecting a value now inserts that value into the expression.

  • You can now use loReport.GetReportHeader(.T.) in a report template to display the page header without the report filter.

  • If you import a template with the same name as an existing one, you're asked if you want the imported template to overwrite the existing one or be imported with a new name.

  • The last page of the Formatting Options step in the Chart Wizard is now labelled "Other" because it contains other settings.

  • You can no longer use the Edit Chart button for a chart that's part of a quick or cross-tab report because it doesn't work properly.

  • You can no longer use the Print Preview function in the Advanced Report Designer since it isn't reliable.

Stonefield Query for HEAT Version 7.2

We are pleased to announce the release of version 7.2 of Stonefield Query for HEAT. There are lots of new features in this release.

  • A new script is available for reports in the Customize Report Wizard: BeforeOutput. This script allows you to change output settings for the report before it's output to file or email.

  • If a subreport has an ask-at-runtime filter condition that matches a filter condition in the main report, the value of that filter condition for the main report is used for the subreport and you are no longer prompted for the value (similar to the way this works for linked reports).

  • Cross-tab reports can now have a page field, which appears in the page header and causes a page break when its value changes.

  • You can now specify the number of points per page in a chart that's part of a quick or cross-tab report.

  • You can now specify whether the Y-axis scale of a chart is determined automatically and, if not, what the minimum and maximum values are.

  • Gauges are now centered in their preview window.

  • The Scheduled Tasks dialog has a Diagnostic button that displays the content of the most recent diagnostic file for the selected task.

  • You can now append to an existing Microsoft Excel document when outputting to Excel full format.

  • You can now specify whether an Excel document has gridlines.

  • You can now choose the merge type, Letter or Directory, when outputting to Microsoft Word Merge. This affects where pages break in the generated Word documents.

  • The new Shadowed setting allow you to specify whether the data shapes in bar, column, pie, and donut charts are shadowed.

  • A chart in a quick or cross-tab report can now be different than the main report. For example, a cross-tab with Country in the row, Order Date (displayed as Year) in the column, and Sales Amount in the data can have a chart has Order Date (displayed as Quarter) as the x-axis and Sales Amount as the Y-axis (that is, Country isn't used in the chart).

  • You can now turn on Subtotal on This Field for a date field formatted as an aggregate date (such as Quarter or Year) in the rows of a cross-tab report.

  • You can now create a template that displays only the page header rather than both the page header and report filter.

  • You can now press Enter to add a line break in the Expression Builder for report headers and footers, the message of an email, and the Customize Report Wizard.

  • The Expression Builder button is now available for the custom description of a filter condition.

  • In the Expression Builder, clicking the Values button to display the Values dialog and selecting a value now inserts that value into the expression.

  • You can now use loReport.GetReportHeader(.T.) in a report template to display the page header without the report filter.

  • If you import a template with the same name as an existing one, you're asked if you want the imported template to overwrite the existing one or be imported with a new name.

  • The last page of the Formatting Options step in the Chart Wizard is now labelled "Other" because it contains other settings.

  • You can no longer use the Edit Chart button for a chart that's part of a quick or cross-tab report because it doesn't work properly.

  • You can no longer use the Print Preview function in the Advanced Report Designer since it isn't reliable.

Tuesday, November 20, 2018

Stonefield Query for AccountMate Version 7.2

We are pleased to announce the release of version 7.2 of Stonefield Query for AccountMate. There are lots of new features in this release.

  • A new script is available for reports in the Customize Report Wizard: BeforeOutput. This script allows you to change output settings for the report before it's output to file or email.

  • If a subreport has an ask-at-runtime filter condition that matches a filter condition in the main report, the value of that filter condition for the main report is used for the subreport and you are no longer prompted for the value (similar to the way this works for linked reports).

  • Cross-tab reports can now have a page field, which appears in the page header and causes a page break when its value changes.

  • You can now specify the number of points per page in a chart that's part of a quick or cross-tab report.

  • You can now specify whether the Y-axis scale of a chart is determined automatically and, if not, what the minimum and maximum values are.

  • Gauges are now centered in their preview window.

  • The Scheduled Tasks dialog has a Diagnostic button that displays the content of the most recent diagnostic file for the selected task.

  • You can now append to an existing Microsoft Excel document when outputting to Excel full format.

  • You can now specify whether an Excel document has gridlines.

  • You can now choose the merge type, Letter or Directory, when outputting to Microsoft Word Merge. This affects where pages break in the generated Word documents.

  • The new Shadowed setting allow you to specify whether the data shapes in bar, column, pie, and donut charts are shadowed.

  • A chart in a quick or cross-tab report can now be different than the main report. For example, a cross-tab with Country in the row, Order Date (displayed as Year) in the column, and Sales Amount in the data can have a chart has Order Date (displayed as Quarter) as the x-axis and Sales Amount as the Y-axis (that is, Country isn't used in the chart).

  • You can now turn on Subtotal on This Field for a date field formatted as an aggregate date (such as Quarter or Year) in the rows of a cross-tab report.

  • You can now create a template that displays only the page header rather than both the page header and report filter.

  • You can now press Enter to add a line break in the Expression Builder for report headers and footers, the message of an email, and the Customize Report Wizard.

  • The Expression Builder button is now available for the custom description of a filter condition.

  • In the Expression Builder, clicking the Values button to display the Values dialog and selecting a value now inserts that value into the expression.

  • You can now use loReport.GetReportHeader(.T.) in a report template to display the page header without the report filter.

  • If you import a template with the same name as an existing one, you're asked if you want the imported template to overwrite the existing one or be imported with a new name.

  • The last page of the Formatting Options step in the Chart Wizard is now labelled "Other" because it contains other settings.

  • You can no longer use the Edit Chart button for a chart that's part of a quick or cross-tab report because it doesn't work properly.

  • You can no longer use the Print Preview function in the Advanced Report Designer since it isn't reliable.

Monday, November 19, 2018

Stonefield Query for GoldMine Version 7.2

We are pleased to announce the release of version 7.2 of Stonefield Query for GoldMine. There are lots of new features in this release.

  • A new Address (Full) field is available in the Main table. This field combines the Address 1, Address 2, Address 3, City, State, and Zip fields in a nice format.

  • Stonefield Query is compatible with GoldMine 2018.2.

  • A new script is available for reports in the Customize Report Wizard: BeforeOutput. This script allows you to change output settings for the report before it's output to file or email.

  • If a subreport has an ask-at-runtime filter condition that matches a filter condition in the main report, the value of that filter condition for the main report is used for the subreport and you are no longer prompted for the value (similar to the way this works for linked reports).

  • Cross-tab reports can now have a page field, which appears in the page header and causes a page break when its value changes.

  • You can now specify the number of points per page in a chart that's part of a quick or cross-tab report.

  • You can now specify whether the Y-axis scale of a chart is determined automatically and, if not, what the minimum and maximum values are.

  • Gauges are now centered in their preview window.

  • The Scheduled Tasks dialog has a Diagnostic button that displays the content of the most recent diagnostic file for the selected task.

  • You can now append to an existing Microsoft Excel document when outputting to Excel full format.

  • You can now specify whether an Excel document has gridlines.

  • You can now choose the merge type, Letter or Directory, when outputting to Microsoft Word Merge. This affects where pages break in the generated Word documents.

  • The new Shadowed setting allow you to specify whether the data shapes in bar, column, pie, and donut charts are shadowed.

  • A chart in a quick or cross-tab report can now be different than the main report. For example, a cross-tab with Country in the row, Order Date (displayed as Year) in the column, and Sales Amount in the data can have a chart has Order Date (displayed as Quarter) as the x-axis and Sales Amount as the Y-axis (that is, Country isn't used in the chart).

  • You can now turn on Subtotal on This Field for a date field formatted as an aggregate date (such as Quarter or Year) in the rows of a cross-tab report.

  • You can now create a template that displays only the page header rather than both the page header and report filter.

  • You can now press Enter to add a line break in the Expression Builder for report headers and footers, the message of an email, and the Customize Report Wizard.

  • The Expression Builder button is now available for the custom description of a filter condition.

  • In the Expression Builder, clicking the Values button to display the Values dialog and selecting a value now inserts that value into the expression.

  • You can now use loReport.GetReportHeader(.T.) in a report template to display the page header without the report filter.

  • If you import a template with the same name as an existing one, you're asked if you want the imported template to overwrite the existing one or be imported with a new name.

  • The last page of the Formatting Options step in the Chart Wizard is now labelled "Other" because it contains other settings.

  • You can no longer use the Edit Chart button for a chart that's part of a quick or cross-tab report because it doesn't work properly.

  • You can no longer use the Print Preview function in the Advanced Report Designer since it isn't reliable.

Monday, November 5, 2018

Stonefield Query for Legrand CRM Version 7.2

We are pleased to announce the release of version 7.2 of Stonefield Query for Legrand CRM. There are lots of new features in this release.

  • A new script is available for reports in the Customize Report Wizard: BeforeOutput. This script allows you to change output settings for the report before it's output to file or email.

  • If a subreport has an ask-at-runtime filter condition that matches a filter condition in the main report, the value of that filter condition for the main report is used for the subreport and you are no longer prompted for the value (similar to the way this works for linked reports).

  • Cross-tab reports can now have a page field, which appears in the page header and causes a page break when its value changes.

  • You can now specify the number of points per page in a chart that's part of a quick or cross-tab report.

  • You can now specify whether the Y-axis scale of a chart is determined automatically and, if not, what the minimum and maximum values are.

  • Gauges are now centered in their preview window.

  • The Scheduled Tasks dialog has a Diagnostic button that displays the content of the most recent diagnostic file for the selected task.

  • You can now append to an existing Microsoft Excel document when outputting to Excel full format.

  • You can now specify whether an Excel document has gridlines.

  • You can now choose the merge type, Letter or Directory, when outputting to Microsoft Word Merge. This affects where pages break in the generated Word documents.

  • The new Shadowed setting allow you to specify whether the data shapes in bar, column, pie, and donut charts are shadowed.

  • A chart in a quick or cross-tab report can now be different than the main report. For example, a cross-tab with Country in the row, Order Date (displayed as Year) in the column, and Sales Amount in the data can have a chart has Order Date (displayed as Quarter) as the x-axis and Sales Amount as the Y-axis (that is, Country isn't used in the chart).

  • You can now turn on Subtotal on This Field for a date field formatted as an aggregate date (such as Quarter or Year) in the rows of a cross-tab report.

  • You can now create a template that displays only the page header rather than both the page header and report filter.

  • You can now press Enter to add a line break in the Expression Builder for report headers and footers, the message of an email, and the Customize Report Wizard.

  • The Expression Builder button is now available for the custom description of a filter condition.

  • In the Expression Builder, clicking the Values button to display the Values dialog and selecting a value now inserts that value into the expression.

  • You can now use loReport.GetReportHeader(.T.) in a report template to display the page header without the report filter.

  • If you import a template with the same name as an existing one, you're asked if you want the imported template to overwrite the existing one or be imported with a new name.

  • The last page of the Formatting Options step in the Chart Wizard is now labelled "Other" because it contains other settings.

  • You can no longer use the Edit Chart button for a chart that's part of a quick or cross-tab report because it doesn't work properly.

  • You can no longer use the Print Preview function in the Advanced Report Designer since it isn't reliable.

Stonefield Query for Sage Pro ERP Version 7.2

We are pleased to announce the release of version 7.2 of Stonefield Query for Sage Pro ERP. There are lots of new features in this release.

  • A new script is available for reports in the Customize Report Wizard: BeforeOutput. This script allows you to change output settings for the report before it's output to file or email.

  • If a subreport has an ask-at-runtime filter condition that matches a filter condition in the main report, the value of that filter condition for the main report is used for the subreport and you are no longer prompted for the value (similar to the way this works for linked reports).

  • Cross-tab reports can now have a page field, which appears in the page header and causes a page break when its value changes.

  • You can now specify the number of points per page in a chart that's part of a quick or cross-tab report.

  • You can now specify whether the Y-axis scale of a chart is determined automatically and, if not, what the minimum and maximum values are.

  • Gauges are now centered in their preview window.

  • The Scheduled Tasks dialog has a Diagnostic button that displays the content of the most recent diagnostic file for the selected task.

  • You can now append to an existing Microsoft Excel document when outputting to Excel full format.

  • You can now specify whether an Excel document has gridlines.

  • You can now choose the merge type, Letter or Directory, when outputting to Microsoft Word Merge. This affects where pages break in the generated Word documents.

  • The new Shadowed setting allow you to specify whether the data shapes in bar, column, pie, and donut charts are shadowed.

  • A chart in a quick or cross-tab report can now be different than the main report. For example, a cross-tab with Country in the row, Order Date (displayed as Year) in the column, and Sales Amount in the data can have a chart has Order Date (displayed as Quarter) as the x-axis and Sales Amount as the Y-axis (that is, Country isn't used in the chart).

  • You can now turn on Subtotal on This Field for a date field formatted as an aggregate date (such as Quarter or Year) in the rows of a cross-tab report.

  • You can now create a template that displays only the page header rather than both the page header and report filter.

  • You can now press Enter to add a line break in the Expression Builder for report headers and footers, the message of an email, and the Customize Report Wizard.

  • The Expression Builder button is now available for the custom description of a filter condition.

  • In the Expression Builder, clicking the Values button to display the Values dialog and selecting a value now inserts that value into the expression.

  • You can now use loReport.GetReportHeader(.T.) in a report template to display the page header without the report filter.

  • If you import a template with the same name as an existing one, you're asked if you want the imported template to overwrite the existing one or be imported with a new name.

  • The last page of the Formatting Options step in the Chart Wizard is now labelled "Other" because it contains other settings.

  • You can no longer use the Edit Chart button for a chart that's part of a quick or cross-tab report because it doesn't work properly.

  • You can no longer use the Print Preview function in the Advanced Report Designer since it isn't reliable.

Stonefield Query for Sage 300 Version 7.2

We are pleased to announce the release of version 7.2 of Stonefield Query for Sage 300. There are lots of new features in this release.

  • Stonefield Query is now compatible with Sage 300 2019.

  • There are now relationships from Return Authorization tables to Order Entry, Inventory Control, Accounts Receivable, and Accounts Payable tables.

  • A new script is available for reports in the Customize Report Wizard: BeforeOutput. This script allows you to change output settings for the report before it's output to file or email.

  • If a subreport has an ask-at-runtime filter condition that matches a filter condition in the main report, the value of that filter condition for the main report is used for the subreport and you are no longer prompted for the value (similar to the way this works for linked reports).

  • Cross-tab reports can now have a page field, which appears in the page header and causes a page break when its value changes.

  • You can now specify the number of points per page in a chart that's part of a quick or cross-tab report.

  • You can now specify whether the Y-axis scale of a chart is determined automatically and, if not, what the minimum and maximum values are.

  • Gauges are now centered in their preview window.

  • The Scheduled Tasks dialog has a Diagnostic button that displays the content of the most recent diagnostic file for the selected task.

  • You can now append to an existing Microsoft Excel document when outputting to Excel full format.

  • You can now specify whether an Excel document has gridlines.

  • You can now choose the merge type, Letter or Directory, when outputting to Microsoft Word Merge. This affects where pages break in the generated Word documents.

  • The new Shadowed setting allow you to specify whether the data shapes in bar, column, pie, and donut charts are shadowed.

  • A chart in a quick or cross-tab report can now be different than the main report. For example, a cross-tab with Country in the row, Order Date (displayed as Year) in the column, and Sales Amount in the data can have a chart has Order Date (displayed as Quarter) as the x-axis and Sales Amount as the Y-axis (that is, Country isn't used in the chart).

  • You can now turn on Subtotal on This Field for a date field formatted as an aggregate date (such as Quarter or Year) in the rows of a cross-tab report.

  • You can now create a template that displays only the page header rather than both the page header and report filter.

  • You can now press Enter to add a line break in the Expression Builder for report headers and footers, the message of an email, and the Customize Report Wizard.

  • The Expression Builder button is now available for the custom description of a filter condition.

  • In the Expression Builder, clicking the Values button to display the Values dialog and selecting a value now inserts that value into the expression.

  • You can now use loReport.GetReportHeader(.T.) in a report template to display the page header without the report filter.

  • If you import a template with the same name as an existing one, you're asked if you want the imported template to overwrite the existing one or be imported with a new name.

  • The last page of the Formatting Options step in the Chart Wizard is now labelled "Other" because it contains other settings.

  • You can no longer use the Edit Chart button for a chart that's part of a quick or cross-tab report because it doesn't work properly.

  • You can no longer use the Print Preview function in the Advanced Report Designer since it isn't reliable.