About.Settings
Accessing Local and Remote SQL Server Databases
Accessing Multiple Data Sources
Activating Stonefield Query Studio
Active
AddItem (Class Users)
      AddItem (Class Databases)
      AddItem (Class Fields)
      AddItem (Class FilterConditions)
      AddItem (Class AppViewFields)
      AddItem (Class AppViews)
      AddItem (Class CustomJoins)
      AddItem (Class DataSources)
      AddItem (Class Folders)
      AddItem (Class Joins)
      AddItem (Class Parameters)
      AddItem (Class ReportFields)
      AddItem (Class Reports)
      AddItem (Class Sorts)
      AddItem (Class Tables)
      AddItem (Class Values)
      AddItem (Collections)
      AddItem (Class AskAtRuntimeValues)
      AddItem (DataSources.AddItem)
      AddItem (Fields.AddItem)
      AddItem (FilterConditions.AddItem)
      AddItem (Parameters.AddItem)
      AddItem (ReportFields.AddItem)
      AddItem (Values.AddItem)
AddItem Method
AddProperty (Class SFQApplication)
      AddProperty (Application Object)
      AddProperty (SFQApplication.AddProperty)
AddToFavorites (Class DataEngine)
      AddToFavorites (DataEngine Object)
AddToFields (Class DataEngine)
      AddToFields (DataEngine Object)
AddToWhere (Class DataEngine)
      AddToWhere (DataEngine Object)
Adding Existing Scripts to a Project
Adding a Database at Runtime
Adding a Database to the Data Dictionary
Adding an Existing Data Dictionary to a Project
Address1
Address2
Administrator (Class User)
      Administrator (Class Users)
Advanced (Class Report)
      Advanced (Class User)
      Advanced (Class Users)
Alias (Class ReportField)
      Alias (Class Field)
      Alias (Class Table)
      Alias (Class Sort)
AliasFilter
Allow Access to Reports When No Access to Fields
Allow Multiple Data Sources
Allow Queries on Multiple Data Sources
AllowDuplicates
AllowEmptyResultSet
AllowFilter
AllowSort
AllowValues (Class ReportField)
      AllowValues (Class Field)
Allowing the User to Manage Data Sources
AppView Object
AppView.Caption
AppView.DataGroup
AppView.ErrorMessage
AppView.Fields
AppView.Key
AppView.MainList
AppView.Order
AppView.ParentKey
AppViewField Object
AppViewField.Caption
AppViewField.ErrorMessage
AppViewField.FieldName
AppViewField.Heading
AppViewField.Order
AppViewFields Collection
AppViewFields.AddItem
AppViewFields.Clear
AppViewFields.Count
AppViewFields.ErrorMessage
AppViewFields.Item (Class AppViewFields)
AppViewFields.RemoveItem (Class AppViewFields)
AppViews
AppViews Collection
AppViews.AddItem
AppViews.Clear
AppViews.Count
AppViews.ErrorMessage
AppViews.Item (Class AppViews)
AppViews.RemoveItem (Class AppViews)
Application Name
Application Object
Application Views
Application.AfterSetup
Application.BeforeLogin
Application.BeforeSetup
Application.BeforeShowWizard
Application.BeforeShutdown
Application.GetDefaultTargetAppDir
Application.GetShortcutParameters
Application.ReportsExplorerActivated
Application.ReportsExplorerReady
Application.SetupMenu
Application.Shutdown
Application.SubmitTicket
Application.ValidateCommonDir
Application.ValidateTargetAppDir
ApplicationDataDirectory
ApplicationDirectory
ApplicationName
Ascending
AskAtRunTime (Class Report)
      AskAtRunTime (Class FilterCondition)
AskAtRuntimeOnly
AskAtRuntimeValues.AddItem
Autofit
BCCRecipients
BackColor
BaseURL
Bookmark
Business Issues
CCRecipients
Calculated (Class ReportField)
      Calculated (Class Field)
Calculated Fields That Call Scripts
CallMethod
CalledFromProxy
CanEditReports
CancelReport
Caption (Class ReportField)
      Caption (Class Field)
      Caption (Class Table)
      Caption (Class AppView)
      Caption (Class AppViewField)
      Caption (Class Sort)
