For example, in T-SQL we would write:
SELECT id, name
FROM
myTable
WHERE
cond = @param
while in PL/SQL we would write:
SELECT id, name
FROM
myTable
WHERE
cond = :param
Also, don't forget to pass the report parameter variable value to the dataset parameter on the dataset properties tab aptly called "Parameters". See below for the screen shot in 2008.
Also, don't forget to pass the report parameter variable value to the dataset parameter on the dataset properties tab aptly called "Parameters". See below for the screen shot in 2008.
woking done..thanks
ReplyDeleteExcellent. I've been looking for similar solution, and this is exactly what I need. Thanks
ReplyDelete