Class: cSigCJReportControl

Module location: cSigCJReportControl.pkg line 275 (view source)

-----------------------------------------------------------------------------

Class Hierarchy:

DFCOMACTIVEXCONTROLcComActiveXControlcSigCjComReportControlcSigCJReportControl

Mixins:

cSigCJMethods_Mixin, cSigCJPropEx_Mixin,

Class Definition

Properties

BooleanpbActive_Track
BooleanpbAuto_Columns
BooleanpbAuto_Fill
BooleanpbAuto_Row_Ref
BooleanpbCollapseGroups
BooleanpbColumn_Resort
BooleanpbDefaultLayout
BooleanpbDescending
BooleanpbEOF
BooleanpbFreezeColumns
BooleanpbItem_Colors
BooleanpbPrintLandscape
BooleanpbRefreshRequired
BooleanpbRow_Colors
BooleanpbRow_Item
BooleanpbRowID_Mode
BooleanpbShow_Recnum
BooleanpbShowGroupBox
BooleanpbSQL_Case
BooleanpbWatermarkFromFile
BooleanpbWordWrap
IntegerpeDataflex_Table_Find_Method
IntegerpeDb_Type
IntegerpeHitTest
HandlephoContextMenu_GroupBox
HandlephoContextMenu_Header
HandlephoContextMenu_ReportArea
HandlephoDD
HandlephoFieldChooser
HandlephoFont
Font Support
HandlephoHitTestInfo
HandlephoPrintPageHeaderFooter
HandlephoReportColumn
HandlephoReportColumnOrder
HandlephoReportColumns
HandlephoReportGroupRow
HandlephoReportPaintManager
HandlephoReportPrintOptions
HandlephoReportRecord
HandlephoReportRecordItem
HandlephoReportRecordItemMetrics
HandlephoReportRecords
HandlephoReportRow
HandlephoReportRows
HandlephoReportSelectedRows
IntegerpiCh_No
IntegerpiItem_BackColor
IntegerpiItem_ForeColor
IntegerpiLoad_Monitor
IntegerpiMax_Rows
IntegerpiRef_Column
IntegerpiRow_BackColor
IntegerpiRow_ForeColor
IntegerpiTable_Index
IntegerpiWatermarkAlignment
2 + 32 + 2048 = 2082
IntegerpiWatermarkWeight
NumberpnGridFontSize
NumberpnPreviewFontSize
BooleanPrivate_pbPreviewMode
HandlePrivate_phoFieldChooserList
IntegerPrivate_piColumn_Count
IntegerPrivate_piCurrentColumnIndex
IntegerPrivate_piFiltered_Row_Count
IntegerPrivate_piFreezeColumnsCount
IntegerPrivate_piRow_Count
IntegerPrivate_piSelected_Row_Count
StringpsCurrent_Tag
String[]psData_Items
StringpsExport_File
StringpsGridFontName
StringpsPreviewFontName
StringpsProcess_Type
StringpsSQL_From
StringpsSQL_OrderBy
StringpsSQL_Select
StringpsSQL_Select_Statment
StringpsSQL_Where
StringpsWatermarkBitmap
tdRC_Column_Def[]ptColumn_Defs
tdRC_Column_Format[]ptColumn_Formats
TimeSpanptsTimeSpan_Load
TimeSpanptsTimeSpan_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()
Inherited from cSigCjComReportControl
Set Color to clActiveCaption // Used only by the Studio
Create_Columns()
-------------------------------------------------------------------------
HandleCreateFieldChooserPanel()
~~~~~~~~~~~~~~~~~~~~~~~~~~
CSV_Export()
IntegerDeactivating()
========================================================================= 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()
BooleanEnsure_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)
Inherited from cSigCjCom_DReportControlEvents
OnComFocusChanging(Variant llNewRow Variant llNewColumn Variant llNewItem Boolean ByRef llCancel)
Inherited from cSigCjCom_DReportControlEvents
-------------------------------------------------------------------------
OnComGroupOrderChanged()
=========================================================================
OnComMouseUp(Short llButton Short llShift Integer llx Integer lly)
Inherited from cSigCjCom_DReportControlEvents
On Mouse Up set Left click options and Right click context menu options
OnComRowDblClick(Variant llRow Variant llItem)
Inherited from cSigCjCom_DReportControlEvents
-------------------------------------------------------------------------
OnComSelectionChanged()
Inherited from cSigCjCom_DReportControlEvents
OnCreate()
Inherited from cComActiveXControl
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)
BooleanpbPreviewMode()
IntegerpiBackColor()
IntegerpiColumn_Count()
IntegerpiDriverIndex(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 : ------------------------------------------------------
IntegerpiFiltered_Row_Count()
IntegerpiFreezeColumnsCount()
IntegerpiRow_Count()
IntegerpiSelected_Row_Count()
PreviewReport()
-------------------------------------------------------------------------
PrintReport()
Process_Rows()
-------------------------------------------------------------------------
Prompt()
========================================================================= The following procedures are to stop data aware error messages
StringpsConnectionStringFromID(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)
Inherited from cSigCJMethods_Mixin
------------------------------------------------------------------------- Support for Obsolete Code
Set(Integer iCount)
Inherited from cSigCJMethods_Mixin
Set(Integer iColor)
Inherited from cSigCJMethods_Mixin
Set(Boolean bValue)
Inherited from cSigCJMethods_Mixin
Set(Boolean bState)
Inherited from cSigCJMethods_Mixin
-------------------------------------------------------------------------
Set(String sValue)
Inherited from cSigCJMethods_Mixin
Set(String sValue)
Inherited from cSigCJMethods_Mixin
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):

ModuleContaining SymbolLine
SigCJReportControlDemo - SQL.vwoSigCJReportControl126
SigCJReportControlDemo - Table.vwoSigCJReportControl1165
SigCJReportControlDemo - Text.vwoSigCJReportControl117
SigCJReportControlDemo - TreeView.vwoSigCJReportControl123