Stonefield Query for Sage Accpac ERP 
Features What's New in This Version Running Stonefield Query Licensing Demo Version Software Maintenance Pre-Defined Reports and Labels 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 Contact in Google Maps Maintaining Users and Groups Managing Databases Creating an ODBC Data Source SQL Server Pervasive ODBC Engine Interface Pervasive ODBC Client Interface Pervasive Software ODBC-32 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