Home > IT Answers > Database > Order by using case statement SRS 2000
Wi sundevil
5 pts.
 Order by using case statement SRS 2000
CASE statement, SQL Server Reporting Services, SRS 2000
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?

Software/Hardware used:
ASKED: June 11, 2008  6:38 PM
UPDATED: September 20, 2008  11:14 PM
RELATED QUESTIONS
Answer Wiki:
Put the select statement within a stored procedure then call the procedure. This way SSRS can't futz with the select statement.
Last Wiki Answer Submitted:  September 20, 2008  11:14 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _