Unanswered: Reporting Services DATE NOT SHOWING IN DESCENDIGN ORDER IN PREVIEW???
Hi everyone, its been long time, i came back here to discuss problems i am facing..in SQL SERVER 2000 Reporting services HAPPY NEW YEAR >>
OK guys here is a problem i am facing i have Date issue in Preview my Date is appearing in Ascending order in Preivew, but if u look at the Query ..
SELECT CONVERT(datetime, CAST(CreatedTime AS varchar(11)), 112) AS Time1, SourceSystem, DestinationSystem, Type, SubType, COUNT(1)
WHERE (CreatedTime > CONVERT(DATETIME, '2003-12-01 00:00:00', 102)) AND (CreatedTime < CONVERT(DATETIME, '2004-12-01 00:00:00', 102))
GROUP BY CONVERT(datetime, CAST(CreatedTime AS varchar(11)), 112), SourceSystem, DestinationSystem, Type, SubType
ORDER BY CONVERT(datetime, CAST(CreatedTime AS varchar(11)), 112) DESC, CountValue DESC
I set date in Descending order, But in Preview it showed me in Ascending order, Making any change in SQL Data is not effecting. IS there any way i can go in Layout and make it Descending. I want Januaray 2005 Reports to come first rather then having my Januaray of 2004 Reports showing up as first page in my reports... its a issue holding me back from all of my other work.... which sucks.. if someone can let me know what to do here , i would really appreciate it.