Report builder sorting error

[pentel]

Hello,

I have a error every time I try to use the "sorting" tab in the report builder. I managed to make reports like I want them, but they are not sorted properly. When I try sorting by tblComputers.Computername, it will always give me the error such as in the image attached. Can anyone help me with this? I have tried to figure it out but am still at a loss with this and cannot afford to lose more time with it.

Thank you

[Hemoco]

See this screenshot, just type in the text

[pentel]

Hello,

I searched high and low for where to add this, went to SQL Management Studio Express and could create views (but they couldn't be added to the Configuration utility). I'm wondering if you could be a bit more specific about this whole sorting thing... If possible, can you also let me know how to add views made in SQL Management Studio to the configuration utility?

Hopefully this will all be "sorted" out, thanks.

[Hemoco]

You need to add "top 100 percent"

select top 100 percent from ...