Hi Jody,

i tried the way that you are suggested, but it didn't work. i can see the attributes are arranged by the fiscalMonthNo in proper order ie from APRIL-March and...

For the SSRS report I am using the following MDX query

SELECT NON EMPTY { [Measures].[SLA Value] } ON COLUMNS, NON EMPTY { ([Credit Note Date].[Fis Month Name].[Fis Month Name].ALLMEMBERS *...

i am checking the SSRS furthur I have 2 row groups (Fis Month No,Fis Month Name) and 1 column group(Fioscal Year) just now , but still i can't manintaon the...

i tried the expliciy sort from the SSRS design surface , but that's not working . Is it possible to put a sort criterea onto the MDX query ?....

Jack Corbett (4/28/2009)

---

I did a little testing and I can't find anyway without an sort in the report itself that the report will show the data in a different order...

i haven't got any groups in the reports. Fiscal Month no (integer),Fiscal Month Name(Varchar)

Thanks phil, i will try that way