cancel
Showing results for 
Search instead for 
Did you mean: 

Using Sql Functions in Crystal Reports

Former Member
0 Kudos

Can SQL table-valued functions be used in Crystal Reports? The only options I see in the Database Expert are Tables, Views, and Stored Procedures.

Accepted Solutions (0)

Answers (2)

Answers (2)

abhilash_kumar
Active Contributor
0 Kudos

Hi Dan,

Are you referring to user-defined SQL functions? If yes, then these are not accessible in Crystal Reports.

You would need to create a stored procedure which calls the function and does the processing and use this procedure in CR.

- Abhilash

Former Member
0 Kudos

Thank you, that's exactly what I'll do. Appreciate it.

0 Kudos

Hi Dan,

No, you may be able to get to them using a SQLExpression though.

Don

Former Member
0 Kudos

Ok, Thank you.