Answer Posted / bobbyiiit

"Data Link" acts as a Join condition in the Report Builder
between two tables. Using the Data Link in reports we can
achieve Parent-Child relation between the tables.
The join condition produced by data link is always an Outer
Join.

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2227