Class: cSigCJReportControl
-----------------------------------------------------------------------------
Class Hierarchy:
DFCOMACTIVEXCONTROL

cComActiveXControl


cSigCjComReportControl



cSigCJReportControlMixins:
cSigCJMethods_Mixin, cSigCJPropEx_Mixin,
Class Definition
Properties
Boolean
pbActive_Track
Boolean
pbAuto_Columns
Boolean
pbAuto_Fill
Boolean
pbAuto_Row_Ref
Boolean
pbCollapseGroups
Boolean
pbColumn_Resort
Boolean
pbDefaultLayout
Boolean
pbDescending
Boolean
pbEOF
Boolean
pbFreezeColumns
Boolean
pbItem_Colors
Boolean
pbPrintLandscape
Boolean
pbRefreshRequired
Boolean
pbRow_Colors
Boolean
pbRow_Item
Boolean
pbRowID_Mode
Boolean
pbShow_Recnum
Boolean
pbShowGroupBox
Boolean
pbSQL_Case
Boolean
pbWatermarkFromFile
Boolean
pbWordWrap
Integer
peDataflex_Table_Find_Method
Integer
peDb_Type
Integer
peHitTest
Handle
phoContextMenu_GroupBox
Handle
phoContextMenu_Header
Handle
phoContextMenu_ReportArea
Handle
phoDD
Handle
phoFieldChooser
Handle
phoFont
Font Support
Handle
phoHitTestInfo
Handle
phoPrintPageHeaderFooter
Handle
phoReportColumn
Handle
phoReportColumnOrder
Handle
phoReportColumns
Handle
phoReportGroupRow
Handle
phoReportPaintManager
Handle
phoReportPrintOptions
Handle
phoReportRecord
Handle
phoReportRecordItem
Handle
phoReportRecordItemMetrics
Handle
phoReportRecords
Handle
phoReportRow
Handle
phoReportRows
Handle
phoReportSelectedRows
Integer
piCh_No
Integer
piItem_BackColor
Integer
piItem_ForeColor
Integer
piLoad_Monitor
Integer
piMax_Rows
Integer
piRef_Column
Integer
piRow_BackColor
Integer
piRow_ForeColor
Integer
piTable_Index
Integer
piWatermarkAlignment
2 + 32 + 2048 = 2082
Integer
piWatermarkWeight
Number
pnGridFontSize
Number
pnPreviewFontSize
Boolean
Private_pbPreviewMode
Handle
Private_phoFieldChooserList
Integer
Private_piColumn_Count
Integer
Private_piCurrentColumnIndex
Integer
Private_piFiltered_Row_Count
Integer
Private_piFreezeColumnsCount
Integer
Private_piRow_Count
Integer
Private_piSelected_Row_Count
String
psCurrent_Tag
String[]
psData_Items
String
psExport_File
String
psGridFontName
String
psPreviewFontName
String
psProcess_Type
String
psSQL_From
String
psSQL_OrderBy
String
psSQL_Select
String
psSQL_Select_Statment
String
psSQL_Where
String
psWatermarkBitmap
tdRC_Column_Def[]
ptColumn_Defs
tdRC_Column_Format[]
ptColumn_Formats
TimeSpan
ptsTimeSpan_Load
TimeSpan
ptsTimeSpan_SQL
Functions and Procedures

Add_Item_Data(String sItem)
-------------------------------------------------------------------------

Add_Report_Column(String sLabel Integer iSize Integer eDataType Integer eStyle String sTC_Name String sEval)
-------------------------------------------------------------------------
CAUTION :- Overloaded Function
For Text & CSV files
Procedure Add_Report_Column Overloaded String sLabel Integer iSize Integer eDataType Short eStyle
tdRC_Column_Def[] tColumn_Defs
Integer iCount
Get ptColumn_Defs to tColumn_Defs
Move (SizeOfArray(tColumn_Defs)) to iCount
Move sLabel to tColumn_Defs[iCount].sLabel
Move iSize to tColumn_Defs[iCount].iSize
Move eDataType to tColumn_Defs[iCount].eDataType
Move eStyle to tColumn_Defs[iCount].eStyle
Set ptColumn_Defs to tColumn_Defs
Set Private_piColumn_Count to iCount
End_Procedure
For database & SQL files

Add_Report_Item(Handle hoRec Integer iColumn Boolean bRow_Item Integer eDataType Integer eStyle Boolean bRow_Colors tdRC_Column_Format tColumn_Format String sValue)
=========================================================================

AttachFieldChooser(Handle hoFieldChooser Boolean bAttach)

Beginning_Of_Data()

Build_SQL_Statement()
=========================================================================
SQL Data

Construct_Object()
Set Color to clActiveCaption // Used only by the Studio

Create_Columns()
-------------------------------------------------------------------------
Handle
CreateFieldChooserPanel()
~~~~~~~~~~~~~~~~~~~~~~~~~~

CSV_Export()
Integer
Deactivating()
=========================================================================
Standard Dataflex methods

DefaultLayout()

Deferred_Refresh_Report()
Refresh_Report when idle

Define_From_DD()
-------------------------------------------------------------------------

DeselectAll()
-------------------------------------------------------------------------

DoBest_Fit()
=========================================================================

DoDefine_Columns()
-------------------------------------------------------------------------

DoDelete_Report_Data()

DoLoad_Data()
-------------------------------------------------------------------------

DoLoad_SQL()
-------------------------------------------------------------------------

DoLoad_Table()
=========================================================================
Table Data

DoLoad_Text()
=========================================================================
Text Data

DoRefresh_Report_Control()

DoReset_Report_Control()
-------------------------------------------------------------------------

DoSetColumnGrouping()

DoSetColumnOrdering()

DoSetOrdering(Boolean bGroup)

