>>>>>Also don't use private datasession for the report.
>>>>
>>>>im not..private data sessions isnt checked :(
>>>
>>>Do you get the same problem running this report in command window after opening the view?
>> OMG!!!!how do u kno it would work if i ran it from command!!!
>>no it works from command window. *GASP*
>
>It means that Sergey was correct and you're not selecting the right alias when you're running this report. Make sure that
>
>select ViewAlias
>report form ...
>
>commands are very close.

ok...it works fine now! i probaby had the wrong table in an int somewhere. Thanks!