You are not logged in.
Dear users of this forum,
we are pleased to inform you that we will be updating the software behind this forum in the near future.
Existing posts, users and categories will remain untouched.
Important:
We will keep you informed in the pinned thread.
Kind regards,
Your ReportServer Team
Liebe Nutzer dieses Forums,
wir freuen uns, euch mitteilen zu können, dass wir in naher Zukunft die Software hinter diesem Forum aktualisieren werden.
Existierende Beiträge, Nutzer und Kategorien bleiben weiterhin bestehen!
Wichtig:
Wir halten euch im angepinnten Beitrag auf dem Laufenden!
Mit vielen Grüßen
Euer ReportServer Team
Pages: 1
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.
Offline
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
Offline
Pages: 1