Hi all,

in my invoicing program i saved data like this :

   link_id inv_id  description       amount
        101    1     telephone bill            50
        101    2     electricity bill           100
        102    1     telephone bill            75
        401    2     electricity bill           200
        401    3     taxi bill                     75
         401   4     Misc                        100


note: inv_id (1= telephone bill, 2= electricity, 3=taxi, 4 = misc)


How can i take report like this

link_id      Tel          electricity       taxi     Misc.
101          50            100                 0        0
102           75            0                    0        0
401           0              200              75      100


I use vb6 with crystal report  8, oracle 8.1.7

I would be apprecaite if anyone could help me in this regard,

sm