Stonefield Query is an award-winning, easy-to-use, ad-hoc report writer. It can query against any set of data that can be accessed from a PC. This includes:
Databases such as Microsoft SQL Server, Oracle, Pervasive, DB2, and MySQL.
Microsoft Excel spreadsheets.
Many other types of data.
Stonefield Query has a simple "wizard" interface. After selecting a report from the list of available reports, the user can preview the report or output it to one of several types of files (PDF, Microsoft Excel, RTF, etc.).
In addition to running pre-defined reports, they can create their own reports in just minutes. They simply select which fields to report on from the list of available fields (with meaningful descriptive names rather than cryptic names and symbols), and they're done! They don't have to know complex stuff like join conditions; Stonefield Query takes care of that for them.
What makes Stonefield Query easy to use is that it has detailed knowledge about the databases it queries against. This means the user doesn'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.
What gives Stonefield Query this knowledge about the databases is a set of application-specific configuration files. These files can be broken down into four groups:
Data dictionary: the data dictionary describes what the databases Stonefield Query can access look like: the tables, fields, and relationships between the tables. This information includes the caption for tables and fields, output formatting for fields (such as the format to use for numeric fields and any formulas or functions to use to convert the data from how it's stored to how the user expects to see it), the types of joins between tables (outer or inner), etc.
Configuration: this file describes how Stonefield Query behaves: what name appears in the title bar of the window, whether multiple data sets are supported or not, and so on.
Resources: you may wish to change the wording that Stonefield Query uses in various dialogs or support multiple languages for field and table captions. Resource files allow you to specify what to display to the user for certain key phrases.
Plugins: using plugins written in any Microsoft .NET language, you can customize the behavior of the report wizards, data retrieval, and report runs. Support for multi-tenant environments is easily implemented using plugins.
A set of application-specific configuration files is called a "project." Stonefield Query supports multiple projects; for example, you could have versions of Stonefield Query that report on an accounting system, a customer relationship management system, and a warehouse application, all running from the same single executable program.
You can create a private labeled or branded version of Stonefield Query by changing a number of configuration settings. This allows you to distribute Stonefield Query as your own branded product, so your end-users won't know it's Stonefield Query from Stonefield Software; they'll think it's something you've created just for them. This also allows you to sell your branded version for whatever price fits your business model.
Stonefield Query is fully localizable. Every dialog caption and message displayed to the user in Stonefield Query is defined in one or more resource files. You can easily create multi-lingual versions of Stonefield Query, with each user working in the language they're most comfortable with.
Stonefield Query Enterprise Studio
Stonefield Query Enterprise Studio is the tool you use to create and maintain the configuration files for a particular project. This help file describes how to use Stonefield Query Enterprise Studio and provides technical information on Stonefield Query.
Award-Winning Reporting Solutions
In May 2000, the reporting engine in Stonefield Query was awarded the Developer's Choice Award for Best Reporting Tool at the DevConnections 2000 conference in New Orleans, sponsored by Microsoft.
Customized versions of Stonefield Query have won several awards, including both the 2002 and 2003 Best Integration awards from FrontRange Solutions, makers of the GoldMine customer relationship management software and HEAT help desk automation system, and the 2008 Innovative Integration award from AccountMate Corp., makers of the AccountMate accounting system.