none
Matrix Report RRS feed

  • 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

    Thursday, July 26, 2012 5:33 AM

All replies

  • 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)

    Thursday, July 26, 2012 6:17 AM
  •  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...

    See the Screenshot

     

    Thursday, July 26, 2012 12:41 PM