Sort by Expression

[#1]

Hi All,

How do I associate Sort Orders => Sort by Expression to a particular field in a group using a macro.

Thanks in advance

[#2]

set fld=ActiveDocument.GetField("Salesman")
set fldsrt = fld.GetDefaultSortCriteria 
fldsrt.SortByExpression = 1
fldsrt.Expression.v = "sum(Amount)"
fld.SetDefaultSortCriteria fldsrt

[#3 · Accepted solution]

Hi Miller,

Thanks for your reply. I found a way to achive this.

groups = ActiveDocument.GetGroups

set gp = groups(0).GetProperties

set sc = gp.SortCriterias

sc(0).SortByExpression = 1

sc(0).Expression.v = "sum(Amount)"

groups(0).SetProperties gp