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 |
|
bushfoot
Yak Posting Veteran
53 Posts |
 Posted - 2008-11-20 : 10:33:11
|
| I have create a report parameter to allow the user to select the column to use for sorting the report. The choices are to sort by activity period or by call count.I right click on the grouping and select edit grouping. Then I select Sorting.In the expression i put IIF(Parameter!SortBy.Value = 0, Fields!ActivityPeriod.Value, Fields!CallCount.Value)When I run the report the report is NOT sorted based on the option selected in the parameter. Any ideas what I did wrong or what I missed? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-20 : 10:47:23
|
| have you applied any grouping? if not you need to put expression under sorting tab in table properties |
 |
|
|
bushfoot
Yak Posting Veteran
53 Posts |
Posted - 2008-11-20 : 11:02:35
|
| There is a grouping.. its on the Activity Period column. The idea is that the customer can run the report in 15, 30, 60, Day of Week, Day of Month and Month. I put the sorting against the group.So activity period is the groupCall count is the body part of the reportI THINK (not total sure yet) the activity period is working ok, but the call count is working at all |
|
|
|
bushfoot
Yak Posting Veteran
53 Posts |
Posted - 2008-11-20 : 11:12:10
|
| It does sort properly on the activity period column. I assume this has something to do with the fact that its a matrix report. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-20 : 11:19:40
|
quote:
Originally posted by bushfoot
It does sort properly on the activity period column. I assume this has something to do with the fact that its a matrix report.
is callcount existing as numeric from table. or is it varchar? |
|
|
|
bushfoot
Yak Posting Veteran
53 Posts |
Posted - 2008-11-20 : 11:37:19
|
| its a number... its ok tho. I believe my problem is the matrix itself. The report does NOT need to be a matrix. I will change the format of the report. I maybe back if some of my TRUE matrix reports fall into this issue.Do you know of any tools that will convert a matrix based rdl doc to table based rdl doc? |
|
|
|
|
|
|
Sorting Express based on report parameter