>>>Hello!
>>>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
>>
>>Are you calling this report from a form with a grid?
>
>errr no
>its a normal report form but there are exceptions in my code like
>
>report form report1 for vliio.status="d"

In the report don't use aliases unless you're driving your report from two (or more) tables.