Thursday, July 26, 2012 5:33 AM
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.
Thursday, July 26, 2012 6:17 AM
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
- Chintak (My Blog)
Thursday, July 26, 2012 12:41 PM
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...