Version 3.20

New Features

• The Filter page has a new Exclude button that allows you to specify which records to exclude from a query. We call this a "negative" query because it looks for the absence of data, such as all customers you didn't contact last year or all customers who didn't buy a certain product. Previously, you had to customize the SQL statement for the report to achieve this. Now you simply specify how to exclude certain records using the same dialog you use to create a filter on a report. See the Selecting Which Records to Exclude topic for details.

• Stonefield Query no longer has a background screen. All dialogs now appear directly on your Windows desktop and can be moved around independently.

• The report wizards are no longer modal. This means you can modify more than one report at a time if desired.

• You are now prompted for all ask at runtime filter conditions in a single dialog rather than one dialog per condition when you run a report.

• If you turn on the Include all fields in same table in group header setting in the Field Properties dialog, you can now specify that all fields in the group header should appear on the same line rather than each on its own line by turning on the new Place all fields in group header on same line setting.

• You can now specify that a field should go into the group header for another field. For example, suppose you group on City from the Customers table but want to show the Region in the group header as well. If you turn on the Include all fields in same table in group header option in the Group page in the Field Properties dialog, all fields in the Customers table will appear in the group footer, which isn't what you want. Instead, turn the new Include this field in the group header for setting on and select City from the drop-down list to place just City and Region in the group header. Since all fields that appear in group headers now appear in summary reports, Region will no longer be excluded from such a report.

• The Cross-Tabulation, Label, and Chart wizards now have an Advanced button that, like the Quick Report Wizard, brings up the Customize Report Wizard so you can specify top values, customize the SQL statement for a report, or specify code to execute at certain places for the report.

• The Field Properties dialog for the Label Wizard has a new Display this field in the report setting. Turn this setting off if you want the field included in query (for example, you want to sort on it) but not display it in the report.

• You can now specify multi-line headings for a field in the Field Properties dialog.

• You can now press the Esc key to stop a report run at any point rather than just while the pages are being rendered as was the case in earlier versions.

• Templates can now specify the paper size and source (such as a certain bin) so you don't need to use the Advanced Report Designer to, for example, output a report on legal paper.

• The Preview window has a new Email button allowing you to send an email directly from the window.

• You now get a warning if you run a report that has no filter, with an option to run the report anyway. This prevents a long-running report because you forgot to create a filter. An new setting in the Options dialog allows you to turn this warning off.

• A new Include database in header option adds the database name to the report header.

• The Options dialog has a new Locations page where you can easily change the location where reports are stored.

• You can now drag a Stonefield Query import file (an SFX file) from Windows Explorer to the Reports Explorer to import that report. You can also drag an FRX or RPT file from Windows Explorer to the Reports Explorer to bring up the External Report Wizard for that report.

• The Setup dialog now prompts you for your email settings. These are needed to email reports. However, many people don't realize they need to set these settings in the Options dialog so they can't email reports.

• You can now select specific reports to export or export all or some of the reports in a specific folder. The Export All Reports function in the File menu was renamed to Export Reports; selecting it now displays a dialog from which you can select which specific reports or folders to export. The Export Report function in the File menu was renamed to Export Selected Report.

• You can now edit the security properties of a folder by selecting the folder and clicking Edit in the Reports Explorer.

• The Information page in the Reports Explorer now shows what groups have access to the selected report or folder.

• New Create/update column heading and Adjust field width automatically options in the Field Properties dialog of the Advanced Report Designer provide you with more control over what Stonefield Query does automatically when you save a field.

• You now get a warning if you have a custom SQL statement for a report and filter on a field in a table that isn't specified in the SQL statement. The reason is because the filter condition can't be just added to the WHERE clause of the SQL statement since its table isn't specified in the FROM or JOIN clauses.

• The Login dialog no longer displays a choice for the database to query on if the database is specified as a command-line parameter.

• The Login dialog now shows the default user name and password (ADMIN and ADMIN) when the program hasn't been activated so new users don't have to guess or (heavens!) read the help file.

• Multi-page TIFF files are now supported for report output.

• Stonefield Query now looks in the Windows Registry for the location of the help file if the UseRegistry setting in Data.INI is Yes.

• Stonefield Query now returns error code -27 when called from another application and it cannot locate its resource file.

• You can now select more than about 20 files at a time when importing reports.

• You can now specify an expression for a chart title.

• The Expression Builder now has a Test Syntax button.

• A new built-in GetConditionValue function returns the value of the filter condition for the specified field. This can be used, for example, in the header of a report or a chart title to display the selected filter value.

• The Reports Explorer and Field Properties dialog now load faster when there are lots of reports. Also, the report drop-down list on the Link page of the Field Properties dialog no longer displays folders that have no reports.

• You can now tell Stonefield Query to ignore an ask-at-runtime filter condition in a report run from another application by specifying "Value=" (that is, with no value specified) in the command line parameters.

• The performance of some reports was improved, especially when there are lots of records in the table. Specifically, if you use an OR condition in the report but it isn't between different tables (for example, condition on Table1 AND (condition on Table2 OR condition on Table 2) AND condition on Table 1, the performance improvement applies.

• If you had multiple fields in the Row or Data lists in Step 3 of the Cross-Tabulation Wizard and wanted to rearrange them, you previously had to drag them all out of the list and then drag them back in the desired order. You can now rearrange them by dragging a field up or down in the list.

• The Add License dialog has a new Copy button which places the license information on the Windows clipboard.

• The Use old engine setting in Step 5 of the Quick Report Wizard is now always enabled, not just when Advanced layout is turned on. Turning this on allows the Preview window to appear more quickly, especially for very long reports, but the Preview window used when this is turned on has fewer features and some advanced options, such as dynamic formatting and rotation, aren't supported.

• Multiple filter conditions on the same field are now supported in linked reports as long as each condition uses a different operator.