CaseSensitive
Changing the File Description for SFQuery.exe
Chart
ChartFormat
ChartInputMask
ChartOrder
ChartTotalType
ChildExpression
ChildTable
City
Class AppView
Class AppViewField
Class AppViewFields
Class AppViews
Class AskAtRuntimeValues
Class CustomJoin
Class CustomJoins
Class DataEngine
Class DataSource
Class DataSources
Class Database
Class Databases
Class Field
Class Fields
Class FilterCondition
Class FilterConditions
Class Folder
Class Folders
Class Join
Class Joins
Class Parameter
Class Parameters
Class ReflectionService
Class Report
Class ReportEngine
Class ReportField
Class ReportFields
Class Reports
Class SFQApplication
Class SQProxy
Class Settings
Class Sort
Class Sorts
Class Table
Class Tables
Class User
Class Users
Class ValueItem
Class Values
Cleaning up the Project
Clear (Class Users)
      Clear (Class Databases)
      Clear (Class Fields)
      Clear (Class FilterConditions)
      Clear (Class AppViewFields)
      Clear (Class AppViews)
      Clear (Class CustomJoins)
      Clear (Class DataSources)
      Clear (Class Folders)
      Clear (Class Joins)
      Clear (Class Parameters)
      Clear (Class ReportFields)
      Clear (Class Reports)
      Clear (Class Sorts)
      Clear (Class Tables)
      Clear (Class Values)
      Clear (Collections)
Collections
Command-Line Interface
CommandTimeout
Comment (Class ReportField)
      Comment (Class Field)
Comments
Company
Company Name
Company Web Site
Condition
Configuration Issues
Configuration Settings
Connect (Class DataSource)
      Connect (DataSource Object)
Connected
Connection
ConnectionHandle
ConnectionString
ConnectionTimeout
Contact
Converting FoxFire Reports to Stonefield Query
Converting Stonefield Reports to Stonefield Query
Copyright
Count (Class Users)
      Count (Class AppViewFields)
      Count (Class AppViews)
      Count (Class CustomJoins)
      Count (Class DataSources)
      Count (Class Databases)
      Count (Class Fields)
      Count (Class FilterConditions)
      Count (Class Folders)
      Count (Class Joins)
      Count (Class Parameters)
      Count (Class ReportFields)
      Count (Class Reports)
      Count (Class Sorts)
      Count (Class Tables)
      Count (Class Values)
Country
CreateObject
CreateOutput (Class Report)
      CreateOutput (Report Object)
CreatedAt
CreatedBy
Creating a Branded Version of Stonefield Query
Creating a Calculated Field
Creating a Data Group
Creating a Help File
Creating a New Script
Creating a New Stonefield Query Project
Creating a Project
Creating a Relation
Creating a Setup Executable
Creating a Subtable
Creating a User Group
Creating a Values Method Script for a Field
Creating a Virtual Table
CurrentDataSource
CursorFieldName
CustomJoin Object
CustomJoin.ErrorMessage
CustomJoin.JoinType
CustomJoin.Table1
CustomJoin.Table2
CustomJoins
CustomJoins Collection
CustomJoins.AddItem
CustomJoins.Clear
CustomJoins.Count
CustomJoins.ErrorMessage
CustomJoins.Item (Class CustomJoins)
CustomJoins.RemoveItem (Class CustomJoins)
DSN
Data Dictionary
Data Dictionary Table Structure
Data Object Scripts
DataEngine
DataEngine Object
DataEngine.AddToFavorites
DataEngine.AddToFields
DataEngine.AddToWhere
DataEngine.AfterDataEnvironmentCleared
DataEngine.AfterDataGroupsLoaded
DataEngine.AfterResultSetRetrieved
DataEngine.AppViews
DataEngine.BeforeCreateSQLStatement
DataEngine.BeforeResultSetRetrieved
DataEngine.BeforeSendSQLStatementToDatabase
DataEngine.Databases
DataEngine.ErrorMessage
DataEngine.ExcludeConditions
DataEngine.Fields
DataEngine.FilterChanged
DataEngine.FilterConditions
DataEngine.FinalizeSQLStatement
DataEngine.GetCustomMetaData
DataEngine.GetDataSourceDescription
DataEngine.GetFieldsFromSQLStatement
DataEngine.GetObjectVersion
DataEngine.GetTableFromSQLStatement
DataEngine.GetTablesFromSQLStatement
DataEngine.GetValuesForField (Class DataEngine)
DataEngine.GetValuesForParameter (Class DataEngine)
DataEngine.HandleSQLError
DataEngine.IncludeJoinsInWhere
DataEngine.Joins
DataEngine.PerformJoins
DataEngine.SetOperatorList
DataEngine.Tables
DataGroup (Class Report)
      DataGroup (Class Table)
      DataGroup (Class AppView)
