Construct_Object()
- Handle
DatabaseObject()
--------------------
Database Functions
Returns handle to database object
- Integer
hoDatabase - Variant
vDatabase - Boolean
bAttached
LoadDatabaseTables(Handle hoDatabaseTables)
Creates all table objects
- Variant
vComDatabaseTable - Integer
hoDatabaseTable - Integer
iTableItem - Integer
iTableCount - Boolean
bAttached - Integer[]
hoTables
- Handle
DatabaseTablesObject()
Returns handle to database collection comautomation object. Creates connection if connection does not already exist.
This is used privately to fill the table array which is accessed publicly via get TableObjects.
We could destroy phoDatatables if we wanted but we are not currently doing so.
- Boolean
bAttached - Integer
hoDatabaseTables - Integer
hoDatabase - Variant
vComDatabaseTables
- Handle[]
TableObjects()
Returns an array of tables in report
- Integer
hoDatabaseTables - Integer[]
hoTables
- Handle
GetTableObjectByName(String sTable)
Returns handle of table from name. Note:ComName returns the object name. This is the
name given to a file (such as an alias name). ComLocation and ComConnectBufferString
return the file the connection is made to.
- String
sHoldName - Integer
iTableItem - Integer
iTableCount - Integer[]
hoTables
- Boolean
LocateDFFile(Handle hoDatabaseTable)
Set the location of a dataflex datafile (.dat or .int) to the data directory
- Integer
iPath - Integer
iNumPaths - Boolean
bExists - String
DirSep - String
sTable - String
sLocation
- Boolean
LocateDFFiles()
## NOT FOR USE WITH SUBREPORTS ##
Locate all dataflex files for report and sub-report assign them to the data directory.
If table cannot be relocated, process stops and false is returned; else return true.
- Integer[]
SubReportArray - Integer
hoSubReport - Integer
iReportItem - Integer
iReportCount - Boolean
bOk
- Boolean
LocateDFFilesForReport()
Locate all dataflex files for this one report assign them to the data directory.
If table cannot be relocated, process stops and false is returned; else return true
- String
sTableType - Integer
iTableItem - Integer
iTableCount - Integer
hoDatabaseTable - Integer[]
hoTables - Boolean
bOK
- Handle
CreateCDO(String sFileName)
## NOT FOR USE WITH SUBREPORTS ##
Creates a CDO based on a TTX file.
- Integer
hoCDO - tCRWCDO[]
CRWCDOs - Integer
iCDOCount - Integer
iFieldType - Integer
iChannel - Boolean
bOK - String
sLocation - String
sLine - String
sField - String
sFieldType - String
DirSep
AppendCDOData(Handle hoCDO Variant[][] vCDOData)
## NOT FOR USE WITH SUBREPORTS ##
Converts a safe array to the correct datatypes used by the CDO and attaches data to CDO.
Example usage within OnInitializeReport: Send AppendCDOData of hoReport hoCDO vData
- Integer
iCol - Integer
iMaxCol - Integer
iItem - Integer
iCount - Integer
iType
AttachCDO(String sFileName Handle hoCDO)
## NOT FOR USE WITH SUBREPORTS ##
Attaches an existing CDO to a report. This is usefull when a cdo is shared by multiple reports.
Create the cdo once and attach it to each report.
- Integer
iCDOCount - tCRWCDO[]
CRWCDOs
AssignCDODataSources(tCRWCDO[] CRWCDOs)
## NOT FOR USE WITH SUBREPORTS ##
Attaches CDO data to report and subreport CDO objects
- Integer
hoCDO - Integer
hoTable - Integer
iCDOItem - Integer
iCDOCount - String
sTable - String
DirSep - String
sPath - String
sType
- Handle
FormulaFieldDefinitionsObject()
End Database functions
--------------------
Formula Functions
Returns handle to report formula fields collection comautomation object.
Creates connection if connection does not already exist.
This is used privately by AssignFormula
- Variant
vFormulaFields - Integer
hoFormulaFieldDefinitions - Boolean
bAttached
AssignFormula(String sFormulaName String sValue)
Sets report formula field to sValue
- Variant
vFormulaField - Integer
hoFormulaFieldDefinitions - Integer
hoFormulaFieldDefinition - Boolean
bAttached - Boolean
bDisplay
LoadParams(handle hoParamFieldDefinitions)
End Formula Functions
--------------------
Parameter Functions
Creates all Parameter objects
- Variant
vParameterFieldDefinition - Integer
hoParameterFieldDefinition - Integer
iParamItem - Integer
iParamCount - Integer[]
hoParams - Boolean
bAttached
- Handle
ParameterFieldDefinitionsObject()
Returns handle to report parameter fields collection comautomation object.
Creates connection if connection does not already exist.
This is used privately to load the params object which is accessed publicly via Get ParamObjects.
We could destroy phoParamFieldDefinitions when this is done, but we are currently not doing so.
- Variant
vParamFields - Integer
hoParamFieldDefinitions - Boolean
bAttached
- Handle[]
ParamObjects()
Returns an array of Parameters in report
- Integer
hoParamFieldDefinitions - Integer[]
hoParams
- Handle
GetParamObjectByName(String sParamName)
Returns handle of Parameter object from name
- String
sHoldName - Integer
iParamItem - Integer
iParamCount - Integer[]
hoParams
- Handle
SortFieldsObject()
End Parameter Functions
--------------------
Sort Functions
Returns handle to report record sort fields collection comautomation object.
Creates connection if connection does not already exist.
This is used privately by the various sort methods (DeleteSortOrder, DeleteNthSortField and AppendSortField)
- Variant
vSortFields - Integer
hoSortFields - Boolean
bAttached
DeleteSortOrder()
Deletes current record sort order
- Integer
hoSortFields - Integer
iSortItem - Integer
iSortCount
DeleteNthSortField(Integer iSortItem)
Deletes current record sort order at position iSortItem
- Integer
hoSortFields
AppendSortField(String sTable String sField crSortDirection SortOrder)
Adds table field to record sort order
- Variant
vField - Variant
vFields - Integer
hoSortFields - Integer
hoDatabaseTable - Integer
hoTableFields - Integer
hoTableField - Boolean
bOK - Boolean
bAttached - String
sName - Integer
iField - Integer
iFieldCount
AppendSortFormulaField(String sFormulaName crSortDirection SortOrder)
Adds formula field to record sort order
- Variant
vField - Integer
hoSortFields - Integer
hoFormulaFieldDefinitions - Boolean
bOK - Boolean
bAttached - Boolean
bDisplay
LoadSubreports()
End Sort Functions
--------------------
Begin Subreport Functions
## NOT FOR USE WITH SUBREPORTS ##
Loads all subreports into an array. Note: All objects are of a report are checked to check if it is
a subreport. If it is a subreport, it is then created at the report level. All test objects are
destroyed when this process is complete.
- Integer
hoAreas - Integer
hoArea - Integer
hoSections - Integer
hoSection - Integer
hoReportObjs - Integer
hoSubReport - Integer
hoTemp - Variant
vAreas - Variant
vArea - Variant
vSections - Variant
vSection - Variant
vReports - Variant
vSubReport - Variant
vReport - Integer
iArea - Integer
iSection - Integer
iSubReport - Integer
iKind - Integer
iCount - Integer[]
SubReportArray - String
sName - Boolean
bAttached
- Handle[]
SubReportObjects()
## NOT FOR USE WITH SUBREPORTS ##
Returns an array of subreports in report
- Integer[]
SubReportArray
- Handle
GetSubReportObjectbyName(String sReportName)
## NOT FOR USE WITH SUBREPORTS ##
Returns handle of subreport object comautomation object. Creates
connection if connection does not already exist
- Integer
iReportItem - Integer
iReportCount - String
sHoldName - Integer[]
SubReportArray
- Handle
ExportObject()
End Subreport Functions
--------------------
Begin Output Funtions
## NOT FOR USE WITH SUBREPORTS ##
Creates export object if it doesn't exist
- Integer
hoExport - Integer
hcExportObject - Variant
vExport - Boolean
bAttached
- String
PreviewerName()
- Integer
hoPreviewerParent - String
sPreviewerName
- Handle
PreviewObject()
## NOT FOR USE WITH SUBREPORTS ##
Returns handle of preview object
- Integer
hoPreview - Integer
hoMain - Integer
hoClientArea - Integer
hcPreviewObject - String
sTitle - String
sPreviewerName - Boolean
bAttached
AssignPreviewObject(Handle hoPreview)
## NOT FOR USE WITH SUBREPORTS ##
Override the default preview object
- Handle
ActiveXReportViewerObject()
## NOT FOR USE WITH SUBREPORTS ##
Return handle of activeX preview object.
- Integer
hoPreview
PrintReport()
## NOT FOR USE WITH SUBREPORTS ##
Printer specific
- Integer
iStartPage - Integer
iEndPage - Integer
iCopies - Boolean
bCollate - Boolean
bPrompt
ExportReport()
Export specific
- Boolean
bPrompt