CALL TODAY: 845-221-3800

Help Desk Support

With a complete team of Certified technicians and tech support staff, you can be sure that you get the help you need, when you need it.

"I am really impressed wth your company. I hope that I can figure out how to give my customers the same quality of customer support that you guys do."

David Davis
Livebythepark Inc. ©

Stonefield Query BI Reporting for GoldMine


		Free Trial Download Watch a Video Product Versions: SFQ for GoldMine SFQ for HEAT SFQ for QuoteWerks

Stonefield Query for GoldMine® is a user-friendly database report writing, query, and data mining tool designed specifically for GoldMine.

Now you can put Business Intelligence reporting in the hands of the end-user where it belongs.

Stonefield Query has been customized specifically for GoldMine giving you an intuitive, easy-to-use BI reporting solution that you will love!

To try Stonefield Query with your own GoldMine data, download a 30-day trial today!

Stonefield Query has all of the built-in Features you expect in an enterprise reporting 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 your sales people, administrative staff, and management can take advantage of the wealth of information stored in your GoldMine system when they need it.

You can create elegant and persuasive Quick Reports, Charts/Graphs, Cross-Tabulation Reports and Labels (mailing, barcode, etc) in minutes with little or no technical knowledge. No more waiting for the already overburdened IT or report developers to build reports on their timetable.

Stonefield Query Reporting Features

Stonefield Query has hundreds of features, too many to list here. The most commonly inquired about features are documented below.

Stonefield Query is a powerful Business Intelligence(BI), Query and Database 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.

GoldMine Specific Features

Works with GoldMine version 8.5 and earlier
All fields (even user-defined fields) appear with the caption you've assigned (global or local label) rather than the field name or "User-Defined 2"
Fields are organized into logical groups (matching the tabs that appear in GoldMine) rather than their actual tables
Can create groups in GoldMine
Includes more than 60 pre-defined Sample Reports
Detail Types you've customized in GoldMine appear as separate tables in Stonefield Query, showing only the appropriate information for that particular Detail Type
If you use Details Plus, Stonefield Query will use the customized headings and data types you specify in Details Plus
You can link a report to GoldMine so that clicking on a field in that report automatically moves GoldMine to the selected Contact record
Can report on QuoteWerks data stored in GoldMine

Stonefield Query Advantage

When you use the award-winning Stonefield Query BI reporting tool for GoldMine, you provide your staff with an easy-to-use solution from an industry leader. You can:

Increase productivity throughout your organization.
Reduce your support costs
Uncover opportunities in your GoldMine system

Ease of Use

Unlike generic report writers, Stonefield Query has been customized specifically for GoldMine. 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 Stonefield Query for GoldMine. Stonefield Query saves technical staff time and alleviates the burden of creating every query and report an end-user could ever think of.

Productivity

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.

Performance

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.

Security

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 GoldMine system. Restrict access to custom fields and other sensitive information in a few mouse clicks.

Value

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. In most cases, the cost of a single Crystal report is more expensive than Stonefield Query. Stonefield Query delivers the largest return on investment than any other add-on product.