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 |
|
duhaas
Constraint Violating Yak Guru
310 Posts |
 Posted - 2006-09-15 : 11:42:08
|
| I have the following:= SUM(Fields!Account_Market_Value.Value)I want to add the sortoder expression in descending order, and am not sure how to apply the syntax. |
|
|
jhocutt
Constraint Violating Yak Guru
385 Posts |
Posted - 2006-09-15 : 11:47:12
|
| order by SUM(Fields!Account_Market_Value.Value) desc"God does not play dice" -- Albert Einstein"Not only does God play dice, but he sometimes throws them where they cannot be seen." -- Stephen Hawking |
 |
|
|
duhaas
Constraint Violating Yak Guru
310 Posts |
Posted - 2006-09-15 : 11:52:12
|
| order by =SUM(Fields!Account_Market_Value.Value) desc???? where do i put the =, sorry about this, i appreciate your help |
|
|
|
jhocutt
Constraint Violating Yak Guru
385 Posts |
Posted - 2006-09-15 : 11:54:26
|
| You don't"God does not play dice" -- Albert Einstein"Not only does God play dice, but he sometimes throws them where they cannot be seen." -- Stephen Hawking |
|
|
|
duhaas
Constraint Violating Yak Guru
310 Posts |
Posted - 2006-09-15 : 11:55:53
|
| problem is with that as my expression, i get that as my value, not an actualy sum total? so the report shows just that in the column 'order by SUM(Fields!Account_Market_Value.Value) desc' i am using SRS2000 |
|
|
|
duhaas
Constraint Violating Yak Guru
310 Posts |
Posted - 2006-09-18 : 10:10:23
|
quote:
Originally posted by duhaas
problem is with that as my expression, i get that as my value, not an actualy sum total? so the report shows just that in the column 'order by SUM(Fields!Account_Market_Value.Value) desc' i am using SRS2000
I found my problem, i just edited the RDL File directly, seemed to work |
|
|
|
|
|
|
Sort Expression