1255823 - How to call SQL Server function which returns table in Crystal Report?

How to call SQL Server function which returns table in Crystal Report?

• Crystal Reports XI Release 2
• Operating System:- Windows server 2003.
• Database:- SQL SERVER (Any)

Crystal Report can not call a function which is created in the database.

• Create a procedure in SQL Server that calls this function with a parameter which is being passed to function.
• Pass the procedure parameter to the function.
• Create a report in Crystal with a subreport.
• Create one formula in main report which yields the data of the data type same as the procedure parameter.
• For ex if procedure parameter is varchar(string) datatype then the formula should return a string value.
• Use the procedure in the subreport(this creates the parameters of procedures in Crystal Report by default)
  In the main report link this subreport using formula and the subreport's parameter.

SQL SERVER user guide.