8 Replies Latest reply on Dec 13, 2012 1:04 PM by exel_cs

    Adding SQL to Filter

    exel_cs
      Hi Experts

      I am trying to add SQL to a Filter that involves the year attribute (To show data for current year)

      This is the following SQL I have entered for this filter :

      "Time Period"."Year" = "SELECT DATENAME(YEAR, GETDATE())"

      However my report does not display, after this filter has been modified (with the SQL)

      Please advise

      Hiten