Stonefield Query for Goldmine Version 4.3.5242

There are numerous new features in this release.

• Stonefield Query is compatible with Goldmine 2014.
• A new chart type is now available: Donut, which is similar to Pie but with a hole in the middle.
• The default settings for a new chart give it a more modern appearance, such as flat rather than 3-D and better colors.
• You can now define a chart with a second values field; this field is charted as a second series against the right axis.
• The Output each group as a separate file and Output each group as a separate email options now support charts on quick reports. In that case, each file has its own chart related to the group the file is for.
• The Filter Condition dialog now uses a more modern date picker control.
• The Add timestamp to file name setting is now available even when Erase file after email sent setting is turned on in the Output page of the Reports Explorer.
• A new output type is now available: Microsoft Word (*.docx), which creates Word 2007 or later files. The former Microsoft Word (*.doc) output type was renamed to Microsoft Word 97-2003 (*.doc) so you can tell them apart. The docx format is preferred as it's more accurate.
• The Check for Updates function in the Help menu is now only available if you are logged into Stonefield Query as an administrator.
• You can now change settings in the Format page of the Field Properties dialog for numeric fields in columns of cross-tab reports.
• The prompts in the Email page of the Options dialog have been changed to reflect the fact that SMTP is the preferred setting since MAPI can be unreliable, especially when emailing a scheduled report.

Stonefield Query for Act! Version 4.3.5242

There are numerous new features in this release.

• Stonefield Query is compatible with the new Act! 2014 Service Pack 1 (16.1).
• A new chart type is now available: Donut, which is similar to Pie but with a hole in the middle.
• The default settings for a new chart give it a more modern appearance, such as flat rather than 3-D and better colors.
• You can now define a chart with a second values field; this field is charted as a second series against the right axis.
• The Output each group as a separate file and Output each group as a separate email options now support charts on quick reports. In that case, each file has its own chart related to the group the file is for.
• The Filter Condition dialog now uses a more modern date picker control.
• The Add timestamp to file name setting is now available even when Erase file after email sent setting is turned on in the Output page of the Reports Explorer.
• A new output type is now available: Microsoft Word (*.docx), which creates Word 2007 or later files. The former Microsoft Word (*.doc) output type was renamed to Microsoft Word 97-2003 (*.doc) so you can tell them apart. The docx format is preferred as it's more accurate.
• New "Attendees (All)", "Attendees (Contacts)", and "Attendees (Users)" fields have been added to the Company Activity, Contact Activity, Group Activity, and Opportunity Activity tables in the Act! 2010+ data provider.
• New fields "Activity User ID", "Activity User Name", and "Is Organizer Record" have been added to the Company Activity, Contact Activity, Group Activity, and Opportunity Activity tables in the Act! 2010+ data provider.
• In the Act! 2010+ data provider activity tables, "Organizer" fields now appear as "Scheduled For" to match the Act! UI.
• The Contact Related Contacts table now shows data for both contacts in the relationship, rather than only for the parent contact.
• The Check for Updates function in the Help menu is now only available if you are logged into Stonefield Query as an administrator.
• You can now change settings in the Format page of the Field Properties dialog for numeric fields in columns of cross-tab reports.
• The prompts in the Email page of the Options dialog have been changed to reflect the fact that SMTP is the preferred setting since MAPI can be unreliable, especially when emailing a scheduled report.

Stonefield Query for Sage Pro Version 4.3.5242

There are numerous new features in this release.

