I don't know if anyone ever ran into this, but hopefully someone can shed
some light onto this for me:

When selecting via IBOConsole here is the order. (SELECT ID from EXAMS)
BX
BX-CB
M-ADD
M-SCR
MRI
MSCR

But when selection is done via crystal reports then its:
BX
BX-CB
M-ADD
MRI
MSCR
M-SCR

And if I use selection formula of ID <= "M-SCR" my result is:

BX
BX-CB
M-ADD
M-SCR
(missing 2 procedures)

If I use selection formula ID <= "MSCR" then my result is:

BX
BX-CB
M-ADD
MRI
MSCR

Incorrect records are returned via Crystal reports both times. So just
hoping anyone knows of this issue or has heard of it?

Thanks for any help,


Chris Voronin