Group Sort Order

[pomster]

I have created a group (G2) called {@Contract Group} that basically says if isnull (Contract) then "Non Serialised" else (Contract).

Contract numbers can start with anything from A to Z or a number. I always want "Non Serialised" entries as the last group.

How do i do this??


regards,


David

CRXIR2 with CRXIR2 server and SQL 2005

 

[IanWaterman]

If you put into ascending then Z will be last

Chnaged your formula so that "Non Serialised" is "ZZ Non Serialised"

Then go to change group and select options check customise name and in formula box

If {@Contract Group} = "ZZ Non Serialised"
then "Non Serialised" else {@Contract Group}

Ian