• Deleting a folder now deletes all reports in that folder rather than giving you an error message and requiring you to manually delete all the reports.

• The AfterRun code for a report can now change something about how a report is output and re-run the output. An example in the related help topic shows how this can be used.

• Places in Stonefield Query that support expressions (such as the report header or footer) now support non-character expressions such as the current date.

• A new GetReportFilter method of the loReport object can be used to display the filter conditions for the report.

• The Commonly Used Expression drop-down in the Expression Builder now only shows common expressions that match the data type of the expression being built. For example, the common date expressions now only appear for date expressions. Also, a new First Day of Previous Month expression was added.

• More than 20 new reports have been added to the set of sample reports included with Stonefield Query for ACT!. This brings the total number of samples to over 160.

• Stonefield Query now has specific support for Swiftpage data stored in an ACT! 2005 or later database. On ACT! systems with Swiftpage installed, Query will now display a Swiftpage item in its table list. This allows for full reporting and filtering on Swiftpage information such as email opens, clicks, and campaigns.

• A new Opportunity History table has been added to Stonefield Query. This table is only available in recent versions of ACT!; when Query is connected to an older database without this information available, the Opportunity History table is not displayed as an option in Query.

• A new Logon History table has been added. This allows reports to display information regarding the logon history of users to the ACT! database. This table is only available in recent versions of ACT!; when Query is connected to an older database without this information available, the Logon History table is not displayed as an option in Query.

• Query reports are now able to have links to position ACT! to a certain contact, company, or group.

• Stonefield Query now supports custom subentities in ACT! 2008 databases.

• New options have been added to Stonefield Query's tools menu to add Stonefield Query itself, or specific Query reports to the ACT! menus.

• A new option has been added allowing ACT! 200X advanced queries to be imported as Stonefield Query reports.

• The new fields "Company Name With Hierarchy (Full)" and "Company Name With Hierarchy (Sortable)" have been added to the Company table, and "Group Name With Hierarchy (Full)" and "Group Name With Hierarchy (Sortable)" have been added to the Group table for ACT 200X databases. These show the full hierarchy for each item, in a format like "Grandparent Group -> Parent Group -> Child Group".

• Several small changes were made to ensure compatibility with ACT! versions 10.01 and 10.02.

• Query now gives a warning if a user attempts to use it with an incompatible version of ACT!.

• Stonefield Query for ACT! now automatically imports the sample reports the first time it is run.
  

Bug Fixes

• A problem that caused advanced layout reports to have too long of a page length when previewed or printed from the Preview window, resulting in some records not being displayed, was fixed.

• Under some conditions (sorting on a certain field data type when at least one record has a null value in that field), a single character was displayed rather than the entire contents of a field. This has been corrected.

• Charts now display correctly when there's missing data in some categories for some series.

• The correct controls are now displayed in the Options page of the Reports Explorer when it is the current page and you change from a Label report to a different type or vice versa.

• The Selected Field list in Step 2 of the report wizards now shows real table and field names correctly when you edit an existing report with the Display real table and field names option turned on.

• Renaming a report in the Reports Explorer didn't change the report header like renaming it in a report wizard; this was fixed. Also, copying a report now also changes the report header.

• The bookmarks panel in the Preview window is now sized correctly when clicking a field that runs a linked report and that report has bookmarks.

• A problem with not saving the email settings in the Options dialog was fixed.

• Specifying a period for the "CommonFiles" entry in Data.INI now means Stonefield Query's data files are located in the same folder as Data.INI rather than SFQuery.INI. Other types of relative paths are now handled correctly as well. Also, the program does a better job of handling Data.INI and its data files in "legacy" locations (locations other than the Data subdirectory of the application folder), and handles the case where its resource file (SQResource.DBF) exists in both the application folder and the Data subdirectory.

• Stonefield Query no longer exits with an error code when a report that has no records is run from another application; formerly, this prevented the rest of the reports from running if multiple reports were specified.

• The size and position of the Reports Explorer are now saved when you choose Exit from the File menu.

• A problem with entering too long of a contact name in the Registration dialog was fixed.

• The cause of a rare "invalid index key" error when running a cross-tabulation report was fixed.

• An error caused by sorting on a field that exists on a report but doesn't appear when Summary Report is turned on was fixed.

• The numeric part of image file names created when a report is output to an image now have zeros for place holders (for example, Report0009.GIF and Report0010.GIF rather than Report9.GIF and Report10.GIF) so they appear in the correct sorted order in Windows Explorer.

• Line spacing is now correct in labels that have fields in larger fonts.

• You no longer get an error if you choose Copy or Edit from the File menu when the Template Editor is open.

• You can no longer open multiple instances of the Template Editor.

• A bug that prevented sorting on a grouped field if you created a variable in the Advanced Report Designer on that field was fixed.

• HTML, Word, text, and table output now work correctly for chart reports. You can no longer output charts to RTF because the results aren't very good.

• Clicking the Values button in Step 2 of the report wizards now displays an empty list of values rather than no list at all if the selected table contains no records.

• The Filter Condition dialog now shows the correct list of tables and fields in the Cross-Tabulation and Chart Wizards for new reports.

• Linking to another report on certain types of fields now works correctly.

• Stonefield Query now properly handles a table or field that has "SELECT" at the end of its name (for example, "TaxSelect").

• Failure to connect to the update Web site when checking if a new version is available no longer causes an error message to be displayed.

• A second error that occurred while displaying the error message for a first error that may have occurred in the Preview window (for example, when running a linked report that had a problem) was resolved.

• The report drop-down list that appears on the Link page of the Field Properties dialog now shows the correct icon for chart reports.

• In previous versions, if you created a report but didn't go to Step 6 of the report wizard, everyone could run the report but only you could edit it. Now, the default is that everyone can both run and edit the report. You can, of course, change this in Step 6.

