Stonefield Query for ODBC Reporting

The Stonefield Query SDK (software development kit) allows you to configure, integrate, and deliver custom end-user ODBC reporting solutions. Whether you are looking for an ODBC data mining, data analysis, data management, or ODBC reporting tool to simply extract information from your ODBC database, Stonefield Query can meet most of your needs.

Use the Configuration Utility that is included with the SDK to create the data dictionary, configuration, and script files for your database. Then deploy Stonefield Query to your users and let them start creating the ad-hoc reports they need in just a few easy steps.

Stonefield Query for ODBC Reporting allows you to connect to any ODBC database or any other OLE DB-compliant database. Stonefield Query also supports non-traditional data sources like flat text files and data that can only be accessed through an API.

Stonefield Query for ODBC Reporting Features

Stonefield Query for ODBC Reporting has hundreds of features, too many to list here. The most commonly inquired about features are documented below. For a complete list features, see the Online Help documentation found under each Solution.

Choose from four different report types from your ODBC data: Quick Reports (row and column layout), Cross-Tabulation Reports (like pivot tables, for analysis), Charts/Graphs (pie, bar, etc.) and Labels (mailing, barcode, etc).
Live Links: This allows you to create reports that drill down to other reports (for example, clicking on a customer name to show the sales for that customer) or automatically bring up someone's email address in your email program or Web site in your browser.
Output Options: Stonefield Query supports output to comma-delimited (CSV), Image Formats (.bmp, .gif, .jpeg, .png, .tiff), Microsoft Excel® (XLS), Microsoft Word® (DOC), Open Office (Calc & Writer), PDF, Rich Text Format (RTF), Table Format (DBF), Text (.txt), Web Page (HTML), XML, and XPS (.xps).
Report Templates: Choose from one of the supplied templates or use the Template Editor to build your own.
Report Sample: See a snapshot of what the report looked like the last time you ran it.
Report Scheduler: Automate reports that need to go out on a regular basis.
Report Preview: See what the report will look like at each step of the report building process. There's no need to save and exit before viewing.
Role-based Security: Control access to a single report, group of reports, and/or specific modules by assigning users to groups. This allows you to restrict access to sensitive data.
Email Reports: Use a SMTP or MAPI email client to quickly email reports through Stonefield Query.
Label Wizard: Select any data in your system and choose from 87 different Avery label formats.
Advanced Report Designer: Customize the report layout beyond the report wizard settings using the Advanced Report Designer for complete report control.
Allows user to control font, color, alignment, heading, and column width for each field with a mouse click.
Allows user to group and sort on any field with a mouse click.
Automatically adjust a field’s column width to match the widest amount of data in the column. No time lost adjusting and aligning fields.
Unlimited Reports: Create an unlimited number of reports.
Favorites: Save frequently used reports into your user-specific Favorites folder for quick access.
Customize SQL Select: Stonefield Query for ODBC Reporting automatically generates a SQL Select statement for the report once fields have been selected. Advanced users can customize the statement if desired.
Detailed Help File: Read through our detailed online help or our 240+ page PDF reference manual. Topics include Tutorials, Using Stonefield Query, Menu Functions, How To, and Frequently Asked Questions.