Thursday, May 29, 2014

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.

Wednesday, May 28, 2014

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.

Friday, May 9, 2014

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.

Wednesday, May 7, 2014

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:

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.

Tuesday, September 10, 2013

Stonefield Query for Act! version 4.3.4878

This release adds compatibility with the new Act! 2014 (16.0), as well as a few new features.
  • Stonefield Query is now compatible with the new ACT! 2014 (16.0).
  • More than 25 new sample reports have been added for use with ACT! 2010 and later databases.
  • If you add "KeepLog=N" to Data.INI, Stonefield Query creates separate diagnostic files with a timestamp as part of the filename so individual logs are created for each run.
  • You can now use detail header and footer bands in templates.
  • Stonefield Query now creates a default filename when emailing reports.
  • You can now specify what "mail mode" to use when emailing via SMTP. This is helpful if problems arise with some types of SMTP servers.
  • Emailing each group in a report to separate email addresses now continues to send even if one or more of the addresses is invalid if the Continue Running Reports if Cannot Connect or One Report Fails setting is turned on in the Options dialog.
  • Administrator users can now edit any report even if it has security so it's only accessible to one user.

Tuesday, May 14, 2013

Stonefield Query SDK Version 4.3.4878

This is mostly a maintenance release, but there are a few new features.

  • If you add "KeepLog=N" to Data.INI, Stonefield Query creates separate diagnostic files with a timestamp as part of the filename so individual logs are created for each run.
  • You can now use detail header and footer bands in templates.
  • Stonefield Query now creates a default filename when emailing reports.
  • You can now specify what "mail mode" to use when emailing via SMTP. This is helpful if problems arise with some types of SMTP servers.
  • Emailing each group in a report to separate email addresses now continues to send even if one or more of the addresses is invalid if the Continue Running Reports if Cannot Connect or One Report Fails setting is turned on in the Options dialog.
  • Administrator users can now edit any report even if it has security so it's only accessible to one user.
  • The New Project Wizard now defaults to your Documents folder so projects are created there by default and adds the project name to that folder.
  • French messages have been updated to the current version of Stonefield Query.

Tuesday, January 22, 2013

Stonefield Query for Sage ACT! Version 4.3

We are pleased to announce the release of version 4.3 of Stonefield Query for Sage ACT!. Here are the new features in this version.
  • Stonefield Query for ACT! has been renamed to Stonefield Query for Sage ACT!, to match the latest naming convention of Sage ACT! itself.
  • You can now create batch reports. A batch report automatically runs several reports, outputting each to the desired destination. This is handy if, for example, you normally run the same three reports at the end of every week. Rather than choosing them one at a time, you can create a batch report that combines those three reports and just run it. You can even schedule batch reports.
  • You can now append the output of a report to an existing Microsoft Excel output file. In that case, the report appears in a new worksheet (tab) within the spreadsheet. This even works if the file is already open in Excel. You can also now choose XLSX or XLS as the extension for a Microsoft Excel output file.
  • Turning on the new Start each group on a new page option for the first row field in a cross-tab report causes each group of records to appear on its own page. You can also now turn on the Output each group as a separate file and Output each group as a separate email settings so each group is output to its own file or email.
  • The new Delimited - Microsoft Excel Format output type outputs to a comma-separated values (CSV) file but uses Excel formatting so things like leading zeros are preserved when the file is opened in Excel.
  • Formulas are now stored in the same folder as reports (in a file named CalcFields.DBF) so if the program runs on a workstation but reports are shared on a server, so are the formulas. For backward compatibility, the program will still look for CalcFields in the Data subdirectory of the program folder so you won't lose your formulas, so this works better for new installations rather than existing ones.
  • You can now enter a formatted SQL statement in the SQL Statement step of the Customize Report dialog. For example, carriage returns and tabs are now permitted. This makes it easier to take a SQL statement from another application and paste it into a report's SQL statement. Note that this change now requires you to prefix procedural code with "*-" if you want to use code rather than a SQL statement (a rare occurrence).
  • Microsoft Excel full-format output works better now: the output has a single page header at the top of the document and a single page footer at the bottom rather than header/footer sections where the pages would normally break, and the use of empty columns and rows for positioning is minimized.
  • Stonefield Query now handles font scripts other than Western, such as Cyrillic or Greek. You can select the desired script in the Font dialog that appears when you click the font button in the Field Properties dialog of a report wizard or in the Advanced Report Designer.
  • Clicking the Add All or Remove All buttons in Step 2 of the report wizards now display a prompt asking you to confirm if you want to do that to prevent inadvertently adding all fields in a table to a report or removing all fields from a report.
  • The application no longer erases the diagnostic log (Diagnostic.txt in the Data subdirectory of the program folder) if KeepLog=Y is in Data.INI. This is useful for checking diagnostics over multiple runs, such as for scheduled reports.
  • You can now resize dashboard windows to a much smaller size than before.
  • You can now edit a chart that's included in a quick report with an advanced layout. The Size page in Step 4 of the Chart Wizard is now disabled in that case, since you cannot change the chart size.
  • You can now click the serial number in the About dialog (available from the Help menu) to copy your serial number to the clipboard. This makes it easier to enter the serial number when creating a ticket in our online support ticket system.