Stonefield Query provides a step-by-step method to create professional reports from virtually any database. Anyone can create detailed reports, high level overview, drill-down/drill-through, charts/graphs, pivot tables, and more in minutes not hours.
Quick Report Creation Time
Use Stonefield Query to create reports quickly and efficiently. The reporting process is broken down into adding the information for the report, narrowing down the information through filters/exclusions, sorting, and finally defining who has access to the report.
Schedule and Automatically Deliver Reports
Automatically deliver reports via e-mail, file, or printer.
Control security with Report Permissions, Field Access Control, Data Item Access Control, and User Security. The developer also has control for Menu Permissions when setting up the data dictionary for the end-users.
Stonefield Query enables you to localize your Stonefield Query project, you can add any language via the Resource Editor and give the user the ability to switch between available language formats.
Multiple Data Source Support
Stonefield Query can run reports on more than one database of the same structure as well as databases of different structures and type. For example, you can run a report against an Oracle and Microsoft SQL Server database at the same time.
Stonefield Query Web gives you the ability to intercept the operations at all key points and to conditionally execute your own code. This includes conditional filtering, implicit filtering, filter data before publishing (record security checking), etc.
Filters and Exclusions
Filter parameters allow you to narrow down your results without programming. A filter example would be All Users with Closed Opportunities or Sales in the last 30 days. Exclusions allow you to report on things that are not recorded in your database. An example would be all Contacts that have not been called in the last Year or All Contacts that do not have an Opportunity/Forecasted Sale in the last 60 days.
Charts, Graphs and Dashboards (coming in version 2, summer 2014)
Create bar, graph, line, area, and pie charts as well as series charts and graphs. Dashboards combine multiple charts into one consolidated view of your data. Zoom in and out on the dashboard, update individual reports manually, and output the dashboard to file.