Stonefield Query for AccountMate
Stonefield Query for AccountMate
Features
What's New in This Version
Running Stonefield Query
Licensing
Demo Version
Pre-Defined Reports and Labels
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
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
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
Variables
Examples
Function Reference
Resources
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
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
Step 5: Standard Filter Options (Chart Report)
Step 6: Security Options (Chart Report)
Previewing Chart Reports
Saving or Canceling Chart Reports
Customizing the Report Execution
Editing a Report
Copying a Report
Moving or Copying Reports to Other Folders
Deleting a Report or Folder
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
How To
Activating Stonefield Query
Changing the Location for Reports and Other Files
Changing Your Password
Configuring Stonefield Query
Creating a PivotTable Report Using Microsoft Excel
Creating and Using User-Defined Functions
Creating Labels or Formletters Using Microsoft Word
Creating Labels Using the Advanced Report Designer
Customizing the Stonefield Query Data Dictionary
Displaying an Image for a Record
Displaying only Certain Tables and Fields
Displaying the SQL Statement for a Report
Displaying Which Users are Logged in
Executing a SQL Statement During a Report Run
Handling Invalid Dates
Importing and Exporting Reports
Importing Email Addresses
Locating a Customer, Vendor, or Employee in Google Maps
Maintaining Users and Groups
Managing Licenses
Report on Multiple Databases in the Same Report
Running from Other Applications
Scheduling Reports
Selecting the Database
Setting up Stonefield Query
Understanding Stonefield Query Folders
Updating Stonefield Query to the Latest Version
Frequently Asked Questions
Database Issues
Error Messages
Installation and Setup
Other Problems
Program Features
Reporting "How Do I" Topics