Sorting Problem In Report

geosava

Hi to all i have a Report using one data item the 'Cheque' table.

My little problem is that i want to sort the lines of the report with the 'Value Date' field.

In the keys of the table 'Cheque' there is a compination of -> Bank and Branch Code,Value Date.

But if i sort in the report with this key the sorting is done logically first with Bank and Branch code and after with value date...

How can i sort clearly with the Value Date field?? :? :?

geosava

It is right to set a new key on the table??? :?: :?:

Jut

Did you check the Property DataItemTableView of the Data Item? You can choose a key for Sorting.

geosava

In the keys of the table 'Cheque' there is a compination of -> Bank and Branch Code,Value Date.

But if i sort in the report with this key the sorting is done logically first with Bank and Branch code and after with value date...

How can i sort clearly with the Value Date field??

As you can read above i have checked that and i don't have the option from there.....

Jut

Ups, I should read more precisely

The field you want use for sorting has to be a key in the table!