Work with SQL parameters

[AndrewSantana]

What is the syntax for including parameters in a DataSource query?
For example, if I want to use the "last_name" parameter in my query below

select * from sales where lastname="last_name"

[Edward]

What is the syntax for including parameters in a DataSource query?
For example, if I want to use the "last_name" parameter in my query below
select * from sales where lastname="last_name"

You need use symbol @ [$]|[:]|[?] before parameter name. It depends of server you use.
Please see "Master-Detail with parameters" report in Demo.exe.

1.Add parameter to your Datasource with name @last_name.
2.In DataSource please type sql query as listed bellow:

Code: Select all

select * from sales where lastname=@last_name