Stonefield Query Features

Stonefield Query is what gets deployed to end-users and customers. It's the tool they will use to create and run reports.  These features make it easy for even the most novice user to create and run reports

Stonefield Query Features

• 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 adjusts a fields column width to match the widest amount of data in the column. No time lost adjusting and aligning fields.
• 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).
  
• Report Templates: Choose from one of the supplied templates or use the Template Editor to build your own.
• Exclusion filters: this allows you to query on the absence of data, such as "give me a list of customers I didn't contact last year" or "give me a list of everyone who did not buy product X". Behind the scenes, Stonefield Query generates a NOT IN subquery, but from the end-user's perspective, it's just as easy as creating a normal filter.
• 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.
  
• 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.
  
• Create an unlimited number of reports.
  
• Favorites: Save frequently used reports into your user-specific Favorites folder for quick access.
  
• 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).
  
• 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. The Advanced Report Designer allows you to lay out the report exactly as you want, including company logos, lines, boxes, etc.
  
• Stonefield Query automatically generates a SQL Select statement for the report once fields have been selected. Advanced users have the option to customize the select statement if needed.
  
• Includes a detailed help file. Available online and in PDF format. Topics include Tutorials, Using Stonefield Query, Menu Functions, How To, and Frequently Asked Questions.