2 Replies Latest reply on Jun 29, 2013 4:10 AM by Sasi Nagireddy

    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?