JacksonsDad
IS-IT--Management
I am using SSRS 2005 and Analysis Services as my datasource.
I have multiple tables on a given report, let's say 3. They are all using the same dataset. Each table consists of 1 column with a group filter.
When the report is viewed, each column acts as a column in a "bigger table". I am currently only able to sort on a given "column" which is its own table, and the other columns remain static. I need the other 2 columns to sort accordingly.
I suppose i somehow need each cell to believe it is part of a row.
The answer to this is imperative. Thanks in advance for any suggestions!
I have multiple tables on a given report, let's say 3. They are all using the same dataset. Each table consists of 1 column with a group filter.
When the report is viewed, each column acts as a column in a "bigger table". I am currently only able to sort on a given "column" which is its own table, and the other columns remain static. I need the other 2 columns to sort accordingly.
I suppose i somehow need each cell to believe it is part of a row.
The answer to this is imperative. Thanks in advance for any suggestions!