Sorting problem

Red-Eagle

Hello Experts,

I am making a report from the table Try-Out Quote. The problem i have is that i want to sort the output on the following fields:

Estimator,"Register Date",Code.

Do i need to use the dataitem Integer?

kapamarou

viewtopic.php?f=23&t=44686 :?:

Red-Eagle

We dont have the SQL version. Besides that i cant change anything in the tables.

kapamarou

Red-Eagle wrote:

We dont have the SQL version. Besides that i cant change anything in the tables.

Vital info!

I guess you could use 3 dataitems (one for each field). But I think it will be really slow...

Red-Eagle

Okay maby i can make the problem less complex.

I have now a report which looks as following:

Estimator Code Register date
1004 TO01014 11-02-2011
1106 TO00900 12-02-2011
1004 TO01015 13-02-2011
1004 TO01016 13-02-2011

What i want is that the reports going to look this way

Estimator Code Register date
1004 TO01014 11-02-2011
1004 TO01015 13-02-2011
1004 TO01016 13-02-2011
1106 TO00900 12-02-2011

Is that possible?

mohana_cse06

What keys u have for that table?

Red-Eagle

I have the following keys:

Code
Contact No. (Company),Contact No. (Person)
Register Date (which i am using now)
City,Address

mohana_cse06

I dont think this is possible without adding "Estimator Code Register date" keys in table :thumbsdown: