Matrix Report

Question

I am using month and year as Int only, i did order by Year,Month... but still data are not sorted.In database the data is sorted but while generating the report it is not?

Give any suggestions that will be helpful.

Regards,

Swapna.S

Answer 1

Hi,

you should check the sort expression of the row and column group of your matrix report.

---

Aftab Ansari

Answer 2

Do you provide the sorting information in the Matrix itself? (Ordering your data in the SQL query will not work.)

---

The Data Specialist (Blog)

Answer 3

Hi Swapna,

Please check if you have sorting defined at the group level. To do that, Go to Group -> Sorting as shown in the figure below and make sure that you are not sorting the group by other columns.

---

Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com