8 Replies Latest reply: Dec 13, 2012 7:04 AM by exel_cs RSS

    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