Stonefield Query Reporting for SalesLogix

Stonefield Query for SalesLogix® is a user-friendly database report writing, query, and data mining tool designed specifically for SalesLogix. You no longer need to call an IT specialist every time you need a report. Now your sales people, administrative staff, and management can create their own reports in minutes. Stonefield Query for SalesLogix can handle virtually all of your reporting needs.

The latest version of Stonefield Query for SalesLogix is 3.30.3420. Read about the latest Stonefield Query for SalesLogix product details on our blog.

• Stonefield Query currently works with SalesLogix versions 5.0 to 7.5.
  
• Tables are organized into logical data groups. Rather than selecting from over a hundred tables when creating a new report, the user first selects the data group they wish to work with, then selects from the small set of tables in that data group.
  
• Customized table and field captions for base tables are automatically supported.
  
• Multi-Database Support: A single report can be run against each of your SalesLogix databases without making changes to the report.
  
• Calculated fields defined in SalesLogix, including those involving local joins, are automatically supported.
  
• User-defined tables, fields, and relationships are automatically supported.
  
• Stonefield Query for SalesLogix automatically retrieves lookup information for some fields, such as user name and activity or history type, so no data joins are required, resulting in greatly improved performance.
  
• Stonefield Query for SalesLogix can report on information in QuoteWerks, a quoting system that integrates seamlessly with SalesLogix.

Stonefield Query Reporting 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 of features, see the Online Help documentation found under each Product Solution page.

	Powerful query and reporting tool designed with the end-user in mind. Design reports in minutes, not hours or days.
	Simple "Wizard" Interface: After selecting a report from the list of available reports, you can select the sort order, enter filter conditions, and specify where the output goes (printer, text file, spreadsheet, screen preview, email, etc.).
	User-Friendly Names: Full English descriptions for all fields and tables rather than cryptic names and symbols. English operators such as "equals" and "greater than" instead of "=" and ">."
	"Real" Table/Field Names: Alternatively you can display "real" table and field names so it's easier to locate the table or field you want if you're familiar with these names.
	Knows Your Data: You don't have to know how your data is stored or how tables are joined (you don't even have to know what a "join" is). Stonefield Query handles complex join conditions between tables automatically.
	Report Types: Quick Reports (row and column layout), Cross-Tabulation Reports (like pivot tables, for analysis), Charts/Graphs (pie, bar, etc.), Labels (mailing, barcode, etc) and External Reports (Foxpro or Crystal Reports).
	Label Wizard: Easily create labels, including mailing labels, product labels, or barcode labels, without worrying about field positioning or label dimensions. All the common Avery label sizes are built-in.
	Field Customization: Control font, color, alignment, heading, and column width for each field with a mouse click. You can even let Stonefield Query automatically adjust a field’s column width to match the widest amount of data in the column.
	Data Grouping and Sorting: Group and sort on any field with a mouse click.
	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.
	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 (.htm), XML, and XPS (.xps).
	Email Reports: Use a SMTP or MAPI email client to quickly email reports through Stonefield Query (in any file format listed above).
	Formula Editor: You can define your own custom calculations to use in any report.
	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 Templates: Give your reports a common appearance, such as following corporate style guidelines. Choose from one of the supplied templates or use the Template Editor to build your own.
	Report Scheduler: Automate reports that need to go out on a regular basis.
	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.
	Share Reports: Import reports so you can use report layouts designed by other users or consultants. Export reports so you can share report layouts with other users.
	Advanced Report Designer: Customize the report layout beyond the report wizard settings using the Advanced Report Designer for complete report control.
	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.
	Customize SQL Select: Stonefield Query automatically generates an 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 410+ page PDF reference manual. Topics include Tutorials, Using Stonefield Query, Menu Functions, How To, and Frequently Asked Questions.