Dynamic Subscription query with parameters????

• jbalbo

  SSCertifiable

  Points: 7583

  More actions

  October 26, 2023 at 8:01 pm

  #4315508

  Hi,

   

  I'm trying to create a query within a dynamic subscription with a parameter for a  Start  and End Date.

  The query will not validate when I try to use @StartDate and @EndDate

  Something like:

  WILL VALIDATE --- Select ID from mytable where date between '10/1/23' and '10/31/23'

  Once I change the date to Parameters it won't validate

  WILL NOT VALIDATE --- Select ID from mytable where date between  @StartDate and @EndDate

  The parameters are in the main report

   

  Thanks

  Joe

   

   

• jbalbo

  SSCertifiable

  Points: 7583

  More actions

  October 26, 2023 at 8:19 pm

  #4315519

  Ok, sorry, I did not Define Start and End Dates.....

   

  But , do the value not get passed from the reports main report to the subscriptions query?

  Because when I ran it it got zero results