yup! i have it in the fields and DE it works perfect for Tables...not sure why its doin that for views :(.
is this a good time too mention 1 of the tables in the view isnt from the same project?

>Are you using the table alias in the report fields?
>
>>I was just wondering if there was a rule that said a view in a report with only show the first record. cause when i use a table it works fine! shows all 30 people...but with a view it shows the 1st peron over and over.Or what else can i use instead of a view