DataSource Object
DataSource.BaseURL
DataSource.CommandTimeout
DataSource.Connect
DataSource.ConnectionHandle
DataSource.ConnectionString
DataSource.ConnectionTimeout
DataSource.DSN
DataSource.Database
DataSource.Datasource
DataSource.Description
DataSource.Disconnect
DataSource.Driver
DataSource.ErrorMessage
DataSource.Method
DataSource.OtherConnectInfo
DataSource.Password
DataSource.Server
DataSource.Specifier
DataSource.Type
DataSource.UseTemplate
DataSource.UserDefined
DataSource.UserName
DataSource.WSDLURL
DataSourceName
DataSources
DataSources Collection
DataSources.AddItem (Class DataSources)
DataSources.Clear
DataSources.Count
DataSources.ErrorMessage
DataSources.Item (Class DataSources)
DataSources.RemoveItem (Class DataSources)
DataTrimming
Database (Class DataSource)
      Database (Class Table)
Database Issues
Database Object
Database Properties
Database.Active
Database.Connected
Database.CurrentDataSource
Database.DataSourceName
Database.DataSources
Database.DatabaseName
Database.Description
Database.ErrorMessage
Database.ExecuteSQLStatement (Class Database)
Database.MainDatabase
Database.OpenDataSource (Class Database)
Database.Quiet
DatabaseName
Databases
Databases Collection
Databases.AddItem
Databases.Clear
Databases.Count
Databases.ErrorMessage
Databases.GetMainDatabase
Databases.Item (Class Databases)
Databases.RemoveItem (Class Databases)
Datasource
Dealing with Errors
Decimals (Class ReportField)
      Decimals (Class Field)
Decrypt (Class SFQApplication)
      Decrypt (Application Object)
Default Application View for New Reports
Default Data Group for New Reports
Default Language
Default Table for New Reports
Default for Auto-Adding DISTINCT
Defining an Enumerated Field Programmatically
Deploying Stonefield Query
Description (Class DataSource)
      Description (Class Database)
Description for Application Views
Description for Data Groups
Description for Data Sources
Disconnect (Class DataSource)
      Disconnect (DataSource Object)
Display
Display "All" Data Group
Display Application Name
DisplayFilter
Displaying a Splash Screen
Distinct
Driver
EditReport
Email
EmailBody
EmailSubject
Enable Table/Field Favorites
EncodedName
Encrypt (Class SFQApplication)
      Encrypt (Application Object)
Encrypting Files Output From a Report
Encrypting a Project
EndPage
EraseFile
Error Codes
ErrorCode
ErrorMessage (Class ReportField)
      ErrorMessage (Class Report)
      ErrorMessage (Class Field)
      ErrorMessage (Class SFQApplication)
      ErrorMessage (Class DataSource)
      ErrorMessage (Class Table)
      ErrorMessage (Class DataEngine)
      ErrorMessage (Class Join)
      ErrorMessage (Class User)
      ErrorMessage (Class AppView)
      ErrorMessage (Class FilterCondition)
      ErrorMessage (Class SQProxy)
      ErrorMessage (Class AppViewField)
      ErrorMessage (Class CustomJoin)
      ErrorMessage (Class Sort)
      ErrorMessage (Class Database)
      ErrorMessage (Class Users)
      ErrorMessage (Class AppViewFields)
      ErrorMessage (Class AppViews)
      ErrorMessage (Class CustomJoins)
      ErrorMessage (Class DataSources)
      ErrorMessage (Class Databases)
      ErrorMessage (Class Fields)
      ErrorMessage (Class FilterConditions)
      ErrorMessage (Class Folders)
      ErrorMessage (Class Joins)
      ErrorMessage (Class Parameters)
      ErrorMessage (Class ReportEngine)
      ErrorMessage (Class ReportFields)
      ErrorMessage (Class Reports)
      ErrorMessage (Class Sorts)
      ErrorMessage (Class Tables)
Event Scripts
Exact (Class ReportField)
      Exact (Class Field)
ExcludeConditions (Class Report)
      ExcludeConditions (Class DataEngine)
Execute (Class SFQApplication)
      Execute (Application Object)
ExecuteSQLStatement (Class Database)
      ExecuteSQLStatement (Database Object)
      ExecuteSQLStatement (Database.ExecuteSQLStatement)
Executing Custom Code in Stonefield Query Studio
Exporting the Data Dictionary to Microsoft Excel
Expression (Class ReportField)
      Expression (Class Field)
Expression Builder
Favorite (Class ReportField)
      Favorite (Class Field)
Fax
Field Object
Field Properties
Field.Alias
Field.AllowValues
Field.Calculated
Field.Caption
Field.Comment
Field.Decimals
Field.ErrorMessage
Field.Exact
Field.Expression
Field.Favorite
Field.FieldList
Field.FieldName
Field.Filterable
Field.Format
Field.Heading
Field.Length
Field.Order
Field.Other
Field.OutputLength
Field.OutputType
Field.Picture
Field.Reportable
Field.Roles
Field.SQExpression
Field.Sortable
Field.Type
Field.UserDefined
Field.ValuesMethod
Field.Version
FieldList (Class ReportField)
      FieldList (Class Field)
