something like this

select a.name,b.rate,dbo.[getname(@empid)] as 'empname'
from abc a join bca b on a.id=b.id and join cab c on b.cid=c.cid i have written select query like this not the table name and filed name are real but for just example.

so this query i used in command in crystal report
it gives me error if m used this dbo.[getname(@empid)] as 'empname' if I'm remove it no error.
need help as soon as possible.

as in crystal reports command is only use to give the idea that the firld is which type
string ,number,etc.

it gives error like @empid paramter need to paas but i dont want to paas it
]then after i just change selct query in cimmmand of crystal report like this

select a.name,b.rate,'' as 'empname'
from abc a join bca b on a.id=b.id and join cab c on b.cid=c.cid

it gives no error but data not came?