Monday, November 5, 2018

Stonefield Query SDK Version 7.2

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

Report Designer

  • 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 Studio

  • A new DLL has to be deployed with Stonefield Query: InTry.dll. Be sure to add it to your installer script.

  • The Report object has new DisplayGridLines and MergeType properties.

  • The Field object has a new DisplayExpression property.

  • A report with a link action on a field that's output to HTML now includes the anchor tag for the linked field. This allows you to do something when the HTML document is displayed in a Web Browser control in a form (obviously it won't work when the document is displayed in a browser).

  • You can now implement the Google Custom Search Engine into deployed HTML help files for better searching. To support this, a new configuration setting, Google Custom Search ID, was added.

  • You can now pass a blank string for the INI file when calling the GetINIValue and SetINIValue methods of the Application object to use Data.ini in the Data subdirectory.

  • The CreateObject method of the Application object can now accept a single parameter: the class name to instantiate. This requires that the class be one of the built-in Stonefield Query classes.