FieldName (Class ReportField)
      FieldName (Class Field)
      FieldName (Class FilterCondition)
      FieldName (Class AppViewField)
      FieldName (Class Sort)
Fields (Class Report)
      Fields (Class DataEngine)
      Fields (Class AppView)
Fields Collection
Fields.AddItem (Class Fields)
Fields.AliasFilter
Fields.Clear
Fields.Count
Fields.ErrorMessage
Fields.Item (Class Fields)
Fields.RemoveItem (Class Fields)
FillTreeView
Filling the Data Dictionary Automatically
FilterCondition Object
FilterCondition.AskAtRunTime
FilterCondition.CaseSensitive
FilterCondition.Condition
FilterCondition.Connection
FilterCondition.Display
FilterCondition.ErrorMessage
FilterCondition.FieldName
FilterCondition.IncludeInDisplay
FilterCondition.Operator
FilterCondition.ValueType
FilterCondition.Values
FilterConditions (Class Report)
      FilterConditions (Class DataEngine)
FilterConditions Collection
FilterConditions.AddItem (Class FilterConditions)
FilterConditions.AskAtRuntimeOnly
FilterConditions.Clear
FilterConditions.Count
FilterConditions.ErrorMessage
FilterConditions.Item (Class FilterConditions)
FilterConditions.RemoveItem (Class FilterConditions)
Filterable (Class ReportField)
      Filterable (Class Field)
Filtering the Data Dictionary
Finding Possible Relations
FirstName
Folder.CreatedAt
Folder.CreatedBy
Folder.FolderName
Folder.HasChildren
Folder.HasFolders
Folder.HasParent
Folder.ID
Folder.ParentID
FolderName
Folders.AddItem
Folders.Clear
Folders.Count
Folders.ErrorMessage
Folders.Item (Class Folders)
Folders.RemoveItem (Class Folders)
FontAlign
FontBold
FontItalic
FontName
FontSize
FontUnderline
Footer
ForEachMode
ForeColor
Format (Class ReportField)
      Format (Class Field)
Frequently Asked Questions
Function Reference
GetAskAtRuntimeFilter
GetAskAtRuntimeFilterCount
GetDataSetFieldName (Class SFQApplication)
      GetDataSetFieldName (Application Object)
GetDataSources
GetFieldsFromSQLStatement (Class DataEngine)
      GetFieldsFromSQLStatement (DataEngine Object)
GetFolders (ReportEngine Object)
      GetFolders (Class ReportEngine)
GetINIValue (Class SFQApplication)
      GetINIValue (Application Object)
      GetINIValue (SFQApplication.GetINIValue)
GetLicenseCount (Class Users)
      GetLicenseCount (Users Collection)
      GetLicenseCount (Users.GetLicenseCount)
GetMainDatabase (Class Databases)
      GetMainDatabase (Databases Collection)
GetProperty (Class SFQApplication)
      GetProperty (Class ReflectionService)
GetRegistryValue (Class SFQApplication)
      GetRegistryValue (Application Object)
      GetRegistryValue (SFQApplication.GetRegistryValue)
GetReport (ReportEngine Object)
      GetReport (Class ReportEngine)
GetReportFilter (Class Report)
      GetReportFilter (Report Object)
GetReportFooter (Class Report)
      GetReportFooter (Report Object)
GetReportHeader (Class Report)
      GetReportHeader (Report Object)
GetReports (ReportEngine Object)
      GetReports (Class ReportEngine)
GetTableFromSQLStatement
GetTablesFromSQLStatement (Class DataEngine)
      GetTablesFromSQLStatement (DataEngine Object)
GetValuesCollection (Class SFQApplication)
      GetValuesCollection (Application Object)
GetValuesForField (Class DataEngine)
      GetValuesForField (DataEngine Object)
      GetValuesForField (DataEngine.GetValuesForField)
GetValuesForParameter (Class DataEngine)
      GetValuesForParameter (DataEngine Object)
      GetValuesForParameter (DataEngine.GetValuesForParameter)
Getting Diagnostic Information
Google Custom Search ID
Group (Class ReportField)
      Group (Class Sort)
GroupCount
GroupOnOneLine
HPosition
Handling Dates Stored as Non-Date Values
Handling GMT Fields
Handling Null-Terminated Strings
HasChildren
HasFolders
HasParent
HaveGroupedFields
Header
Heading (Class ReportField)
      Heading (Class Field)
      Heading (Class AppViewField)
