This discussion is archived
2 Replies Latest reply: Jun 28, 2013 9:10 PM by Sasi Nagireddy RSS

Repository variable with report level prompts

992209 Newbie
Currently Being Moderated

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?


  • Correct Answers - 10 points
  • Helpful Answers - 5 points