Hi,
From Crystal Reports 2008, I am trying to retrieve data from a table-valued function: fn_XXX(@a,@b,@c) which exists in SQL Server 2005 database. But to retrieve data from this table-valued function I have to pass the parameters @a, @b & @c from Crystal to SQL Server.
In SQL Command (Under Database Expert / Connections) I created parameters A, B, C and entered the following command
Declare @a, @b, @c
Set @a = A
Set @b = B
Set @c = C
Select * from fn_XXX(@a,@b,@c)
But no success. Would you please let me know what I am doing wrong?
Thanks,
Al