Matrix Report

Question

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

Give your suggestions that will be helpful.

Regards,

Swapna.S

Answer 1

Hi Swapna,

There might be some datatype issue. But try following steps

1) Select the group property

2) Go to sorting

3) in sort by add formula, suppose month filed in MonthName

=CINT(Fields!MonthNumber.Value)

---

- Chintak (My Blog)

Answer 2

 Thank U very much Chintak, the issue is solved. But i have other problem  which is in my report i am using two dataset, in dataset1 should fetch all the values based on the date without any condition.

Then another dataset2 should fetch the data by using same dataset1 query based on the date but with condition...

the problem is, referrals by type is not displaying the data in order (value 2 should come under the 1/2010,1 under 2/2012 and 42 under 5/2012) even i applied order by year,month.

Kindly give ur suggestions...