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

    Repository variable with report level prompts

    992209

      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?