Select INTO issue with report parameter

  • My script has sql parameters passing into a select statement that does an INTO a temp table. It runs fine in the Data tab. When i comment out a declared variable and declare it as a Report Parameter, I keep getting a "must declare the scalar variable". However, if I remove the INTO and just do a straight Select, the Report Parameter works. Am I doing something wrong or does SRS does not like the INTO statement with Report Parameters?

  • Nevermind, when I refreshed the Report Datasets, it worked. Go figure.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply