The Last Edited By, Record Creator, and Record Manager fields in the Contact History and Contact Notes tables are now available for reporting on. Also, a new Duration (Text) field is available in Contact History, showing the duration as "X days Y hours Z minutes".Several new fields are available in Contact:- Birth Month: shows the month part of the birthday as the spelled-out month, such as "January". This field is great for filtering, such as "Birth Month equals January" for a list of all contacts with a birthday in January.
- Birth Month (YYYY-MM): shows the year and month part of the birthday. This field can be used for sorting by birthday.
- Birth Day: shows just the day part of the birthday
- Birth Year: shows just the year part of the birthday.
- The Product and Opportunity Product tables are now available for reporting on.
Version 1.05
- Stonefield Query has a new makeover: all dialogs appear in a more readable font.
- Reports now show "Page X of Y" on each page.
- You can now specify Quarter for the "Display date as" setting in the Properties dialog of the Cross-Tabulation Wizard.
- Word output, using the Full Format choice, works much better than before. Documents are smaller, open faster, and are now fully editable.
- In the Advanced Report Designer, you can now specify that the page header and/or footer print when the summary band for a report prints on the last page by itself.
- Stonefield Query now works correctly on systems where regional settings other than North American settings are used.
- The record count at the end of a report now displays the proper message in non-English languages.
- A bug that caused an error when outputting to a file with a very long file name and/or path (more than 127 characters) was fixed.
- A bug that sometimes prevented Advanced Layout reports from being saved was corrected.
- A bug that sometimes caused a "column not found" error when running a report was fixed.
- A bug that sometimes gave an error when editing or running an older report (one created several versions ago) was corrected.
- A bug that gave an error when printing the Activation Request Form was fixed.
- Cross-tab reports no longer support output to CSV, Excel, Spreadsheet, text, DBF, or XML formats, since the results don't look very good.
- A problem which caused fields rearranged in the Advanced Report Designer to output in a different order than they appear in the report when outputting to a file was corrected.
Version 1.04
- The performance for some types of reports has been greatly improved.
- You can now output a report to an RTF file.
- A new type of license is now available: a runtime license allows the user to run a report but not create a new report or copy, edit, or delete an existing report. This is a less expensive license for those users who don't need to create their own reports.
- You can no longer download and install the latest demo version to upgrade your full-working copy to the latest release. Doing so replaces your full version with a 7-day demo version, which is a bad thing! Instead, users whose software maintenance is up-to-date are provided a password to download the latest full version.
- This help file now has documentation on the most commonly used functions in the Advanced Report Designer.
- The Edit menu for the Advanced Report Designer now has Undo and Redo functions so you can undo an unintended move or other action.
- You can now double-click a report in the list to preview it.
- You can now run multiple reports from the command prompt or other applications.
- If you've moved your Stonefield Query data files to a different system, you no longer get a "license file is invalid" error, but are instead prompted to enter a new activation code, which you can obtain from Stonefield Software Inc.
- You can now only compare a field to another field of the same data type in the Filter Condition dialog. Also, the Field option for the Compare To setting doesn't appear if there aren't any other fields of the same data type in the selected table.
- The default name for an output file is now the name of the report plus the extension for the appropriate file type.
- Cross-tab column headings no longer split in the middle of a word but instead word wrap properly
- Outputting to file now ignores any field with a width set to 0.
- Stonefield Query now creates an advanced layout report correctly when the Summary report option is turned on.
- The Show Time and Show User options are no longer turned off when you make a report into an advanced layout report (although you can't change them after doing so).
- Several minor, relatively obscure bugs, such as an error if you double-click the Row, Column, or Data areas when they're empty in the Cross-Tabulation Wizard, an error when you ran a report with a filter that ORs a calculated field in one table with a non-calculated field in another, and an error when you customized the SQL statement for a report to include a WHERE clause and also specified a filter in the Filter step (we told you they were obscure!) were fixed.
Version 1.03
- You can now specify that a report is a summary report or show the filter, report user, or report time in the Quick Report and Cross-Tabulation Report wizards.
- Microsoft Word and HTML full format output are now significantly faster.
- The Properties dialog for fields is now better organized; it now uses tabs to separate the different types of properties.
- PDF and HTML output now support bookmarks. Bookmarks act like a table of contents for a report, so you can quickly jump from one item to another by simply clicking the appropriate bookmark.
- Stonefield Query now properly handles it when you change data grouping in the Advanced Report Designer.
- The Advanced Preview window was removed due to a number of shortcomings, including inability to deal with multi-column reports and errors with certain video drivers.
Version 1.02
- A new Cross-Tabulation Wizard allows you to create cross-tab reports with just a few mouse clicks.
- You can now create a filter that compares one field to another field in the same table (using the More button in the Filter Condition dialog).
- You can now tell Stonefield Query to ignore a specific "ask at runtime" condition when you run a report.
- You can now specify code that executes when a report is selected, when a report has finished running, just before the report's data set is created, and just after the data set was created. This allows you to do things such as pre or post-process the data. This is accessed from the Customize button (which replaces the Edit SQL button) in Step 3 of the Quick Report Wizard.
- The Report Wizard and Quick Report Wizard are now resizable, so you can make the dialogs larger to better see long field names, for example.
- The Report Wizard now starts with all report groups collapsed so it's easier to find the report you want when there are a lot of reports and report groups to choose from (note: if there's only one report group, it isn't collapsed).
- If the "Display real table and field names" option is turned on, the real name is displayed before the descriptive name rather than after, and tables and fields are sorted alphabetically by the real name rather than the descriptive name.
- Summary reports now show counts for the lowest level grouped field if the "Show count in group footer" setting is turned on.
- The Quick Report Wizard now includes a status bar so you can see the progress when you preview a report.
- The Show All Fields setting in the Filter Condition dialog is now turned on by default.
- The ruler in the Advanced Report Designer now displays the proper measurement system (inches or centimeters) based on your setting in the Control Panel.
- The Report Options step in the Report Wizard now has options to display the time the report was printed and the name of the user who printed it.
- You can now enter up to 60 characters for the report or group name (previously the limit was 30).
- Reports are now output to the proper paper size selected in the Page Setup dialog of the Advanced Report Designer.
- There are now two types of spreadsheet output: Excel and Spreadsheet. Both create XLS files, but Spreadsheet output (which is really an HTML file formatted so Excel can open it) is faster, has no record limit, supports memos fields such as notes, and doesn't require Excel to be installed on the system. Excel output only supports 16,384 records and doesn't output memo fields, but creates a true Excel file.
Version 1.01
- The new Email option in the Output Options page of the Report Wizard allows you to email a report as a PDF attachment without first previewing the report. You can also specify that a report is emailed automatically using command line parameters.