add to your query:

order by case when @sortby = 'ID' then id else case when @sortby = 'Size' then size ...end end

* case when @sort = 'asc' then...

Hi,

you had to change your autentication mode for the reporting service. I suggest you to use a domain administrator account, so you are sure you have access to...