How To
Icon File
Importing a Data Dictionary
Improving the Performance of Calculated Fields
Include Joins in the WHERE Clause
IncludeInDisplay
IncludeJoinsInWhere
IncludeTime
Introduction (Stonefield Query Studio)
IsValidUser (Class Users)
      IsValidUser (Users Collection)
Item (Class Users)
      Item (Class Fields)
      Item (Class FilterConditions)
      Item (Class AppViewFields)
      Item (Class AppViews)
      Item (Class CustomJoins)
      Item (Class DataSources)
      Item (Class Databases)
      Item (Class Folders)
      Item (Class Joins)
      Item (Class Parameters)
      Item (Class ReportFields)
      Item (Class Reports)
      Item (Class Sorts)
      Item (Class Tables)
      Item (Class Values)
      Item (Collections)
      Item (AppViewFields.Item)
      Item (AppViews.Item)
      Item (CustomJoins.Item)
      Item (DataSources.Item)
      Item (Databases.Item)
      Item (Fields.Item)
      Item (FilterConditions.Item)
      Item (Folders.Item)
      Item (Joins.Item)
      Item (Parameters.Item)
      Item (ReportFields.Item)
      Item (Reports.Item)
      Item (Sorts.Item)
      Item (Tables.Item)
      Item (Users.Item)
Join Object
Join.ChildExpression
Join.ChildTable
Join.ErrorMessage
Join.JoinExpression
Join.JoinName
Join.JoinType
Join.ParentExpression
Join.ParentTable
Join.Version
Join.Weight
JoinExpression
JoinName
JoinType (Class Join)
      JoinType (Class CustomJoin)
Joins
Joins Between Different Databases
Joins Collection
Joins.AddItem
Joins.Clear
Joins.Count
Joins.ErrorMessage
Joins.Item (Class Joins)
Joins.RemoveItem (Class Joins)
Key
LastName
Launching Stonefield Query
Length (Class ReportField)
      Length (Class Field)
License
Licensing
Licensing Reports
Linking to Google Maps
LoadProject (Class SQProxy)
Location
Log
Login (Class Users)
      Login (Users Collection)
Logo Image File
MainDatabase
MainList
Margin
Menu and Toolbar Functions
Message for Invalid Directory
Message for Invalid Target App Directory
Method
Microsoft Access
Microsoft Access and SQL Server Northwind
Microsoft SQL Server
Multi-Language Support
Name
Namespace SFQWrapper
Namespace SQProxyWrapper
Need Target Application Directory
NewPage
NewReport
NoTotalsForOneRecord
Number of Days for Demo Version
ODBCFilterToLocalFilter
OpenDataSource (Class Database)
      OpenDataSource (Data Object Scripts)
      OpenDataSource (Database.OpenDataSource)
OpenDataSource Method
OpenForm
Opening an Existing Stonefield Query Project
Operator
Options.Changed
Options.Settings
Options.Validate
Order (Class ReportField)
      Order (Class Field)
      Order (Class AppView)
      Order (Class AppViewField)
      Order (Class Sort)
Orientation
OriginalTable
Other (Class ReportField)
      Other (Class Field)
OtherConnectInfo
Output
OutputFileName
OutputLength (Class ReportField)
      OutputLength (Class Field)
OutputOptions.Settings
OutputType (Class ReportField)
      OutputType (Class Field)
Outputting Rich Text Fields
Panels
Parameter.Name
Parameter.Value
Parameters (Class SFQApplication)
      Parameters (Class SQProxy)
Parameters Collection
Parameters.AddItem (Class Parameters)
Parameters.Clear
Parameters.Count
Parameters.ErrorMessage
Parameters.Item (Class Parameters)
Parameters.RemoveItem (Class Parameters)
ParentExpression
ParentID
ParentKey
ParentTable
Password (Class DataSource)
      Password (Class User)
Password for Online Updates
PerformJoins
Phone
Picture (Class ReportField)
      Picture (Class Field)
PostalCode
PreviewReport
PrintReport
ProjectDirectory
ProjectLoaded
PromptUserForValue (Class SFQApplication)
      PromptUserForValue (Application Object)
      PromptUserForValue (SFQApplication.PromptUserForValue)