End_Construct_Object()

End_Of_Data()
Boolean
Ensure_Visible(String sTag)

FieldChooser()
-------------------------------------------------------------------------

Filter_Rows(String sValue)

Filtered_Row_Count()

Find_Ge()

Find_Next()

Find_Previous()

Find_Row_Tag(String sValue)
-------------------------------------------------------------------------

FreezeClear()

FreezeColumn()
FreezeColumn option

Initialise_Column_Formats()
-------------------------------------------------------------------------

Invert_Selection()
-------------------------------------------------------------------------

OnActive_Track(String sID)

OnAdd_ContextMenu_GroupBox(Handle hoContextMenu)
-------------------------------------------------------------------------
Context Menu OnAdd_ Hook options
-------------------------------------------------------------------------

OnAdd_ContextMenu_Header(Handle hoContextMenu)

OnAdd_ContextMenu_ReportArea(Handle hoContextMenu)

OnAfter_Load_Data()

OnBefore_Load_Data()

OnBuild_SQL_Statement()

OnClose_DataSource()
-------------------------------------------------------------------------

OnComColumnClick(Variant llColumn)

OnComFocusChanging(Variant llNewRow Variant llNewColumn Variant llNewItem Boolean ByRef llCancel)
-------------------------------------------------------------------------

OnComGroupOrderChanged()
=========================================================================

OnComMouseUp(Short llButton Short llShift Integer llx Integer lly)
On Mouse Up set Left click options and Right click context menu options

OnComRowDblClick(Variant llRow Variant llItem)
-------------------------------------------------------------------------

OnComSelectionChanged()

OnCreate()

OnCreateColumn(Integer iColumn Handle hoCol)

OnCreateRowItem(Integer iColumn Handle hoItem String sValue)

OnDefine_Columns()

OnDouble_Click(String sID)

OnDouble_Click_RowID(RowID Row_ID)

OnFiltered_Row_Count(Integer iFiltered_Count)

OnLeftClick_GroupBox(Handle hoColumn)

OnLeftClick_Header(Handle hoColumn)
-------------------------------------------------------------------------
Hooks for left click options

OnLeftClick_ReportArea(Handle hoColumn Handle hoRow Handle hoItem)

OnLoad_End(Integer iRow_Count)

OnLoad_Monitor(Integer iRow_Count)

OnLoad_Start(Integer iMax_Rows)

OnOpen_DataSource()
-------------------------------------------------------------------------

OnPrepare_RowData()
-------------------------------------------------------------------------

OnProcess_Rows(String sID String sProcess_Type Boolean ByRef bCancel)

OnProcess_Rows_RowID(RowID Row_ID String sProcess_Type Boolean ByRef bCancel)

OnRefresh_Report()
User hook sent at the start of the Refresh_Report method

OnReport_Row_Count(Integer iRow_Count)

OnSelected_Row_Count(Integer iSelectedCount)

OnSetColumnFormats()

OnSetGrouping(tdRC_Ordering[] ByRef taRC_Ordering)

OnSetItemColor(Integer iColumn String sValue)

OnSetOrdering(tdRC_Ordering[] ByRef taRC_Ordering)
=========================================================================

OnSetRowColor(Integer iColumn String sValue)
Boolean
pbPreviewMode()
Integer
piBackColor()
Integer
piColumn_Count()
Integer
piDriverIndex(String sDriver)
------------------------------------------------------
Function : piDriverIndex
Scope : Public
Parameters : sDriver - Name of driver as returned by DF_FILE_DRIVER
Returns : Integer - ID of the driver, if present.
Purpose : Different workstations may have different drivers installed. This functions (lifted from the help)
loops through a machines installed drivers matching their names to the passed value. If found
the this index can be used in the "Driver" series of Get_Attribute for querying further values
Notes :
------------------------------------------------------
Integer
piFiltered_Row_Count()
Integer
piFreezeColumnsCount()
Integer
piRow_Count()
Integer
piSelected_Row_Count()

PreviewReport()
-------------------------------------------------------------------------

PrintReport()

Process_Rows()
-------------------------------------------------------------------------

Prompt()
=========================================================================
The following procedures are to stop data aware error messages
String
psConnectionStringFromID(String sDriver String sConnectionID)
------------------------------------------------------
Function : psConnectionStringFromID
Scope : Public
Parameters : sDriver - Name of driver as returned by DF_FILE_DRIVER
sConnectionID - "Fake" login with a connection ID instead of connection string
Returns : String - connection string
Purpose : Having found the driver in use. Walk through its registered connection ID until
we find the one one we're interested in a return its connection string.
Notes :
------------------------------------------------------

Rebuild_Report()
=========================================================================
General

Refresh_Report()

Remove_Sorted_Columns()

Report_Row_Count()
=========================================================================
Count Hooks

Request_Clear()

Request_Clear_All()

Request_Delete()

Request_Save()

Reset_Data_Properties()
~~~~~~~~~~~~~~~~~~~~~~~~~~

Resync_to_Focus_Row()

SelectAll()
=========================================================================
Selection

Selected_Row_Count()

Set(Boolean bOk)
-------------------------------------------------------------------------
Support for Obsolete Code

Set(Integer iCount)

Set(Integer iColor)

Set(Boolean bValue)

Set(Boolean bState)
-------------------------------------------------------------------------

Set(String sValue)

Set(String sValue)

SetWatermark()
Use Set peDataflex_Table_Find_Method to eRC_Find_Normal
Options eRC_Find_Normal eRC_Find_RequestRead eRC_Find_Constrained
-------------------------------------------------------------------------

SortGridByColumn(tdRC_Ordering[] tRC_Ordering)

Standard_PrintFooter()
=========================================================================
Other features

Superfind()

Superfind_Next()

Superfind_Previous()
References (4):