Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rwlopez
Yak Posting Veteran
80 Posts |
 Posted - 2007-03-12 : 18:11:17
|
| I created a stored procedure will feed several reports. The SQL in the SP does not contain an ORDER BY statement. Each report will require different sort orders so I want to sort the data on each report. To do this I should be able to go into Table Properties and click on the Sorting Tab and add the fields that I want to sort by, however when I do this the data is sorted differently but not in the correct order. I am not sure what order it is even in. It does not make any sense; I think that there must be a bug in Reporting Services. I am trying to avoid creating a separate SP for each report, since there is not a need. Has anyone had the same problem? I have read similar posts, but no one has responded. |
|
|
rwlopez
Yak Posting Veteran
80 Posts |
Posted - 2007-03-12 : 19:01:07
|
| Never Mind. I just used a dynamic ORDER BY to get around the issue. |
 |
|
|
|
|
|
Sorting Problem