Providing Sample or Standard Reports
Providing Sample or Standard Templates
ProxyTimeout
Querying the Data Dictionary
Quick Start
Quiet
Recipients
Records
ReflectionService.CallMethod
ReflectionService.GetProperty
ReflectionService.SetProperty
Refreshing the Data Dictionary
Region
RegisterCursorToCloseAfterRun
Registration.Settings
Registry Key for Earlier Version
Registry Settings
Relation Properties
RemoveItem (Class Users)
      RemoveItem (Class Fields)
      RemoveItem (Class FilterConditions)
      RemoveItem (Class AppViewFields)
      RemoveItem (Class AppViews)
      RemoveItem (Class CustomJoins)
      RemoveItem (Class DataSources)
      RemoveItem (Class Databases)
      RemoveItem (Class Folders)
      RemoveItem (Class Joins)
      RemoveItem (Class Parameters)
      RemoveItem (Class ReportFields)
      RemoveItem (Class Reports)
      RemoveItem (Class Sorts)
      RemoveItem (Class Tables)
      RemoveItem (Class Values)
      RemoveItem (Collections)
      RemoveItem (AppViewFields.RemoveItem)
      RemoveItem (AppViews.RemoveItem)
      RemoveItem (CustomJoins.RemoveItem)
      RemoveItem (DataSources.RemoveItem)
      RemoveItem (Databases.RemoveItem)
      RemoveItem (Fields.RemoveItem)
      RemoveItem (FilterConditions.RemoveItem)
      RemoveItem (Folders.RemoveItem)
      RemoveItem (Joins.RemoveItem)
      RemoveItem (Parameters.RemoveItem)
      RemoveItem (ReportFields.RemoveItem)
      RemoveItem (Reports.RemoveItem)
      RemoveItem (Sorts.RemoveItem)
      RemoveItem (Tables.RemoveItem)
      RemoveItem (Users.RemoveItem)
Removing Menu Items and Wizards
Report Object
Report.Advanced
Report.AllowDuplicates
Report.AllowEmptyResultSet
Report.AllowFilter
Report.AllowSort
Report.AskAtRunTime
Report.BCCRecipients
Report.CCRecipients
Report.Comments
Report.CreateOutput
Report.CustomJoins
Report.DataGroup
Report.DisplayFilter
Report.Distinct
Report.EmailBody
Report.EmailSubject
Report.EncodedName
Report.EndPage
Report.EraseFile
Report.ErrorMessage
Report.ExcludeConditions
Report.Fields
Report.FilterConditions
Report.Footer
Report.ForEachMode
Report.GetAskAtRuntimeFilter
Report.GetAskAtRuntimeFilterCount
Report.GetReportFilter
Report.GetReportFooter
Report.GetReportHeader
Report.HaveGroupedFields
Report.Header
Report.ID
Report.Margin
Report.Orientation
Report.Output
Report.OutputFileName
Report.Recipients
Report.Records
Report.ReportName
Report.ReportType
Report.RunReport
Report.SQLSelect
Report.SetOutputToFile (Class Report)
Report.ShowTotalsInGroupHeader
Report.Sorts
Report.StartPage
Report.Summary
Report.Template
Report.Timestamp
Report.UserName
ReportEngine
ReportEngine Object
ReportEngine.AfterAddField
ReportEngine.AfterCreateFile
ReportEngine.AfterGetFolders
ReportEngine.AfterReportPrepared
ReportEngine.AfterRunReport
ReportEngine.AfterSendEmail
ReportEngine.BeforeCreateFile
ReportEngine.BeforeRunReport
ReportEngine.BeforeSendEmail
ReportEngine.ErrorMessage
ReportEngine.FillTreeView
ReportEngine.GetFolders (Class ReportEngine)
ReportEngine.GetReport
ReportEngine.GetReports (Class ReportEngine)
ReportEngine.ImportReport
ReportEngine.PreviewReport
ReportEngine.RunReport (Class ReportEngine)
ReportEngine.RunReportToFile (Class ReportEngine)
ReportEngine.SetReportProperties
ReportEngine.SetupCrystalReport
ReportField Object
ReportField.Alias
ReportField.AllowValues
ReportField.Autofit
ReportField.BackColor
ReportField.Bookmark
ReportField.Calculated
ReportField.Caption
ReportField.Chart
ReportField.ChartFormat
ReportField.ChartInputMask
ReportField.ChartOrder
ReportField.ChartTotalType
ReportField.Comment
ReportField.CursorFieldName
ReportField.DataTrimming
ReportField.Decimals
ReportField.ErrorMessage
ReportField.Exact
ReportField.Expression
ReportField.Favorite
ReportField.FieldList
ReportField.FieldName
ReportField.Filterable
ReportField.FontAlign
ReportField.FontBold
ReportField.FontItalic
ReportField.FontName
ReportField.FontSize
ReportField.FontUnderline
ReportField.ForeColor
ReportField.Format
ReportField.Group
ReportField.GroupCount
ReportField.GroupOnOneLine
ReportField.HPosition
ReportField.Heading
ReportField.Length
ReportField.NewPage
ReportField.NoTotalsForOneRecord
ReportField.Order
ReportField.Other
ReportField.OutputLength
ReportField.OutputType
ReportField.Picture
ReportField.Reportable
ReportField.ResetPage
ReportField.Roles
ReportField.SQExpression
ReportField.ShowPercent
ReportField.Sortable
ReportField.Suppress
ReportField.TotalType
ReportField.Type
ReportField.UseDefaultFormat
ReportField.UseDefaultFormatForChart
ReportField.UserDefined
ReportField.VPosition
ReportField.ValuesMethod
ReportField.Version
ReportField.Width
ReportField.WidthOnReport
ReportFields Collection
ReportFields.AddItem (Class ReportFields)
ReportFields.Clear
ReportFields.Count
ReportFields.ErrorMessage
ReportFields.Item (Class ReportFields)
ReportFields.RemoveItem (Class ReportFields)
ReportName
ReportType
Reportable (Class ReportField)
      Reportable (Class Field)
      Reportable (Class Table)