• A problem with the Chart Wizard hanging up after previewing a chart report that had no data in it was fixed.

• There is no longer a problem with displaying reports created by users with user names longer than eight characters.

• Pressing the Esc key while a report is running from one of the report wizards no longer causes an error.

• A problem with a filter condition containing an apostrophe under certain conditions was fixed.

• The Import Reports function now displays a proper error message if you select an empty file to import from.

• Clicking in one of the activation code boxes in the Registration dialog or Add License dialog after activating the program online added spaces to the activation code, making it invalid. This has been fixed.

• Changing the parameter information for a linked report caused the wrong information to be stored. This was corrected.

• An issue with the automatic update mechanism on Windows Vista systems was corrected.

• The Page Up and Page Down keys no longer move you from one page to another in a wizard; this feature prevented these keys from being used in other controls, such as drop-down lists. Instead, use Shift + Page Up and Shift + Page Down.

• An issue with the Login dialog sometimes appearing off-screen (and thus not visible, leading you to think the program had hung up) was fixed.

• Email addresses selected in the Select Email Addresses dialog are now separated with commas rather than semi-colons to prevent an issue with some email programs.

• The New Folder function in the File menu is disabled for runtime licenses, since it doesn't make sense to create a folder if you can't create any reports in that folder.

• Stonefield Query now respects changes to the font style for a field in a report (for example, making it bold).

• The Ignore this condition choice in the Conditions list of the Link page in the Field Properties dialog acted like None (that is, you were still prompted for an ask-at-runtime condition); this now works properly.

• The Advanced Report Designer no longer sizes a field past the right edge of the report when it automatically determines the size.

• Using the RunSQL function in the Advanced Report Designer with a SQL statement containing a join now works correctly.

• You can no longer resize the Reports Explorer window so small that the reports list is hidden.

• The Registration dialog now gives you a warning if you click the Print button without first filling in the serial number, and the prompt in the dialog tells you that value is needed.

• The hotkey for the Advanced Layout function in Step 5 of the Quick Report Wizard was changed from "V" to "D" so it doesn't conflict with the Preview function.

• A bug that prevented case-insensitive filters when the filter Compare to setting is set to Field was fixed.

• A bug that sometimes caused the login dialog to appear off-screen so you couldn't see it was fixed.

• Grand totals at the end of the report no longer appear on a second line if they will fit on the first one.

• Renaming a user in the Maintain Users and Groups dialog automatically moves all their reports to the new name.