• A new chart type is now available: Donut, which is similar to Pie but with a hole in the middle.
• The default settings for a new chart give it a more modern appearance, such as flat rather than 3-D and better colors.
• You can now define a chart with a second values field; this field is charted as a second series against the right axis.
• The Output each group as a separate file and Output each group as a separate email options now support charts on quick reports. In that case, each file has its own chart related to the group the file is for.
• The Filter Condition dialog now uses a more modern date picker control.
• The Add timestamp to file name setting is now available even when Erase file after email sent setting is turned on in the Output page of the Reports Explorer.
• A new output type is now available: Microsoft Word (*.docx), which creates Word 2007 or later files. The former Microsoft Word (*.doc) output type was renamed to Microsoft Word 97-2003 (*.doc) so you can tell them apart. The docx format is preferred as it's more accurate.
• The Check for Updates function in the Help menu is now only available if you are logged into Stonefield Query as an administrator.
• You can now change settings in the Format page of the Field Properties dialog for numeric fields in columns of cross-tab reports.
• The prompts in the Email page of the Options dialog have been changed to reflect the fact that SMTP is the preferred setting since MAPI can be unreliable, especially when emailing a scheduled report.
• There are now relationships between the Purchase Orders Invoices and Accounts Payable Vendors tables, between the Accounts Receivable Receipts/Adjustments and Adjustment G/L Distributions tables, and between the Return Material Authorization Details and RMA Kitting Details tables.
• You can now report on the Unit Price and Quantity fields in the Accounts Receivable Recurring Charge Details table.
• You can now edit a formula in step 2 of the report wizards when Application View is used.

Stonefield Query for Sage 300 ERP Version 4.3.5242

There are numerous new features in this release.

• Stonefield Query for Sage 300 now works with Sage 300 version 6.2 and earlier.
• A new chart type is now available: Donut, which is similar to Pie but with a hole in the middle.
• The default settings for a new chart give it a more modern appearance, such as flat rather than 3-D and better colors.
• You can now define a chart with a second values field; this field is charted as a second series against the right axis.
• The Output each group as a separate file and Output each group as a separate email options now support charts on quick reports. In that case, each file has its own chart related to the group the file is for.
• The Filter Condition dialog now uses a more modern date picker control.
• The Add timestamp to file name setting is now available even when Erase file after email sent setting is turned on in the Output page of the Reports Explorer.
• A new output type is now available: Microsoft Word (*.docx), which creates Word 2007 or later files. The former Microsoft Word (*.doc) output type was renamed to Microsoft Word 97-2003 (*.doc) so you can tell them apart. The docx format is preferred as it's more accurate.
• The Check for Updates function in the Help menu is now only available if you are logged into Stonefield Query as an administrator.
• You can now change settings in the Format page of the Field Properties dialog for numeric fields in columns of cross-tab reports.
• The prompts in the Email page of the Options dialog have been changed to reflect the fact that SMTP is the preferred setting since MAPI can be unreliable, especially when emailing a scheduled report.
• There are now relationships between the Purchase Orders Invoices and Accounts Payable Vendors tables, between the Accounts Receivable Receipts/Adjustments and Adjustment G/L Distributions tables, and between the Return Material Authorization Details and RMA Kitting Details tables.
• You can now report on the Unit Price and Quantity fields in the Accounts Receivable Recurring Charge Details table.
• You can now edit a formula in step 2 of the report wizards when Application View is used.

Stonefield Query SDK Version 4.3.5242

There are numerous new features in this release.

Report Designer

• A new chart type is now available: Donut, which is similar to Pie but with a hole in the middle.
• The default settings for a new chart give it a more modern appearance, such as flat rather than 3-D and better colors.
• You can now define a chart with a second values field; this field is charted as a second series against the right axis.
• The Output each group as a separate file and Output each group as a separate email options now support charts on quick reports. In that case, each file has its own chart related to the group the file is for.
• The Filter Condition dialog now uses a more modern date picker control.
• The Add timestamp to file name setting is now available even when Erase file after email sent setting is turned on in the Output page of the Reports Explorer.
• A new output type is now available: Microsoft Word (*.docx), which creates Word 2007 or later files. The former Microsoft Word (*.doc) output type was renamed to Microsoft Word 97-2003 (*.doc) so you can tell them apart. The docx format is preferred as it's more accurate.
• The Check for Updates function in the Help menu is now only available if you are logged into Stonefield Query as an administrator.
• You can now change settings in the Format page of the Field Properties dialog for numeric fields in columns of cross-tab reports.
• The prompts in the Email page of the Options dialog have been changed to reflect the fact that SMTP is the preferred setting since MAPI can be unreliable, especially when emailing a scheduled report.