Reporting Issues
Reports.AddItem
Reports.Clear
Reports.Count
Reports.ErrorMessage
Reports.Item (Class Reports)
Reports.RemoveItem (Class Reports)
ReportsDirectory
ResetPage
Roles (Class ReportField)
      Roles (Class Field)
      Roles (Class Table)
      Roles (Class User)
RunReport (Class Report)
      RunReport (Class ReportEngine)
      RunReport (ReportEngine Object)
      RunReport (ReportEngine.RunReport)
RunReportToFile (Class ReportEngine)
      RunReportToFile (ReportEngine Object)
      RunReportToFile (ReportEngine.RunReportToFile)
Running Stonefield Query from Other Applications
SFQApplication.AddProperty (Class SFQApplication)
SFQApplication.ApplicationDataDirectory
SFQApplication.ApplicationDirectory
SFQApplication.ApplicationName
SFQApplication.CalledFromProxy
SFQApplication.CanEditReports
SFQApplication.DataEngine
SFQApplication.Decrypt
SFQApplication.Encrypt
SFQApplication.ErrorMessage
SFQApplication.Execute
SFQApplication.GetDataSetFieldName
SFQApplication.GetINIValue (Class SFQApplication)
SFQApplication.GetProperty
SFQApplication.GetRegistryValue (Class SFQApplication)
SFQApplication.GetValuesCollection
SFQApplication.Parameters
SFQApplication.ProjectDirectory
SFQApplication.PromptUserForValue (Class SFQApplication)
SFQApplication.ReportEngine
SFQApplication.ReportsDirectory
SFQApplication.SerialNumber
SFQApplication.SetINIValue
SFQApplication.SetProperty
SFQApplication.SetRegistryValue (Class SFQApplication)
SFQApplication.SetViewerLicenses
SFQApplication.ShortApplicationName
SFQApplication.ShowErrorMessage
SFQApplication.ShowStatus
SFQApplication.Shutdown
SFQApplication.TargetApplicationDirectory
SFQApplication.TimeZoneDesc
SFQApplication.TimeZoneOffset
SFQApplication.UpdateProgressBar
SFQApplication.Users
SFQApplication.Version
SQApplication
SQExpression (Class ReportField)
      SQExpression (Class Field)
SQLSelect
SQProxy Object
SQProxy.ErrorCode
SQProxy.ErrorMessage
SQProxy.LoadProject (Class SQProxy)
SQProxy.Parameters
SQProxy.ProjectLoaded
SQProxy.ProxyTimeout
SQProxy.SQApplication
Sales Email
Sales Phone
Sample ASP.NET Web Application
Sample Project
Scheduler.GetCommandLine
Schema
Script Issues
Script Languages
Scripts
Security Tables
Select
SerialNumber
Server
SetINIValue (Class SFQApplication)
      SetINIValue (Application Object)
SetOutputToFile (Class Report)
      SetOutputToFile (Report Object)
      SetOutputToFile (Report.SetOutputToFile)
SetProperty (Class SFQApplication)
      SetProperty (Class ReflectionService)
SetRegistryValue (Class SFQApplication)
      SetRegistryValue (Application Object)
      SetRegistryValue (SFQApplication.SetRegistryValue)
SetViewerLicenses (Class SFQApplication)
      SetViewerLicenses (Application Object)
Settings.Address1
Settings.Address2
Settings.City
Settings.Company
Settings.Contact
Settings.Country
Settings.Email
Settings.Fax
Settings.Phone
Settings.PostalCode
Settings.Region
Setup.Changed
Setup.Settings
Setup.Validate
Share Database Connections
Short Application Name
ShortApplicationName
ShowErrorMessage (Class SFQApplication)
      ShowErrorMessage (Application Object)
