ReportServer Forum

kirti

Member

Registered: 2017-01-13

Dynamic Report Issue

Hi,
Does Order By condition is supported in Dynamic Report??
Select * from table order by column
I wrote this query and it gave me following error
Query could not be executed: The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Dynamic Report Issue

Hi kirti,

sorting can be done by the "list configuration". Check https://reportserver.net/en/guides/user … en-Columns for this.
You cannot sort in the query because this query will be wrapped by another query for internal uses. So the sorting would have to be done in the external query, to which you don't have direct access. Thus, you can easily sort your dynamic list in the "list configuration" as stated in the guide.

Regards,
Eduardo