0

How to write a Dynamic SQL query with bind/substitute variables in List and Labels report server?

When creating the Datasource I have the option to enter the query manually, but as soon I enter the bind an error message is displayed.

I want to be able to enter a dynamic query in the datasource and set the value of that bind/substitution variable.

karel
  • 5,489
  • 46
  • 45
  • 50
ccarvalho
  • 27
  • 3

1 Answers1

0

This is something that's actively being worked on. This blog post covers the basics for parametrized data sources within List & Label itself. Thorough support within the Report Server, including support for stored procedure parameters, is on the roadmap and will be released this fall.

JBartlau
  • 772
  • 5
  • 23