ShowPercent
ShowStatus (Class SFQApplication)
      ShowStatus (Application Object)
ShowTotalsInGroupHeader
Shutdown (Class SFQApplication)
      Shutdown (Application Object)
Software Maintenance
Sort Object
Sort.Alias
Sort.Ascending
Sort.Caption
Sort.ErrorMessage
Sort.FieldName
Sort.Group
Sort.Order
Sortable (Class ReportField)
      Sortable (Class Field)
Sorts
Sorts Collection
Sorts.AddItem
Sorts.Clear
Sorts.Count
Sorts.ErrorMessage
Sorts.Item (Class Sorts)
Sorts.RemoveItem (Class Sorts)
Specifier
Specifying Libraries to Load
Specifying the Location of the Project File at Installation
StartPage
Step 1: Setting up Options
Step 2: Create a Stonefield Query Project
Step 3: Customizing the Data Dictionary
Step 4: Specify Configuration Settings
Step 5: Test Your Project
Step 6: Deploy to Your Users
Stonefield Query .NET Wrapper Classes
Stonefield Query Directories
Stonefield Query Object Model
Stonefield Query Performs Joins
Stonefield Query Project Files
Stonefield Query Security
Stonefield Query Studio
Structure of Reports Table
SubTableFilter
Summary
Support Contact Information
Support Email
Support Maintenance Reminder
Support Multi-Languages
Support Online Updates
Suppress
Table Object
Table Properties
Table to Test
Table.Alias
Table.Caption
Table.DataGroup
Table.Database
Table.ErrorMessage
Table.Location
Table.OriginalTable
Table.Reportable
Table.Roles
Table.Schema
Table.SubTableFilter
Table.UserDefined
Table.Version
Table.Virtual
Table1
Table2
Tables
Tables Collection
Tables.AddItem
Tables.Clear
Tables.Count
Tables.ErrorMessage
Tables.Item (Class Tables)
Tables.RemoveItem (Class Tables)
Tag for News Feed
Target Application's Name
TargetApplicationDirectory
Technical Reference
Technical Support
Template
TimeZoneDesc
TimeZoneOffset
Timestamp
TotalType
Trial Version
Tutorials
Type (Class ReportField)
      Type (Class DataSource)
      Type (Class Field)
URL for Customer Portal
URL for Knowledgebase
URL for News Feeds
URL for Online Updates
URL for Technical Support Site
UpdateProgressBar (Class SFQApplication)
      UpdateProgressBar (Application Object)
Updates File for Online Updates
Updating From Visual MaxFrame Professional
Updating Stonefield Query to the Latest Version
Updating a Virtual or Subtable to Match the Main Table
Use "with (nolock)"
Use Application Views by Default
Use DSNless Connection
Use a Schema for Queries
UseDefaultFormat
UseDefaultFormatForChart
UseTemplate
User Can Edit SQL Statement
User Can Manage Data Sources
User Object
User-Defined Scripts
User.Administrator
User.Advanced
User.ErrorMessage
User.FirstName
User.LastName
User.License
User.Password
User.Roles
User.UserName
UserDefined (Class ReportField)
      UserDefined (Class DataSource)
      UserDefined (Class Field)
      UserDefined (Class Table)
UserName (Class DataSource)
      UserName (Class Report)
      UserName (Class User)
      UserName (Class Users)
Username for Online Updates
Users
Users Collection
Users.AddItem
Users.Administrator
Users.Advanced
Users.Clear
Users.Count
Users.ErrorMessage
Users.GetLicenseCount (Class Users)
Users.IsValidUser
Users.Item (Class Users)
Users.Login
Users.RemoveItem (Class Users)
Users.UserName
Using Case-Insensitive Joins
Using Microsoft SQL Server
Using SQLXML for a Data Source
Using SQLookup to Avoid Subtables
Using SQProxy in .NET Applications
Using SQProxy with IIS
Using a Stored Procedure for Data Access
Using a Text File for a Data Source
Using a Web Service for a Data Source
VPosition
Value (Class Parameter)
      Value (Class ValueItem)
ValueItem.IncludeTime
ValueItem.Value
ValueType
Values
Values.AddItem (Class Values)
Values.Clear
Values.Count
Values.Item
Values.RemoveItem
ValuesMethod (Class ReportField)
      ValuesMethod (Class Field)
Version (Class ReportField)
      Version (Class Join)
      Version (Class Table)
      Version (Class Field)
      Version (Class SFQApplication)
Versioning
Viewing Table Contents
Virtual
WSDLURL
Weight
What's New in This Version
Width
WidthOnReport
Working with Stonefield Query Studio