Inline View

I'm trying to take table data and display the data horizontal....  I need to take the column and show the results in one row.  I have tried several different inline view (queries) and get multiple rows.  Here is an example.... It brings back three rows with each column in a different row.


select distinct i.reportid,
(select ivalue from item where ifield like '%IP Address%' and ifield = i.ifield and ivalue = i.ivalue) AS IPAddress,
(select ivalue from item where ifield = 'Computer Name' and ifield = i.ifield and ivalue = i.ivalue) AS Computer
from item i
where i.reportid = 1
order by 1


Any suggestions?

Thanks,
Melissa