Hi Crystal-report-experts,

I hope i can find some help here;

I have 1 table 'list' with 3 fields: 'Class', 'value' and 'num'

'select * from list order by num,class' gives me :

class   - value - num
---------------------
FirstName - John - 1
Name -  Lennon - 1
FirstName - Ringo- 2
Name  - Star  - 2
Firstname  - Paul - 3
Name - mcartney  -3
Firstname - George - 4
Name  - Harrison  - 4 
....
... 

now i want a report that display these values like

John Lennon
Ringo Star
Paul Mcatrney
George Harrison
...
...

could someone point me in the right direction ?

Txs for the reply...

i get a error on the query.
SQL not properly ended error

btw... my table are more like this

Class                 Value                  Num
First Name         John                    1
First Name         Ringo                   2
First Name         Paul                     3
First Name        George                 4
Name                Lennon                1
Name                Star                     2
Name                Mcartney             3
Name                Harrison              4
Birthday            09/10/1940         1
Birthday            07/07/1940         2
Birthday           18/06/1942          3
Birthday           25/02/1943          4
comment          comment John      1
comment          comment Ringo     2
comment          comment paul       3
comment          comment George  4


and i need a result like

John Lennon 09/10/1940 comment John
Ringo Star    07/07/1940 comment Ringo
Paul Mcartney 18/06/1942 comment Paul
George Harrison  25/02/1943  comment George

so if you could change the query...

  


Edited by tsar - 13 Mar 2008 at 5:26am

don't think this is ok..

select VALUE, birthday 'bday', comment, num from list....
"birthday" and "comment" is not a field... they are a value in the field 'Class'


database = oracle

txs.