5 pts.
 Order by using case statement 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

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.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _