List data from multiple nodes

Hi all,

I've got a problem that's driving me crazy. I've tried for days to figure out what I'm doing wrong. The forums don't seem to shed any light on it, so I'm hoping someone can help!

Here's the background - I have a drupal site where users register, and add details of their work area/subarea within the organisation. I extended the login using node profile and CCK, so they each have a simple content type called "user info". I then created a content type - a report, that registered users submit, and used views to list this content as a table. I also create a view to list all the user info. All good so far. I need to be able to list the users work area (user info) in that table along with the report info, and I think views fusion is the way to do it, but it just won't work correctly.

For every user who has completed user info there are 2 reports listed - one without user info, one with. I'm a visual sort of person, so mabe this will be easier for you too - prior to using views fusion I get this table:

ID---user---report---date
10---john---rep1-----01/01/2008
31---fred---report----10/11/2007
44---john---rep------06/05/2008

Then after I fuse the views I get this:

ID---user---report---date-------user info
10---john---rep1-----01/01/2008
10---john---rep1-----01/01/2008--admin
31---fred---report---10/11/2007--HR
44---john---rep-----06/05/2008
44---john---rep-----06/05/2008--admin

Thanks for any help.