>>>>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.