2 Replies Latest reply: Jun 28, 2013 11:10 PM by Sasi Nagireddy RSS

    Repository variable with report level prompts


      Hi Gurus,

      i want to display previous year ,current year into one prompt.


      i have created two repository variables with the name of previous year and current year . i have tried for sql results its giving me odbc error.

      SELECT @{biServer.variables['currentyear']['previousyear']}  "year"."year ID" FROM "table a" these query is giving odbc error. could you please help me out to resolve these issue?