Iam creating a report by inserting matrix. Iam using 2 columns in the report. Col1 is a horizontal group, col2 filelds goes in to the vertical group and the count goes in to the table data field. Is there any way that I can sort the vertical group in a desired order? (not Ascending or Descending order)
In your data source, create a column which will specify the sort order (1,2,3. etc). Add this column to the report above the row or column you actually wish to sort. To prevent it from displaying, set the Hidden Property to True.