Because it references the table instead of view. Remove the alias and it should be fine.

>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