5 Replies Latest reply: Nov 16, 2012 9:36 AM by 738277 RSS

    Selections for report/form......

    738277
      Hello Experts,

      I have a report,
      ==Date ====== Sales ==
      01-01-2012 === $2,325
      01-02-2012 === $1,975

      For this report I got to put two select lists....Year and Month.....

      If the user selects only Year, then it has to display all the dates of that year in the report.....If they select Year and Month then the report shows that year, month rows.....

      I am using variable :P20_YEAR, :P20_MONTH in the report sql where clause with 'AND' condition, who can i modify the sql to achieve above requirement......please suggest me your ideas....

      Thanks for your time,

      DK