Object Reference
-
Classes
-
xf_DataList
-
xf_DataListExt
-
xf_Dictionary
-
xf_PassArgsBase
-
xf_SingletonCache
-
xf_SQLCache
-
- Command Interface
- External
- General
- System Core
- System Library
xf_DataListExtDataListExt Base Class
Public Sub DisplayCols_SetupHideRepeatColumns (
ColNames As String,
HideRepeatKeyColName As String
)
Allows one or more column values to be displayed as empty on the second and subsequent occurence (ie. repeats) of a row value in a specified column. This allows similar behaviour to the 'hide duplicates' funtion in MS Access reports.
ColNames as String
A comma separated string containing the column names to be hidden
HideRepeatKeyColName as String
The column in which a repeat value will trigger hiding of the columns.
Call Template:
Dim obj As New xf_DataListExt
obj.DisplayCols_SetupHideRepeatColumns ColNames, HideRepeatKeyColName
See Also:
Example 1:
Debug.Print lstExt.DisplayCols_SetupHideRepeatColumns "OrderID, OrderDate", "OrderID"