• A bug that sometimes caused a filter condition to be mangled if it contained a single quote (for example, SomeField = 'Barney's Store') or a pair of empty quotes (for example, SomeField = '') was fixed.

• The cFilter property of the loReport object is now set to the filter for the report.

• Stonefield Query is now able to avoid ACT! timeout errors on long-running reports.
  

Version 3.10

New Features

• There is now a single, combined version of Stonefield Query for ACT!, compatible with all versions of ACT! since 3.0. Previously, there was one version of Stonefield Query available for ACT! 6.0 and earlier, and another version for ACT! 2005 and later.

• A new report type, Chart Report, allows you to create charts and graphs of your data. You can even include charts in Quick and Cross-Tabulation reports.

• Stonefield Query now supports live links on reports. This allows you to create reports that drill down to other reports (for example, clicking on a customer name to show the sales for that customer) or automatically bring up someone's email address in your email program or Web site in your browser.

• Stonefield Query now keeps track of your software maintenance expiry date: the About dialog and License Manager both show the date. Stonefield Query reminds you when your software maintenance is due for renewal and prevents you from running a newer version of the program if your software maintenance has lapsed.

• It's now much easier to discover when new versions are available and to install them. By default, Stonefield Query automatically checks our server once a day to see if a newer version is available. If so, a dialog describing the new features displays and you have the option of downloading and installing that version. Note that updates are only available to current subscribers. You can turn off automatically checking or change how often checking is done with settings in the Options dialog. You can also manually check for updates with the new Check for Updates function in the Help menu.

• Stonefield Query is now fully compatible with Windows Vista. It takes advantage of Aero Glass and the new system Segoe UI font for a more attractive, modern appearance, scheduled reports work correctly, and there are no errors during installation as there was with the previous release. In addition, files which Stonefield Query needs to write to, such as the license file and users table, are no longer stored in the program folder, which is by default read-only, but instead in a Data subdirectory of that folder for new installations (the location hasn't changed if you upgrade from an earlier version). You can change the location of this "system" file folder with a setting in Data.INI.

• Stonefield Query has a more modern icon:

• The new Preview Window has several new functions, including the ability to output to file and better control over printing options.

• Many new file output formats are available, including OpenOffice Calc and Writers, XPS, and several image file types.

• Professional licenses are now called Report Designer licenses to make it more obvious what they are for.

• You can now sort summary reports on fields other than the grouped fields. For example, to display sales by product, with the biggest selling items at the top, select the product name field and group on it, select the sales amount field and sum it, on the Sort Options page, sort on the sales amount field, and on the Formatting Options page, turn on the Summary report setting. In addition, you can use the Customize Report dialog to display only the top 10 (or some other number) selling items. In earlier versions, you needed to write AfterData code for the report.

• Turning off the new Display this field in the report setting (which is on by default) in the Field Properties dialog includes the field in the query but not in the report. This is useful if you want to sort or link on the field but not display it.

• You are now prompted if you wish to discard your changes when you click Cancel or press Esc in the report wizards. This prevents accidentally losing any work you've done on a report.

• The Email Properties dialog now supports a lot more email addresses, plus you can click a button to display a dialog to select from a list of email addresses. The new Import Email Addresses function allows you to bring email addresses from other applications such as Microsoft Outlook into Stonefield Query.

• Many windows are now resizable.

• Multiple monitors are now supported.

• Advanced layout reports can use a new built-in function called RunSQL. This function executes a SQL statement at report run time, so it can do complex calculations without requiring a user-defined function.

• AfterData code can now be simpler. A new variable called ResultSet contains the name of the result set so you can SELECT from it. Also, any result set created and selected in the code is automatically used by the report without you having to change the name of the result set normally used.

• The Summary option is now disabled for advanced layout reports, since those two features don't work well together.

• You can no longer change the Format or Style properties of a column field in a cross-tabulation report because the template used for the report determines those properties.

• The reports table is now compacted every time you exit Stonefield Query. This can reduce the size of this file considerably.

• The Report Date setting on the Options page of the Reports Explorer is now a drop-down calendar, making it easier to select the desired date.

• All of the sample report templates we provide are now automatically imported and available for use without you having to use the Import function in the Template Editor.

• You can no longer use a comma in a report name because commas cause problems in some areas, such as being able to email a report; many programs treat a comma as a special character such as a separator.

• Changing the name of a report now also changes the report header as long as it wasn't manually changed (that is, if it was the same as the report name before, it's changed to match the change in the report name).

• There is a new option Include cleared activities in activity reports in the Options screen. Turning this option off will cause cleared activities to not be included in reports, and will improve the performance of these reports. This option affects ACT! 200X reports only; it has no effect on reports involving ACT! 6.0 and earlier databases.

• Several new sample reports were added, demonstrating some uses of Query's new charting and linking features.

• Added new field Is Cleared to the Contact Activity, Company Activity, and Group Activity tables.

• Added new field Has Activities to the Contact table.

• Added new field Gross Margin to the Contact Opportunity, Company Opportunity, and Group Opportunity tables.

• Several ID/key fields were made reportable for use with the new drilldown report options.

• It is now possible to create an ACT! group using command-line parameters.

• The performance of several types of reports were improved.

• Several updates were made to ensure full compatibility with ACT! 2008.
  

Bug Fixes

• The Count button in the Filter dialog now works correctly when a report involves two or more tables.

• Reports with ask-at-runtime filter conditions being previewed when called from another application now prompt the user for the values for these conditions rather than failing to run. They will continue to fail if called for any other type of output (output to file, email, or printing).

• Right-clicking in a code window (displayed, for example, when you select the AfterData page in the Customize dialog, right-click in the code text box and select "Zoom") and choosing Build Expression no longer gives an error.

• Moving a field to the data area and then dragging it to the column area in Step 3 of the Cross-Tabulation Wizard no longer formats the field as a numeric value.

• A common cause of an "insufficient rights" warning received when importing a report was fixed.

• Images referenced in an advanced layout report as an expression are now handled properly. Also, multiple images stored in tables in an advanced layout report are now handled correctly.

• The Advanced Report Designer no longer automatically changes the width of a column heading for a field when you change the width of the field.

• Fields defined with zero width are no longer removed from the query when you make the report into an advanced layout report.

• A bug in handling the ACTION command-line parameter was fixed.

• An issue which gave incorrect results when previewing a report in the Quick Report Wizard, then removing a field from one table and adding a field from another table was fixed.

• A bug which didn't size certain fields wide enough when Auto-fit is turned on was fixed.

• An issue which caused groups to be repeated under certain conditions was fixed.

• An issue with selecting a field after choosing a new table in Step 2 of the report wizards not resulting in the mover or Values buttons being enabled was fixed.

• A bug in adding new groups in the Maintain Users and Groups dialog was fixed. Also, the Duplicate function was removed from the shortcut menu for this dialog.

• Adding a GROUP BY clause in a custom SQL statement for a report now works correctly. Also, subqueries are now handled properly.

• Selecting a report now resets the Use same filter next time report is run, Use same sort next time report is run, and Use same options next time report is run settings.

• Date fields now work correctly when used in the rows of a cross-tabulation report.

• A bug which caused certain fields added in the Advanced Report Designer to be sized with zero width was fixed.

• The Test function in the Email page of the Options dialog now works properly when MAPI is selected.

• You can now blank the Report Header option if you wish. Formerly, doing so caused it to revert to the report name.

• Outputting to text files now properly handles memo fields.

• The characters < and > are now handled correctly in activity records.

• The Values button now properly handles tables with zero records.
  

Version 3.04

New Features

• There is no longer a 7-day demo version; the demo version works for 30 days and can be extended by request to 60 days.

• The new Include in filter display setting option in the Filter Condition dialog allows you to specify whether a specific filter condition appears in the report header or not. To see this option, click the More button to expand the dialog.

• You can now specify the printer to print to as a command-line parameter.

• You can now display the Setup dialog by adding Action=Setup in an Other section of SFQuery.INI.

• The performance of certain types of queries was improved.

• If you call Stonefield Query from another application and there is no default printer driver, an error code of -2 is now returned.

• Right-clicking in the code editor window (displayed when you right-click code in the Customize Report Wizard and choose Zoom) and choosing Build Expression now displays the Stonefield Query Expression Builder rather than a generic one.

• The login dialog now prompts you to enter your Stonefield Query user name and password. This helps new users, who may think they have to enter their database user name and password instead.

• Stonefield Query no longer gives an error if an advanced layout report uses an image that no longer exists. Instead, you'll get a warning message, telling you the name of the missing file and asking you to edit and correct the report.

• Additional shortcut keys are now available in the Preview window: Ctrl+F brings up the Find dialog and Ctrl+G finds the next instance of the found text.
  

Bug Fixes

• A bug that caused an error in the Display Logged in Users function was fixed.

• A bug that sometimes caused the wrong table to be selected by default in the Expression Builder was corrected.

• A bug in handling certain types of custom SQL statements in reports was fixed, including statements containing mixed case and subqueries.

• Stonefield Query now displays images stored as binary data in SQL Server and other database engines properly.

• Users not defined as "advanced" in the Maintain Users and Groups dialog no longer get an error when clicking the Advanced button in step 2 of the Quick Report Wizard.

• You now get a warning rather than an error if you enter an expression of more than 254 characters in the Field Properties dialog in the Advanced Report Designer.

• You no longer get an error if the Sort page is selected in the Reports Explorer and you select a folder.

• Pressing F1 in the Advanced Report Designer now brings up the help topic for the Advanced Report Designer rather than the general help topic.

• A bug in handling licenses with more than 200 users was fixed.

• An issue on some systems that caused Stonefield Query to appear behind other application windows was corrected.

• The Test Syntax button in the Customize Report Wizard no longer reports an error for valid SQL statements.

• A field used in a group added in the Advanced Report Designer that has the same name as another field already in the report but in a different table is now properly added to the query.

• The Expression Builder now shows the proper expression if you edit an existing expression with the Display real table and field names option turned on.
  

Version 3.03.2426

• Previously, a problem connecting to the ACT SDK stopped Stonefield Query from opening an ACT database. Now you will get a warning message but the database will open with access to only certain fields. See the Failed to Connect Using ACT SDK help topic for details.

• A new Activity Type field is available in the Company History, Contact History, and Group History tables.

• A new Gross Margin field is available in the Opportunity Product table.

• A new Contact field is available in the Contact Opportunity and Company Opportunity tables.

• A date formatting bug in Activity tables was fixed.

• A problem with detecting which type of records are stored in a custom ACT SQL Server table was fixed.

• A bug involving field captions containing "&" was fixed.
  

Version 3.03

New Features

• The new Test button on the Email page of the Options dialog allows you to quickly test whether the email settings you entered are correct.

• The Reports Explorer now shows who created a folder and when.

• A new Display Logged in Users function in the Tools menu shows you which users are logged in so you can, for example, ask them to exit if you need to install an updated version.

• You can now set the width for a field in the Field Properties dialog in the Label Wizard. This useful if you want to sort on a field but don't want it to appear on the labels; in that case, set the width to 0.

• Double-clicking on a folder now expands or collapses the folder.

• Connections with double-parentheses, such as "and ((" and ")) or (," are now available, allowing you to create more complex filters.

• A report with a customized SQL SELECT statement now handles calculated fields correctly.

• An invalid value in a date field prevents Stonefield Query from running a report. In previous versions, Stonefield Query displayed an error message and there was no way to tell which record had the bad data. Now, a dialog appears allowing you to see all records that have bad data values so you can fix them and then run the report again.

• A scheduled report outputting to file no longer automatically opens the file after it's created.

• You can now create reports that display information from activity tables: Contact Activity, Company Activity, and Group Activity.

• Stonefield Query now supports QuoteWerks, a powerful quoting application that integrates seamlessly with ACT!. You can include fields from the QuoteWerks tables on the same report as any ACT! fields.

• We've added access to group membership information: you can now can report on groups and their member contacts.

• A new "Associate With" field is available in the Contact History, Contact Note, and Contact Opportunity tables.

• A new "Group List" field is available in the Contact table. This gives a list of all the groups the contact belongs to, separated by semicolons. This would mainly would be used for filtering.

• A new function in the Tools menu, Create/Update ACT! Group, adds all contacts in a report to a group in ACT!.

• Another new function in the Tools menu, Manage ACT! Database List, allows you to remove previously registered databases from the Open Database dialog.

• Additional information about the current ACT! database now appears in the About Stonefield Query dialog.

• Stonefield Query now displays the names of stock Contact field names if they've been changed in ACT!
  

Bug Fixes

• A bug that caused an error when running some types of cross-tab reports was fixed.

• A bug that caused an error when selecting the Delete function from the File menu to delete a folder was fixed.

• A bug that caused Stonefield Query to return a code of -15 for scheduled reports was fixed.

• A bug that caused scheduled reports to run multiple times was corrected.

• A bug that prevented fields from being resized in the Field Properties dialog in the Advanced Report Designer was fixed.

• A bug in the Maintain Users and Groups dialog preventing you from deleting any users in the Administrators group was fixed.

• A bug that sometimes caused the wrong field to be displayed in the Expression Builder when editing an existing expression was corrected.
  

Version 3.02

New Features

• Export files are now smaller because they no longer include the report snapshot image.

• A new Export All function exports all reports at once.

• You can now specify the report designer caption and tooltip for fields in the Advanced Report Designer.

• You can now specify the template to use for a report when calling Stonefield Query from another application.

• Stonefield Query now returns an exit code when you call it from another application so you can determine the outcome of the request.

• Other people's Favorites folders are no longer shown if they don't contain any reports.

• You can now customize the SQL statement for a report even if it includes calculated fields.

• You can no longer rename a report by clicking on the report in the Reports Explorer and typing a new name; you must choose Rename from the File menu or press F2. This prevents you from accidentally changing the report name.

• Since deleting reports is a fairly rare operation, and some users accidentally clicked the Delete button in the Reports Explorer toolbar when they meant to click the Edit button, the Delete button has been removed and pressing the Delete key no longer deletes a report. You can still delete a report using the File or shortcut menus.

• It's now easier to change the folder where reports are stored; rather than having to run Stonefield Query with the ACTION=SETUP command-line parameter to invoke the Setup dialog or modifying settings in the Windows Registry, you can now change an entry in Data.INI, a new settings file in the program directory.

• Data.INI, discussed in the previous point, also make workstation setup easier. In previous versions, after installing Stonefield Query on a server and specifying the location for the reports files, you then had to do workstation installs and specify the same location for the reports on each workstation. If you chose the wrong location on one particular machine, that user didn't have access to the reports. Now, after the first user runs Stonefield Query, Data.INI will contain the proper location, and each workstation will automatically use that location.

• The information in the error dialog has been made clearer and the Continue button now continues in the application without losing any work you've done on a report.

• It's possible under some conditions for report security to become confused, so you can't see reports you have rights to. This can now be corrected by specifying ACTION=FIXSECURITY as a command line parameter.
  

Bug Fixes

• Field sizing for numeric fields was improved.

• In previous versions, changes you made to settings in the report wizards weren't saved if you moved from one step to the next using the Page Up and Page Down keys. This has been corrected.

• Fields in labels are now placed in the order they appear in the Label Wizard rather than the order they were added. This was an issue if you added fields in a certain order and then rearranged them.

• Similar to the previous point, fields are now output to certain types of files, such as Excel - Data Only, in the order they appear in the report rather than the order they were added.

• If the first condition of a multi-condition filter is an ask-at-runtime condition and you choose Ignore this condition when you run the report, the filter displayed in the report header no longer starts with "and" or "or" (the connection used for the second condition).

• An error that occurred when trying to create a new folder with the same name as an existing one was fixed.

• Microsoft Word table format and HTML table format output now work correctly for cross-tab reports.

• A bug that caused an error if you turned on the Summary report option, previewed the report, and then turned on the Advanced layout option was fixed.

• Stonefield Query prevents you from entering certain characters, such as "\", "/", and "?", in a report name. However, it was possible to rename a report in the Reports Explorer to include these characters. This can cause a problem when you output a report, so that's been fixed.

• The SQL statement displayed in the Customize Wizard no longer includes the filter for the report, since the filter is added when the report is run from whatever filter the user specified.

• Although it's very rare, it's possible for the reports table to become corrupted. Stonefield Query has a built-in recovery mechanism for this, but a bug prevented the recovery from occurring before an error dialog appeared. This has been fixed,
  

Version 3.01

New Features

• The new Label Wizard allows you to quickly create mailing labels without having to use the Advanced Report Designer.

• Online activation is now available in the License Manager.

• The Schedule Wizard now adds the name of the database to the schedule so the report is run against the database open when the schedule was created rather than the last database accessed.

• The Values dialog (accessed by clicking on the Values button in the Filter Condition dialog) now shows the name of the field.

• Field sizing in reports is now more accurate, including when your system is set to display large fonts (120 DPI).

• The Setup dialog now handles the case where you select a read-only directory for the reports files location; it gives a warning rather than an error.

• This documentation is now also available as a PDF file (SFQUERY.PDF) so you can print the documentation if you wish.

• Database names displayed in Stonefield Query no longer include the file path.
  

Bug Fixes

• A bug in how date fields are handled in the Field Properties dialog was fixed.

• Very wide fields (wider than the width of the report) are now handled properly.

• A bug that gave an error when the License Manager was brought up in an unactivated version was fixed.

• Converting reports from earlier versions of Stonefield Query no longer gives an error when the users file is in the data file directory rather than the program directory. Also, reports with grouped fields no longer start each group on a new page when that option isn't selected.

• A bug that caused the wrong filter condition to be displayed in a report header when an expression is used in the condition was corrected.

• Running advanced layout reports created in an earlier version no longer gives an error.

• A problem that caused an error when Stonefield Query starts and tries to select the report selected the last time the program was closed and that report has a filter on a certain type of calculated field was fixed.

• Stonefield Query now handles custom SQL SELECT statements with expressions for fields.

• Fields that have auto-fit turned off and the If the field is too narrow setting set to one of the "cut off the data" choices now cut off the data rather than word wrapping.

• Changing the format for a field in the Advanced Report Designer now works. In version 3.0, this did not work if the Use default setting was turned on when you added the field to the report in the Quick Report Wizard.

• A problem with tables with certain characters (such as "&") in their names was fixed.

• You can now add multi-user licenses in the License Manager.

• Filters on memo fields no longer include quotes, so they work correctly.

• You can no longer move a folder to itself.

• A problem filtering on numeric fields when the currency symbol set in the Regional Setting control panel applet is something other than "$" was fixed.

• You can no longer enter a blank name when renaming a report or folder in the Reports Explorer.

• Filtering on fields of a certain data type (known as "Varchar" fields) now works correctly.

• An error outputting reports converted from earlier versions of Stonefield Query to Excel - Data Only was fixed.

• Local Time fields now work correctly in "is not blank" filters.
  

Version 3.0

The list of new and enhanced features in version 3.0 is extensive, and we're sure you will love them.

Reports Explorer

• The Report Wizard has been replaced with a new Reports Explorer. This was done for several reasons:
  • Having a wizard-based dialog caused confusion for some users. For example, some thought the Exit button returns them to Step 1 rather than exit the application.

  • It was more difficult to support new features, such as a report information page, using a wizard dialog.
    

• The Information page in the Reports Explorer shows information about the selected report, including when it was created and by whom, when it was last edited and by whom, and when it was last run and by whom.

• The icon for a report in the reports list now indicates the report type.

• The Sample page in the Report Explorer shows a snapshot of the first page of the report the last time it was run. This is handy to quickly identify reports, and can optionally be turned off.

• The Reports Explorer saves which folders were expanded and which report was selected when you exit Stonefield Query, and restores those settings the next time you run it. This means it comes back up exactly as it was when you left it.

• The toolbar is more attractive and easier to use than the set of buttons in the former Report Wizard. For example, the buttons are always available rather than only being visible in Step 1 as was the case with the Report Wizard, and the New button has a drop-down list of choices so you don't have to bring up the Report Type dialog when creating a new report.

• Support for report folders (formerly called report groups) has improved greatly. You can now have multiple levels of folders (that is, folders within folders), can now create and delete folders separately from creating or deleting reports, and have reports appear in more than one folder. There's also a user-specific Favorites folder.

• The Show SQL option now displays the WHERE clause of the SQL statement used for the selected report.
  

Security

• In previous versions, Stonefield Query supported only three levels of security for reports and it was all or none. You could specify that all users had all rights to a report, that users other than the one who created it could run it but not modify or delete it, or that only the user who created it could see it at all.

• Stonefield Query now supports role-based security for reports, folders, and the data dictionary. The Maintain Authorized Users dialog is now called Maintain Users and Groups ("groups" being the name we chose for "roles"). You can define new groups besides the built-in ones ("Everyone" and "Administrators"), such as "Clerks," "Managers," and "Senior Executives," and you can indicate which groups (there can be more than one) a user belongs to. The user who creates a folder or report can then specify which groups have what type of access to it. For example, a report which the Everyone group has access to means everyone has complete access to the report (run, modify, or delete). Removing the Everyone group and adding the Managers group means the report won't appear for anyone who isn't in the Managers group.

• You can now create users with blank passwords if you wish. You are asked to confirm that the password can be blank.
  

Quick Report Wizard

• The Quick Report Wizard has been reorganized so data selection is now in Step 2 rather than Step 3. This allows you to more quickly get to the most important task in the wizard. Also, formatting tasks have been combined into Step 5, including access to the Advanced Report Designer.

• Stonefield Query now supports customizable report templates. A report template specifies certain formatting information about a report, such as the placement of new fields, default objects in the page header and footer, and so forth. The template used for quick reports, which was previously internal to Stonefield Query, is now the "standard" template. You can modify this template if you wish or create new templates using the new Template Editor. Some uses for templates are having a company logo on every report or creating different layouts for different users. You can specify which template is the default one used for new reports in the Options dialog, available from the Tools menu.

• The Field Properties dialog now has options for dynamic font style and color (see the description of this feature in the Advanced Report Designer topic).

• The Field Properties dialog also has more data trimming options. For example, you can specify that data is cut off if the column is too narrow but that an ellipsis appears at the end of the text, making it obvious that some data isn't displayed. It also supports displaying blanks instead of " / / " for empty date values.

• The Field Properties dialog has new "use default" options. Turning these options on (which they are by default) tells Stonefield Query to use the default formatting for the field as defined in the data dictionary. The advantage of this setting is that changes made to the formatting in the data dictionary after a report has been created are applied to existing reports.

• There are a couple of new properties for grouped fields that can be specified in the Field Properties dialog. The first is when each group appears on a new page, whether the page number is reset to 1 or not. The second is sort order for groups, either ascending or descending; previously, groups were automatically sorted in ascending order. Also, the Bookmark option was moved to the Grouping page, since it's only available for grouped fields.

• If the Reset page number to 1 option discussed above is turned on, the summary band (which shows a total count of records and any grand totals) is omitted because it would appear at the end of the last group, which wouldn't make sense.

• The default font and size for a report now affects not just new fields but existing fields that weren't changed from the defaults. This makes it easier to change the font and/or size for all the fields in a report.

• Certain report objects, such as the page header and footer, now use the entire paper width rather than the report width, making better use of the paper. This also prevents the case where a narrow report (just a few short columns, for example) with a long filter has extensive word wrapping in the filter expression shown in the page header.

• The Customize button in Step 2 of the Quick Report Wizard has been renamed to Advanced. The Customize Wizard has a new first page: Advanced Settings. The options in this page allow you to indicate whether duplicate records are included or not and specify TOP N values for the report.
  

Cross-Tab Wizard

• Cross-tab reports also support customizable report templates.

• There's a new setting in the Formatting Options page for cross-tab reports: Place subtotals above details. If this option is turned on, subtotals for row records are shown in the row record rather than in a "subtotal" record.

• A new _SUBTOTAL field is automatically added to the result set for cross-tab reports. This field contains True for the subtotal row and False for the rest of the rows. You can use this in the Print When expression of a report object in a template to, for example, highlight subtotal rows by including a colored rectangle.
  

Advanced Report Designer

• The Advanced Report Designer has had a major overhaul. The properties dialogs are now cleaner and easier to use. For example, you can change all of the properties for a field in one place, rather than having to bring up one dialog for the font and another for the expression. The new Report Properties dialog combines the features of the Page Setup, Title/Summary, data grouping, Variables, and Set Grid Scale dialogs from earlier versions, plus adds new features as well. Options that don't make sense have been eliminated from dialogs.

• You can now preview the report right within the Report Designer without having to first save and close the report.

• You no longer need to know the real table and field name for a field when you add it in the Report Designer. When you click the Expression Builder button (the button with the ellipsis) in the Field Properties dialog, the new Expression Builder dialog displays the same descriptive table and field names you see in the Quick Report Wizard.

• The names displayed for fields reflect their purpose rather than the actual expression. For example, instead of showing "loReport.GetReportHeader()," the page header field shows "Page Header."

• You can now specify the exact size and position of an object by typing the top, left, height, and width values in the properties dialog rather than having to carefully move or resize it one pixel at a time to get it to the correct place and shape.

• Stonefield Query now supports dynamic font style and color. Dynamic means that the font style and/or color for a particular field changes from record to record depending on an expression you specify. For example, you could indicate that an amount field appears in red if the value is negative and black if positive, or you can make the amount bold if it's more than $5000 to make it stand out more.

• Stonefield Query now supports rotation of objects. This is handy, for example, to place the headings of narrow columns at a 45 degree angle so the columns can be placed closer together.

• Stonefield Query uses a new graphics engine, called GDI+, for rendering reports. This provides smooth scaling of text and images, even at large magnifications. Since GDI+ requires slightly more space to render text than the older graphics engine (GDI) used by previous versions, it's possible some advanced layout reports might not render quite right using the new reporting engine, so by default, existing advanced layout reports are rendered using the old report engine. Step 5 of the Quick Report Wizard allows you to switch between the two engines.

• Reports with multiple columns (such as mailing labels) have better support: group headers now appear on their own row rather than taking up one of the data columns, and they can now span multiple columns.

• Report directives are no longer put into the Comment property of report objects so this property can be used for true comments.

• Stonefield Query now allows you to specify the Script setting for a font. This is important for different languages, such as Cyrillic, Japanese, Hebrew, and Arabic, which require the proper setting be used to display text properly. In addition, text alignment works better than before in both left-to-right and right-to-left languages.

• The variables used for counting total records and records in groups in reports were renamed to more understandable Report_RecordCount and Report_GroupCount<N>.
  

Other Improvements

• The Preview window has several improvements. There are new buttons in the toolbar allowing you to specify the number of pages displayed at a time. The new Find and Find Next functions allow you to quickly locate text anywhere in the report. You can now scale a report above 100%: 200, 300, and 500% are supported. A shortcut menu is available. The toolbar is now automatically docked. If you click the Print button, the Current Page option is available to print just the current page.

• TIFF, GIF, and PNG images are now supported in PDF and RTF output; formerly, only BMP and JPEG files were supported.

• Online activation has been implemented. When you purchase a license of Stonefield Query, we will provide you with a serial number. In the Registration dialog that appears when you activate Stonefield Query, enter the serial number and click the Online button. After a few seconds, an activation code will be filled in and you can click Finish. This means you can activate Stonefield Query without having to contact Stonefield Software Inc.

• Auto-completion is now available in the To and Subject text boxes in the Email dialog. Auto-completion means that as you type, a drop-down list of previously entered values appears, from which you can select an item rather than typing the entire item again. This is similar to the way the address bar works in Internet Explorer, for example.

• There's better performance for all types of file output, especially PDF and Word.

• You can now indicate that external Visual FoxPro reports, imported using the External Report Wizard, can be edited in the Quick Report Wizard.

• When you compare a field to an expression in the Filter Conditions dialog, new Expression Builder buttons (the buttons with the ellipsis) launch the new Expression Builder, making it much easier to enter an expression. There's even a drop-down list of commonly-used expressions available so you don't have to know the expression for "last day of the month," for example. In addition, you can now use fields in an expression filter. For example, you could create a filter on OrderDate is less than ShippedDate - 30 (that is, all items that took more than 30 days to ship).

• The Schedule Report Wizard now allows a blank password.

• You are no longer prompted if you want to exit the application when clicking its close box.

• You can now print or output reports to file when the program is unactivated. However, you must activate it within 30 days or it will stop working. The activation "nag" screen reminds you of how many days you have left. You are also asked to login whether the program is activated or not.

• Stonefield Query was updated for use with the new ACT 2006.

• A new "Secondary Contacts" table is available if you use ACT! 2006; it won't appear if you use ACT! 2005 since that table isn't available for reporting.

• A new "Combined Main & Secondary Contacts" table is now available if you use ACT! 2006. This table combines the records in the main Contacts table and the Secondary Contacts table. It includes a "Contact Record Type" field to distinguish whether a record is from the Main or Secondary contact table.

• Stonefield Query is now able to properly relate the Company and Contact tables.

• The calculation of "Local Time" fields has been improved, in order to properly account for Daylight Savings Time. Also, the time zone display on the About dialog has been improved.

• There are some inconsistencies in the field naming conventions used by different ACT! databases. Stonefield Query now knows about the alternate field names, so reports written against databases with one naming convention will not break when run against other databases.

Version 1.07

• ACT! stores date and date/time values in the database in Greenwich Mean Time (GMT) format. However, the ACT! interface displays these values in the local time of the Windows machine. Stonefield Query now makes two fields available for each such field in the database: one GMT field and one Local Time field.

• In ACT! version 7.0.3, some new tables were made available for reporting. These have now been made available in Stonefield Query as well. The new tables are: Company History, Company Note, Group History, Group Note, and Group Opportunity. These tables have the same field structure as the Contact History, Contact Note, and Contact Opportunity tables, but they are related to the Company and Group tables rather than Contact.

• All custom fields in ACT! 2005 databases are now available for reporting if you are using ACT! version 7.03.

• The MyRecord information for the ACT user is now available in a MYRECORD table in Stonefield Query. This information can be added in the Advanced Report Designer with field expressions such as MYRECORD.USERLOGIN, MYRECORD.ROLENAME, etc.

• Six new pre-defined reports are available.
  

Version 1.06

• A new output type, Excel - Full Format, is now available. This format reproduces the layout of a report as closely as possible, including formatting and calculated fields. The former Excel output, which outputs data only with no formatting, is now called Excel - Data Only.

• Stonefield Query now has a built-in scheduler for reports.

• If you turn off the Auto-fit Column setting for a field, you can now determine whether the contents of the field wrap within the specified column width (the default) or are cut off.

• You can now rename the ADMIN user in the Maintain Authorized Users dialog if you wish.

• If EXIT is specified as a command-line parameter, Stonefield Query now displays no user interface at all unless needed, such as asking the user to login if no user name was specified, prompting for ask-at-runtime values if they weren't specified, or if a report is to be previewed.

• You can now specify the type ("data" or "full") for Excel, HTML, and Word output when running a report from another application or a batch file.

• The Filter dialog now has a Count button that displays the number of records expected for the selected report and filter conditions.

• The year is now included in the column headers when you choose Month or Quarter for the "Display date as" setting in the Properties dialog of the Cross-Tabulation Wizard.

• You can now have Stonefield Query display an image associated with a record if the image file name is stored in one of the fields in that record.

• A bug that prevented reports from being emailed when reports are run from other applications or a batch file was fixed.

• A bug in outputting cross-tab reports to HTML was corrected.

• 21 new pre-defined reports are available.

• You can now sort and group on many fields that previously you couldn't.

• The default for fields containing money amounts is to display dollar signs, commas, and two decimal places so they appear as $999,999.99 rather than 999999.9999.

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