0

I'm trying to test setting up a data driven subscription that takes a parameter from the report but it wont validate the query, should I be able to do this.

SP: Select * from Table where Column = @Variable

The @Variable is called the same of the report.

This is 2017 version of reporting services

user3691566
  • 303
  • 2
  • 8
  • 17
  • You are referring to the query in the subscription, not the report, correct? This query does not allow parameters because it is meant to run on a schedule without interaction from a user. – StevenWhite Feb 07 '19 at 15:23
  • ah ok thanks, I was hoping to pass a variable in instead of having to code it in and wasn't sure if there was a setting I was missing or a permission I needed to apply to use parameters. – user3691566 Feb 07 '19 at 15:30
  • No problem, I moved it to an answer since it addressed your question. – StevenWhite Feb 07 '19 at 15:40

1 Answers1

0

The subscription query does not allow parameters because it is meant to run on a schedule without interaction from a user.

StevenWhite
  • 5,907
  • 3
  • 21
  • 46