Page 1 of 1
Work with SQL parameters
Posted: Mon Jun 19, 2006 11:57 am
by 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"
Work with SQL parameters
Posted: Mon Jun 19, 2006 11:59 am
by Edward
AndrewSantana wrote: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