Simple
Simple
Detailed
Stonefield Query for GoldMine
Features
What's New in This Version
Installing Stonefield Query
Running Stonefield Query
Licensing
Trial Version
Sample Reports
Special Features in Windows 7 and Later
Software Maintenance
Technical Support
Copyright
Tutorial
Lesson 1: Creating a Report
Lesson 2: Running a Report
Using Stonefield Query
The Reports Explorer
Selecting a Report
Selecting Which Records to Include
Creating a Filter
The Filter Dialog
Adding a Condition
Editing a Condition
Deleting a Condition
Rearranging Conditions
Clearing the Filter
Counting Matching Records
Saving, Retrieving, and Deleting Filters
Ask at Runtime Filter Conditions
Selecting Which Records to Exclude
Choosing a Sort Order
Report Options
Output Options
Previewing a Report
Outputting to a Data Grid
Printing a Report
Creating a Folder
Editing a Folder
Creating a Report
Creating a Quick Report
Step 1: Main Report Information (Quick Report)
Step 2: Data Selection (Quick Report)
Field Properties (Quick Report)
Step 3: Standard Filter Options (Quick Report)
Step 4: Standard Sort Options (Quick Report)
Step 5: Formatting Options (Quick Report)
Step 6: Security Options (Quick Report)
Previewing Quick Reports
Saving or Canceling Quick Reports
Creating a Cross-Tab Report
Step 1: Main Report Information (Cross-Tab Report)
Step 2: Data Selection (Cross-Tab Report)
Step 3: Cross-Tabulation Options (Cross-Tab Report)
Field Properties (Cross-Tab Report)
Step 4: Standard Filter Options (Cross-Tab Report)
Step 5: Formatting Options (Cross-Tab Report)
Step 6: Security Options (Cross-Tab Report)
Previewing Cross-Tab Reports
Saving or Canceling Cross-Tab Reports
Choosing the Cross-Tab Report Engine
Creating a Label Report
Step 1: Main Report Information (Label Report)
Step 2: Data Selection (Label Report)
Field Properties (Label Report)
Step 3: Standard Filter Options (Label Report)
Step 4: Standard Sort Options (Label Report)
Step 5: Formatting Options (Label Report)
Step 6: Security Options (Label Report)
Previewing Label Reports
Saving or Canceling Label Reports
Creating a Chart Report
Step 1: Main Report Information (Chart Report)
Step 2: Data Selection (Chart Report)
Step 3: Chart Layout (Chart Report)
Field Properties (Chart Report)
Step 4: Formatting Options (Chart Report)
Edit Chart Dialog
Series Page
Area Series Page
Bar and Column Series Page
Line Series Page
Pie Series Page
Point Series Page
Chart Page
General Page
Axis Page
Title Page
Legend Page
Panel Page
Paging Page
Walls Page
3D Page
Pattern Color Editor
Border Editor
Gradient Editor
Numeric Format Editor
Pointer Editor
Shadow Editor
Filters Editor
Step 5: Standard Filter Options (Chart Report)
Step 6: Security Options (Chart Report)
Previewing Chart Reports
Saving or Canceling Chart Reports
Creating a Batch Report
Step 1: Main Report Information (Batch Report)
Step 2: Select Reports (Batch Report)
Step 3: Output Options (Batch Report)
Step 4: Security Options (Batch Report)
Saving or Canceling Batch Reports
Creating a Dashboard
Step 1: Main Report Information (Dashboard)
Step 2: Select Dashboard Reports (Dashboard)
Step 3: Security Options (Dashboard)
Saving or Canceling Dashboards
Creating a Gauge Report
Step 1: Main Report Information (Gauge Report)
Step 2: Data Selection (Gauge Report)
Step 3: Gauge Layout (Gauge Report)
Field Properties (Gauge Report)
Step 4: Formatting Options (Gauge Report)
Step 5: Standard Filter Options (Gauge Report)
Step 6: Security Options (Gauge Report)
Previewing Gauge Reports
Saving or Canceling Gauge Reports
Creating Your Own Formulas
Customizing the Report Execution
Editing a Report
Copying a Report
Moving or Copying Reports to Other Folders
Deleting a Report or Folder
Finding Reports
Advanced Report Designer
Menu and Toolbars
Report Properties Dialog
Report Bands
Report Objects
Field Object Properties
Label Object Properties
Picture Object Properties
Rectangle and Line Object Properties
Selecting Multiple Report Objects
Variables
Examples
Resources
Working with Templates
Editing a Template
Creating a Template
Copying a Template
Importing and Exporting Templates
Removing a Template
Adding an External Report
Expression Builder
Menu Functions
File Menu
Edit Menu
Tools Menu
Help Menu
Ribbon Functions
Home Tab
Data Tab
Tools Tab
Help Tab
How To
Activating Stonefield Query
Adding Stonefield Query to Your GoldMine Menu
Backing up Stonefield Query Data Files
Changing the Location for Reports and Other Files
Changing Your Password
Checking for News
Configuring Stonefield Query
Setting up Modern Authentication with Office 365
Creating a Desktop Shortcut
Creating a PivotTable Report Using Microsoft Excel
Creating a Relationship Between Tables
Creating and Using Custom Functions
Creating Form Letters Using Microsoft Word
Creating Groups in GoldMine
Customizing the Stonefield Query Data Dictionary
Dealing with Errors
Displaying an Image for a Record
Displaying the Most Recent Record
Displaying the SQL Statement for a Report
Displaying Which Users are Logged in
Executing a SQL Statement During a Report Run
Forcing All Users to Exit the Program
Grouping Values Together
Handling Invalid Dates
Importing and Exporting Reports
Importing Email Addresses
Locating a Contact in Google Maps
Maintaining Users and Groups
Managing Licenses
Managing Scheduled Tasks
Moving to a Particular Contact in GoldMine
Outputting a Wide Report Without Splitting Columns
Pinning a Report to the Taskbar
Report on Multiple Databases in the Same Report
Reporting on Other Data Sources
Reporting on Usage Statistics
Running from Other Applications
Scheduling Reports
Selecting the Database
Setting up Stonefield Query
Synchronizing with Reports Stored on a Server
Understanding Stonefield Query and GoldMine Data Sources
Understanding Stonefield Query Folders
Updating Stonefield Query to the Latest Version
Using a Server Database for Stonefield Query Data
Frequently Asked Questions
Database Issues
Error Messages
Installation and Setup
Other Problems
Program Features
Reporting
Appendix
Error Codes
Function Reference
Report Object Members
SFX File Structure