Stonefield Query has all of the built-in features you expect in a report generation and creation software solution including a Report Scheduler, Role-based Security, Report Templates, Drill Downs, Exclusion/Inclusion Filters, Emailed Reports, Customizable SQL Select, Advanced Report Designer and Multiple Output Options (PDF, HTML, XML, XPS, Excel®, CSV, Word®, RTF, DBF).
Now end-users can take advantage of the wealth of information stored in your business database when they need it. They can generate and create elegant and persuasive Quick Reports, Charts/Graphs, Cross-tabulation Reports and Labels (mailing, barcode, etc) in minutes with little or no technical knowledge.
The Stonefield Query Advantage
When integrating the award-winning Stonefield Query report generation and creation tool with existing software applications, this easy-to-use report generation and creation software solution from an industry leader can provide:
Ease of Use
Unlike generic report generation and creation software, Stonefield Query can be customized specifically for the database it's querying against. You don't have to tell Stonefield Query how to get the data; you simply tell it what you want and it will figure out how to get it. Everyone in the organization from the President to the receptionist can use the product. As a result, Stonefield Query saves technical staff time and alleviates the burden of creating every query and report an end-user could ever think of.
With generic report writers you are responsible for laying out fields, adjusting sizes and headings manually. Stonefield Query automatically places fields and headings on the report and sizes them appropriately. You can create a report in Stonefield Query in just seconds with only a few mouse clicks. Grouping, sorting, totaling fields, and filtering are as simple as selecting the desired option from a list.
Stonefield Query uses SQL SELECT statements to retrieve records from the database, so only those records that match the filter are accessed. This can have an enormous impact on the performance of the query. For example, one Stonefield Query user told us that a report they created in Crystal Reports takes over 25 minutes to run, but the same report in Stonefield Query takes just 15 seconds. That's 100 times faster.
Stonefield Query can access nearly any kind of database, including SQL Server, Oracle, Access, Visual FoxPro, Pervasive, DB2, MySQL and even non-database formats like comma delimited text files. Stonefield Query also supports querying on multiple data sets. For example, you may have an accounting system's data stored in SQL Server and customer data stored in ORACLE. All you have to do is define how the SQL and Oracle tables are related, and Stonefield Query will take care of the rest.
Stonefield Query supports role-based security at the field, table and report level. This means you can control access to any information stored in your system.
Stonefield Query fulfills a valuable need every organization has: the access to information. More importantly, it allows the people who need the information the most, the ability to get it themselves.
Visit our website at stonefieldquery.com to download a free full function trial version.