we have a outpout which is sort by some fields ,while the result is not what we expected.

[WuCong]

we sort by sort order: CHECKID, STUDYID, SITEID, SUBJID, VISITID, VISITINDEX, FORMID, {Vital Signs Logline}

while