By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,466 Members | 1,148 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,466 IT Pros & Developers. It's quick & easy.

Interactive Sort on Matrix in RS

P: n/a
Hi,

I have a Matrix in RS and I would like to sort the data fields based
on a header. I've been searching for an answer to this and it appears
it's a common frustration.

All I'm doing:

1. Dragging a data field into the table - it automatically adds the
sum(datafield) and automatically creates a header for this column.

2. Right-Clicking the header cell and going to properties >
interactive sort.

3. Selecting the data field I just dragged-and-dropped as my sort
expression. Not the sum of the datafield, just the datafield.

I get the arrows to appear on the header properly, but clicking them
to sort does nothing. I am following the steps exactly as this video
describes:

http://www.asp.net/learn/sql-videos/video-113.aspx

I have tried all possible variations of the above - changing scopes,
trying to do it by the sum, etc and nothing works. Can anyone help me?
Feb 12 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.