SORTING & REPORT

stylobleu

Hi everybody,

i want to sort a dataitem with a multiple key but in this key i need to make a ascending and descending sort

Table wine :
Name, vintage, color
wine1, 1999, red
wine1, 1993, white
wine2, 2001, white
wine1, 1998, red
wine2, 1996, red
wine2, 2001, red

I want use the key : Name(asc), vintage(desc), color(asc)
I think it's not possible to do this.

Can you help me ?

I would like to have on my report :

wine1, 1999, red
wine1, 1998, red
wine1, 1993, white
wine2, 2001, red
wine2, 2001, white
wine2, 1996, red


++
Stylobleu

Slawek_Guzek

stylobleu wrote:

I want use the key : Name(asc), vintage(desc), color(asc)
I think it's not possible to do this.

Yes, you are correct, you can't have vintage(desc) order.

What you can do is to add new integer column, called "Negative vintage" for example, on validation routine of vintage column fill "negative vintage" with -vintage value. You should also write some report/code to prefill "Negative vintage" column

Then add secondary key: Name, "negative vintage", color and use thast key for sorting on your report.

The above workaround will work fine if vintage is integer column.

Regards,
Slawek

jversusj

could you group based on wine, but sort the records based on year (key includes wine and year)?