Non-sequential alphabetic sort

[#1]

Hi all,

I have some data as below sorted by date and Doc type:

Date                Doc type                             Doc No

-----------------          -------------                           -------------

1/1/11               DN    (delivery note)                     10

1/1/11               GRN (Goods received Note)         14

I want to sort first by date in ascending order (it's ok and normal) and then Doc Type GRN first and then DN to have a natural flow.

BR,

SAK

[Gysbert_Wassenaar]

Open the properties window of the chart object where you add the fields, select the Sort tab. Then move Date to the top position and set the Sort By option to Numeric Value - ascending. Move Doc type to the second position and set the Sort By option to Text - descending.

[#3]

Problem is there are more than two types of Doc Types, one starting from D, one G and one I. Then sorting in descending order does not help. I want GRN (G) on top and then D (Delivery Note) and ISS (Issues).

[Gysbert_Wassenaar]

In that case create an inline table where you fix the order

OrderedType:

Load * inline [

Doc type

DN

GRN

D

ISS ];

// other load stuff here.

Now the inline table will define the sort order you get when you use the Sort By option Load Order