SDK

• There's a new ReportEngine.BeforeCreateFile script that's called just before a report is output to a file or emailed. You can use this to change the report or output properties.
• You can now encrypt the file created when a report is output to file or email. In the case of a PDF file, the file itself is encrypted; other file types are added to an encrypted ZIP file which is used as the attachment instead of the file. To do that, create a ReportEngine.BeforeCreateFile script and set the new Report.EncryptPassword property to the desired password. If this property isn't blank, the file is encrypted.
• The Report object also has a new Folders property containing a comma-delimited list of the folders the report belongs to.
• The Application object now has a DashboardChart property containing the chart number being generated when a dashboard is previewed and 0 otherwise. This allows a script such as DataEngine.BeforeResultSetRetrieved to do different things for different charts such as prompting for values for the first one.
• The title bar of the window displayed when you choose the View Table Contents or View Field Contents functions now shows the number of records in the table.
• The Filter Data Dictionary dialog now uses a more modern date picker control.
• The Refresh function now removes fields from the data dictionary that were removed from their tables.
• Clicking the project location displayed in Studio's status bar now opens that location in Windows Explorer.
• The tooltip for the Join Type drop-down list in the properties pane for relationships now gives a better explanation of left and right outer joins.
• Creating a GetDataSources script for a database now turns off and disables the User Can Manage Data Sources configuration setting since those two are mutually exclusive.
• Clicking the Test button for a relationship now gives a warning if one of the tables is a virtual table since that can't be tested.
• You can now copy the serial number in Studio's About dialog, making it easier to specify your serial number when creating a support ticket.
• You can now use WSSetup.exe to do a workstation install from the server where the SDK is installed. This allows someone using Stonefield Query in-house to not have to create a setup installer to allow users to access the report designer.
• If you're querying against a Visual FoxPro database and you create a calculated field using the ALLTRIM() function as the expression, such as ALLTRIM(MyField), Stonefield Query may find more records than expected when the user filters on that calculated field due to the way string comparisons are done. In that case, add "UseAnsi=Y" to the [Options] section of SFQuery.INI. Note that isn't the same as the "UseAnsi=Y" setting in Data.INI; see the Stonefield Query help file (SFQuery.chm) for information on that setting.
• Reading the structure of a database now ignores the trace_xe_* tables added in Microsoft SQL Server 2012.
• MSMAPI32.OCX and MSCOMCT2.OCX are now longer installed or deployed to end-users because we now use different components for sending email via MAPI and date picker controls.

Stonefield Query Enterprise

Stonefield Software Inc. is excited to announce the release of Stonefield Query Enterprise, the newest version of our award-winning Stonefield Query product line.

Stonefield Query Enterprise is a complete rewrite from scratch using the C# language for the back-end engine components and ASP.NET MVC for the web front-end. The new version allows us to take advantage of the latest technologies.

Here are some of the features of this new product:

• Web UI: the current version of Stonefield Query is a desktop application. While it works great for the over 200,000 people using Stonefield Query, many of you want reporting for your web applications. Stonefield Query Enterprise gives you that solution.
  
• New reporting features: Stonefield Query Enterprise has many new features that are difficult or impossible to add to the current version. Some of these new features include:
  
  
  • Support for sub-reports
    
  • Displaying HTML and rich text with full formatting
    
  • Availability of other types of controls such as bar codes, QR codes, and check boxes
    
  • Sorting on group totals
    
  • Support for multiple column fields in cross-tab reports
    
  • Better localization of reports: headings appear in the language of the user running the report, not the one who created it
    
  • And many other great new features
    
• Rich API: every aspect of Stonefield Query Enterprise is exposed through our API. This makes it dead simple to integrate with your own application. You can create and run reports programmatically, manage security, or dynamically update the data dictionary as necessary.
  
