Can't seem to make any kind of interactive sort work within a Matrix. Is it possible? I've got the interactive sort to work in a Table.
In a Matrix, the sort buttons come up, but they don't have any affect on the presentation of the data (columns). In the matrix, I think I've used every possible combination of Current Scope, Choose Data Region or Grouping, Detail Scope and the second Choose Data Region or Grouping.
Any help or suggestions would be most appreciated.
I'm wondering - how did you make the interactive sort work within a table? Perhaps my problem is that my table is a drill-down. I can't find an interactive sort feature or property.|||Please Ddisregard my post, I found the Interactive Sort property. Interstingly, Interactive Sort is not in the help file. I love this product, it's so great that I think 2.0 will be a true firestorm.|||I've also noted that the "Subtotal" feature in a Matrix does not appear to work logically. It seems when you have a variable amount of columns returned in your query, the "Subtotal" does not sum the columns, only the first column is sum'd (which is worthless).
There is an open ticket with Microsoft on the "Matrix / Interactive Sort" issue (SRX060307603449). Been waiting a week now...
|||Interactive sort may not work for Matrix report.
No comments:
Post a Comment