Stonefield Query SDK Version 7.5

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

Report Designer

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

• You can now specify comments for database, table, and relation objects in Studio. These comments aren't used anywhere but are output when you use the Export to Excel function.
• To better support email servers using newer SSL protocols, three new files have to be distributed with Stonefield Query: MimeKit.dll, MailKit.dll, and BouncyCastle.Crypto.dll. Be sure to update or regenerate your installer script.
• TaskScheduler.dll is no longer deployed since it was only used on Windows XP and earlier systems and Stonefield Query now requires Windows Vista and later.
• There's a new ReportRunCancelled property for ReportEngine, a new ProcessID property for Application, and a new Tooltip property for ReportField.
• 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.