Database Search
If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.
TechHome
Dialog Editor version 6.2
 |
- Areo Window Borders Issue
- Calendar Control Problem
- Change Calendar Control Style
- DEFAULT Text Attributes For MenuItems Cause Assertion Error
- Dialog Clock
- Dialog Editor Crash
- DialogControlGet Selected Text
- Display Excel Data in Dialog
- Drag and Drop a File in Dialog
- Dual Timer Event
- Dynamic Dialog Not Responding
- EULA
- Focus Change
- Handle Both Itembox Select and Itembox Double-Click
- Index of Droplistbox Selection
- ItemBox Add and Remove Items
- Localize Dialog Caption
- Marquee Style Progress Bars Not Supported
- Modify Sort in ReportView With Header Click
- PictureButton Issue
- PushButton to Set Invisible Style for RadioButtons
- Radiobutton Group With None Selected
- ReportView Highlight
- Reportview Select All Checkboxes
- ReportView Select vs Checked
- Reportview Set Column Width
- ReportView Single Click
- ReportView Size Based on Row Count
- Resize Event
- Use WindowOnTop With Dialog
Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Modify Sort in ReportView With Header Click
Keywords: Modify Alternate Ascending Descending Toggle Sort ReportView Grid Column Header Click Direction Dialog Callback Procedure Style DialogControlState DCSTYLE_SORTDESC DCSTYLE_SORTASCDCSTATE_QUERYSTYLE DCSTATE_REMOVESTYLE DCSTATE_ADDSTYLE
Question:
Is there a way to sort a grid by clicking on the column header such that the Sort Direction alternates between Ascending and Descending?Answer:
Yes it requires a dialog callback procedure. Basically you will create an event handler in the dialog callback procedure to manage REPORTVIEW header clicks. Then inside that procedure you will query the style of the REPORTVIEW control checking whether it is ascending or descending then toggle it.
case MSG_RVHEADER ; ID "ReportView_1" rvVariable1
;Determine Current sorting style: ascending or descending
style = DialogControlState( MyDialog_Handle, "ReportView_1", DCSTATE_QUERYSTYLE, "")
; If no style is assigned assume ascending
if style == 0 then style = DCSTYLE_SORTASC
; Toggle Sort Order
if style & DCSTYLE_SORTDESC
DialogControlState(MyDialog_Handle, "ReportView_1", DCSTATE_REMOVESTYLE, DCSTYLE_SORTDESC)
style = style &~ DCSTYLE_SORTDESC ; Remove Style Bit
style = style | DCSTYLE_SORTASC ; Add Style Bit
sortorder = @ASCENDING ; Used for Arraysort
title = 'ASCENDING v'
elseif style & DCSTYLE_SORTASC
DialogControlState(MyDialog_Handle, "ReportView_1", DCSTATE_REMOVESTYLE, DCSTYLE_SORTASC)
style = style &~ DCSTYLE_SORTASC ; Remove Style Bit
style = style | DCSTYLE_SORTDESC ; Add Style Bit
sortorder = @DESCENDING ; Used for Arraysort
title = 'DESCENDING ^'
endif
; Update Style for the Reportview Control
DialogControlState(MyDialog_Handle, "ReportView_1", DCSTATE_ADDSTYLE, style)
; Update Header Title
DialogControlSet(MyDialog_Handle, "ReportView_1", DC_RVCOLHEAD, title)
Return RET_DO_NOT_EXIT
Complete Code Sample
;***************************************************************************
;**
;** Toggle Sort in ReportView Control
;**
;** Purpose: Commonly used for text sorts
;**
;**
;** Revisions: Deana Falk 2012.07.03
;***************************************************************************
#DefineSubRoutine InitDialogConstants()
;DialogprocOptions Constants
MSG_INIT=0 ; The one-time initialization
MSG_TIMER=1 ; Timer event
MSG_BUTTONPUSHED=2 ; Pushbutton or Picturebutton
MSG_RADIOPUSHED=3 ; Radiobutton clicked
MSG_CHECKBOX=4 ; Checkbox clicked
MSG_EDITBOX=5 ; Editbox or Multilinebox
MSG_FILESELECT=6 ; Filelistbox
MSG_ITEMSELECT=7 ; Itembox
MSG_COMBOCHANGE=8 ; Combobox/Droplistbox
MSG_CALENDAR=9 ; Calendar date change
MSG_SPINNER=10 ; Spinner number change
MSG_CLOSEVIA49=11 ; Close clicked (Enabled via DialogProcOptions 1002
MSG_FILEBOXDOUBLECLICK=12 ; Get double-click message on a FileListBox
MSG_ITEMBOXDOUBLECLICK=13 ; Get double-click message on an ItemBox
MSG_COMEVENT=14 ; COMCONTROL Event notification from DialogObject (NOT DialogProcOptions)
MSG_MENUITEM=15 ; MenuItem selected
MSG_MENUITEMINIT=16 ; MenuItem initialized
MSG_RESIZE=17 ; Dialog resized
MSG_RVITEMSELROW=18 ; Reportview item select row
MSG_RVDBLCLICKROW=19 ; Reportview double-click row
MSG_RVCHECKEDITEM=20 ; Reportview checked/unchecked Item
MSG_RVITEMTEXT=21 ; Reportview changed text of first column
MSG_RVHEADER=22 ; Reportview header clicked
DPO_DISABLESTATE=1000 ; codes -1=GetSetting 0=EnableDialog 1=DisableDialog
DPO_CHANGEBACKGROUND=1001 ; -1=Get Current otherise bitmap or color string
DPO_CHANGESYSMENU=1002 ; -1=Get Current 0=none 1=close 2=close/min 3=close/max 4=close/min/max
DPO_CHANGETITLE=1003 ; Set/Get Dialog Title - (-1 to get)
DPO_GETNAME=1004 ; Returns the name associated with a control's number.
DPO_GETNUMBER=1005 ; Returns the number associated with a control's name.
DPO_GETCLIENTAREA=1007 ; Returns a space delimited list of the width and height of the client area.
;DialogControlState Constants
DCSTATE_SETFOCUS=1 ; Give Control Focus
DCSTATE_QUERYSTYLE=2 ; Query control's style
DCSTATE_ADDSTYLE=3 ; Add control style
DCSTATE_REMOVESTYLE=4 ; Remove control style
DCSTATE_GETFOCUS=5 ; Get control that has focus
DCSTATE_MOVEMOUSEOVER=6 ; Move the mouse over the control
DCSTYLE_DEFAULT=0 ; Set Default Style
DCSTYLE_INVISIBLE=1 ; Set Control Invisible
DCSTYLE_DISABLED=2 ; Set Control Disabled
DCSTYLE_NOUSERDATA=4 ; Note: Setable via DialogControlState function ONLY SPINNER control only
DCSTYLE_READONLY=8 ; Sets control to read-only (user cannot type in data) EDITBOX MULTILINEBOX SPINNER
DCSTYLE_PASSWORD=16 ; Sets 'password mode' where only *'s are displayed EDITBOX
DCSTYLE_DEFAULTBUTTON=32 ; Sets a button as the default button PUSHBUTTON PICTUREBUTTON
DCSTYLE_DIGITSONLY=64 ; Set edit box to accept digits only EDITMOX MULTILINEBOX
DCSTYLE_FLAT=128 ; Makes a 'flat' hyperlink-looking button PUSHBUTTON PICTUREBUTTON
DCSTYLE_NOADJUST=256 ; Turns off auto-height adjustment ITEMBOX FILELISTBOX
DCSTYLE_TEXTCENTER=512 ; Center text in control VARYTEXT STATICTEXT
DCSTYLE_TEXTRIGHT=1024 ; Flush-Right text in control VARYTEXT STATICTEXT
DCSTYLE_NOSELCURLEFT=2048 ; No selection, cursor left EDITBOX MULTILINEBOX
DCSTYLE_NOSELCURRIGHT=4096 ; No selection, cursor right EDITBOX MULTILINEBOX
DCSTYLE_SHIELD=8192 ; Display Security Shield icon on button (Vista only) PUSHBUTTON PICTUREBUTTON
DCSTYLE_MENUCHECK=32768 ; Adds a check mark to the left of a menu item MENUITEM
DCSTYLE_MENURADIO=65536 ; Adds a radio button like dot graphic to the left of a menu item MENUITEM
DCSTYLE_MENUSEP=131072 ; Separator bar graphic MENUITEM
DCSTYLE_MENUBREAK=262144 ; Column break MENUBAR
DCSTYLE_NOHEADER=524288 ; No header bar REPORTVIEW
DCSTYLE_COLHEADER=1048576 ; First row column header REPORTVIEW
DCSTYLE_GRIDLINES=2097152 ; Grid lines REPORTVIEW
DCSTYLE_SELONEROW=4194304 ; Only one row can be selected at a time REPORTVIEW
DCSTYLE_SELALLROW = 8388608 ; Highlight complete row REPORTVIEW
DCSTYLE_SORTASC=16777216 ; Ascending sort REPORTVIEW
DCSTYLE_SORTDESC=33554432 ; Descending sort REPORTVIEW
DCSTYLE_EDITCOL=67108864 ; Edit first columns text REPORTVIEW
DCSTYLE_COLCHECKBOX=134217728 ; Add checkbox to first column REPORTVIEW
;DialogControlSet / DialogControlGet Constants
DC_CHECKBOX=1 ; CHECKBOX REPORTVIEW
DC_RADIOBUTTON=2 ; RADIOBUTTON
DC_EDITBOX=3 ; EDITBOX MULTILINEBOX
DC_TITLE=4 ; PICTURE RADIOBUTTON CHECKBOX PICTUREBUTTON VARYTEXT STATICTEXT GROUPBOX PUSHBUTTON MENUITEM
DC_ITEMBOXCONTENTS=5 ; ITEMBOX FILELISTBOX DROPLISTBOX REPORTVIEW
DC_ITEMBOXSELECT=6 ; ITEMBOX FILELISTBOX DROPLISTBOX REPORTVIEW
DC_CALENDAR=7 ; CALENDAR
DC_SPINNER=8 ; SPINNER
DC_MULTITABSTOPS=9 ; MULTILINEBOX
DC_ITEMSCROLLPOS=10 ; ITEMBOX FILELISTBOX
DC_BACKGROUNDCOLOR=11 ; RADIOBUTTON CHECKBOX VARYTEXT STATICTEXT GROUPBOX PUSHBUTTON ITEMBOX FILELISTBOX DROPLISTBOX SPINNER EDITBOX MULTILINEBOX REPORTVIEW
DC_PICTUREBITMAP=12 ; PICTURE PICTUREBUTTON
DC_TEXTCOLOR=13 ; RADIOBUTTON CHECKBOX VARYTEXT STATICTEXT GROUPBOX PUSHBUTTON ITEMBOX FILELISTBOX DROPLISTBOX SPINNER EDITBOX MULTILINEBOX REPORTVIEW
DC_ITEMBOXADD=14 ; ITEMBOX FILELISTBOX DROPLISTBOX REPORTVIEW
DC_ITEMBOXREMOVE=15 ; ITEMBOX FILELISTBOX DROPLISTBOX REPORTVIEW
DC_RADIOVALUE=16 ; RADIOBUTTON
DC_POSITION=17 ; ALL CONTROLS (Except MENUBAR and MENUITEM)
DC_MENUNAMES=18 ; ALL CONTROLS
DC_HANDLE=19 ; ALL CONTROLS (Except MENUBAR and MENUITEM)
DC_RVCOLHEAD=20 ; REPORTVIEW
DC_RVCOLWIDTH=21 ; REPORTVIEW
DC_RVADDCOL=22 ; REPORTVIEW
DC_RVREMOVECOL=23 ; REPORTVIEW
DC_RVMATCHCOL=24 ; REPORTVIEW
DC_RVCANCELEDIT=25 ; REPORTVIEW
DC_RVCHECKEDROWS=26 ; REPORTVIEW
DC_RVJUSTIFY=27 ; REPORTVIEW
;DialogObject constants
DLGOBJECT_ADDEVENT=1 ; Call dialog callback when the specified event occurs
DLGOBJECT_STOPEVENT=2 ; Stop calling dialog callback when an event previously requested with
DLGOBJECT_GETOBJECT=3 ; Return an object references to the specified control
DLGOBJECT_GETPICTURE=4 ; Create and return an object reference to a picture object
;Return code constants
RET_DO_CANCEL=0 ; Cancels dialog
RET_DO_DEFAULT= -1 ; Continue with default processing for control
RET_DO_NOT_EXIT= -2 ; Do not exit the dialog
Return
#EndSubRoutine
;============================================================
;============================================================
;============================================================
#DefineSubRoutine MyDialogCallbackProc(MyDialog_Handle,MyDialog_Message,MyDialog_Name,MyDialog_EventInfo,MyDialog_ChangeInfo)
InitDialogConstants() ; Initialize Dialog Constants
ON_EQUAL = @TRUE ; Initialize variable ON_EQUAL
Switch MyDialog_Message ; Switch based on Dialog Message type
Case MSG_INIT ; Standard Initialization message
; Handle These events
DialogProcOptions(MyDialog_Handle,MSG_BUTTONPUSHED,@TRUE) ;Button pushed
DialogProcOptions(MyDialog_Handle,MSG_RVHEADER,@TRUE) ;Header click
; Define Header Column Title
If sortorder == @ASCENDING Then DialogControlSet(MyDialog_Handle,"ReportView_1",DC_RVCOLHEAD,"ASCENDING NUMBER SORT v")
Else DialogControlSet(MyDialog_Handle,"ReportView_1",DC_RVCOLHEAD,"DESCENDING NUMBER SORT ^")
; Adjust Column width
DialogControlSet(MyDialog_Handle,"ReportView_1",DC_RVCOLWIDTH,"-2 -2")
Return(RET_DO_DEFAULT)
Case MSG_BUTTONPUSHED
If MyDialog_Name == "PushButton_OK" ; OK
Return(RET_DO_DEFAULT)
ElseIf MyDialog_Name == "PushButton_Cancel" ; Cancel
Return(RET_DO_CANCEL)
EndIf ; MyDialog_Name
Return(RET_DO_DEFAULT)
Case MSG_RVHEADER ; ID "ReportView_1" rvVariable1
;Determine Current sorting style: ascending or descending
style = DialogControlState( MyDialog_Handle, "ReportView_1", DCSTATE_QUERYSTYLE, "")
; If no style is assigned assume ascending
If style == 0 Then style = DCSTYLE_SORTASC
; Toggle Sort Order
If style & DCSTYLE_SORTDESC
DialogControlState(MyDialog_Handle, "ReportView_1", DCSTATE_REMOVESTYLE, DCSTYLE_SORTDESC)
style = style &~ DCSTYLE_SORTDESC ; Remove Style Bit
style = style | DCSTYLE_SORTASC ; Add Style Bit
sortorder = @ASCENDING ; Used for Arraysort
title = 'ASCENDING v'
ElseIf style & DCSTYLE_SORTASC
DialogControlState(MyDialog_Handle, "ReportView_1", DCSTATE_REMOVESTYLE, DCSTYLE_SORTASC)
style = style &~ DCSTYLE_SORTASC ; Remove Style Bit
style = style | DCSTYLE_SORTDESC ; Add Style Bit
sortorder = @DESCENDING ; Used for Arraysort
title = 'DESCENDING ^'
EndIf
; Update Style for the Reportview Control
DialogControlState(MyDialog_Handle, "ReportView_1", DCSTATE_ADDSTYLE, style)
; Update Header Title
DialogControlSet(MyDialog_Handle, "ReportView_1", DC_RVCOLHEAD, title)
Return RET_DO_NOT_EXIT
EndSwitch ; MyDialog_Message
Return(RET_DO_DEFAULT)
#EndSubRoutine ; End of Dialog Callback MyDialogCallbackProc
;***************************************************************************
;**
;** Define an array to display in the REPORTVIEW control
;**
;***************************************************************************
rvNumericGrid = ArrDimension(1011,2)
For x = 0 To 1010
rvNumericGrid[x,0] = x
rvNumericGrid[x,1] = "Row# ":x
Next
;***************************************************************************
;**
;** Define starting sort order
;**
;***************************************************************************
sortorder = @ASCENDING
;***************************************************************************
;**
;** WIL Dialog Containing a REPORTVIEW Control
;**
;***************************************************************************
MyDialogFormat=`WWWDLGED,6.2`
MyDialogCaption=`Sort Toggle in ReportView Control`
MyDialogX=138
MyDialogY=141
MyDialogWidth=436
MyDialogHeight=243
MyDialogNumControls=003
MyDialogProcedure=`MyDialogCallbackProc`
MyDialogFont=`DEFAULT`
MyDialogTextColor=`DEFAULT`
MyDialogBackground=`DEFAULT,DEFAULT`
MyDialogConfig=0
MyDialog001=`105,213,036,012,PUSHBUTTON,"PushButton_OK",DEFAULT,"OK",1,10,32,DEFAULT,DEFAULT,DEFAULT`
MyDialog002=`261,213,036,012,PUSHBUTTON,"PushButton_Cancel",DEFAULT,"Cancel",0,20,DEFAULT,DEFAULT,DEFAULT,DEFAULT`
MyDialog003=`033,013,362,186,REPORTVIEW,"ReportView_1",rvNumericGrid,DEFAULT,DEFAULT,30,DEFAULT,DEFAULT,DEFAULT,DEFAULT`
ButtonPushed=Dialog("MyDialog")
Exit
Article ID: W17727
Filename: Modify Sort in ReportView With Header Click.txt
File Created: 2013:06:14:13:07:28
Last Updated: 2013:06:14:13:07:28