Home > IT Answers > Database > Order by using case statement SRS 2000
Help

Question

  Asked: Jun 11 2008   6:38 PM GMT
  Asked by: Wi sundevil

Order by using case statement SRS 2000


CASE statement, SRS 2000, SQL Server Reporting Services

I am using a case statement to order data on a SRS report, when the statement is ran, it returns the correct order, but when I save the RDL and preview it, it returns to ascending order. How do I correct this?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Sep 20 2008  11:14 PM GMT  by Mrdenny




Put the select statement within a stored procedure then call the procedure. This way SSRS can't futz with the select statement.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Database and SQL Server.

Looking for relevant Database Whitepapers? Visit the SearchOracle.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register