• Extendible: you’ve always been able to extend and control the features of Stonefield Query through scripting. In Stonefield Query Enterprise, plugins take this to the next level. Because plugins have full access to the Stonefield Query object model, you can customize Stonefield Query Enterprise in ways you could only dream of before.
  
• Support for multi-tenant applications: Stonefield Query Enterprise was designed to work in a multi-tenant environment. Whether you have one database with row-level security for all customers or one database per customer, Stonefield Query Enterprise has you covered. Users can only see the records and reports for their own company. Of course, it works just fine in a single customer environment too.
  
• Updated Stonefield Query Studio: the developer part of Stonefield Query got a facelift too. It integrates with your custom plugins and functions so they’re available for expressions. Join trees give you fine control over how indirectly related tables are joined. You can now preview the contents of calculated fields and virtual tables and test joins between real and virtual tables. Value converters, either built-in or your own, change how the contents of a field appears in a report.
  
• Source code: we provide the source code for the web UI, allowing you to customize it to suit your needs. Changes can be a simple as altering styles in CSS files for a different look to changing controllers and views for different workflow or implementing different security rules.

Of course, Stonefield Query Enterprise still has the features that made Stonefield Query one of the few true user reporting solutions available, including:

• Ease-of-use: Your users don't have to know what a join is, let alone how to create a join for a particular set of tables. They don't have to know the names of tables and fields. They don't have to know how the data is stored. They simply tell Stonefield Query what they want and it figures out how to get the data they need. The simple “wizard” interface allows them to create reports in minutes, not hours.
  
• Report scheduling: Create as many schedules to run as many reports at any time as you wish, making report deployment a snap.
  
• Multi-database support: Stonefield Query can run reports on data stored in different databases, even if they use different engines. For example, you can create a report that shows customer information from a Microsoft SQL Server database and project information from an Oracle database. Create consolidation reports that pull, for example, invoices from different company databases onto a single report.
  
• Configurable: Customize Stonefield Query for your application. The data dictionary describes what the databases Stonefield Query can access look like: the tables, fields, and relationships between the tables; captions for tables and fields; output formatting for fields; and so on. Customize the behavior of Stonefield Query by changing configuration settings, such as whether users can schedule reports.
  
• Brandable: Easily create a private labeled or branded version of Stonefield Query. This allows you to distribute Stonefield Query as your own branded product, so your users won't know it's Stonefield Query from Stonefield Software; they'll think it's something you created just for them. This also allows you to sell your branded version for whatever price fits your business model.
  
• Localizable: Stonefield Query is fully localizable. Every dialog caption and message displayed to the user in Stonefield Query is defined in resource files. You can easily create multi-lingual versions of Stonefield Query, with each user working in the language they're most comfortable with.

Check out Stonefield Query Enterprise today. If you want to try it with your own data, download the demo from http://stonefieldquery.com/ (choose “Web version” from the Download menu). If you’d rather try out the report designer without installing anything, click the “Try it now” button at http://stonefieldquery.com/ to run the demo on our web site against the famous Northwind sample database.

Updated Web Site

Stonefield Query isn’t a single product; rather, it’s a family of products. On one hand, we have customized versions for specific applications, such as Stonefield Query for Sage 300 and Stonefield Query for ACT!. On the other, we have the Stonefield Query SDK, which any developer or consultant can use to create a customized reporting solution for any application. (In fact, we used the SDK to create the customized versions.) Unfortunately, that made our web site a bit of a mixed bag: we had to make it useful to two different audiences, which led to some awkward navigation. As a result, we’ve split the site into two:

• StonefieldQuery.com, the existing site, is now just for the SDK and our newest product, Stonefield Query Enterprise, a web version of Stonefield Query.
  
• StonefieldSoftware.com is a new site dedicated to our custom solutions.

Links in the Solutions menu of both sites take you to the other one.

We also used this as an opportunity to revamp the site, making it more modern and responsive on mobile devices.

Check out the new sites and let us know what you think; your feedback is important to us and much appreciated.