noo i made a mistake
the view's name is vliio
and for the report fields i have vliio.status etc etc
is that bad?

>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