Stonefield Query Features

Stonefield Query 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: 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's a fields 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 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.