Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2004

    Post 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 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)
    AS CountValue
    FROM dbo.tb_Message
    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.
    Last edited by njptown20; 01-11-05 at 10:47.
    ADIL >>>>> NJ
    21 ....NY/NJ

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts