Using User Defined Functions With VB.NET & Crystal Reports
Posted on 2003-03-06
First off, this is my first dealing with Crystal Reports, so I'm sorry if I'm not too clear on some of my description.
I have a user defined function in SQL Server 2000 that I need to access in a crystal report.
The function has three parameters and returns a table.
The function shows up as a stored procedure when I make a new report, but gives an error. I can set it up as a command, and type out the SQL myself - then I supply static parameters, and the report looks great.
My question is how do I make this dynamic? I have values in VB.NET that I want to use as the arguments to my user-defined function, but can't find a good way to add this to my command in Crystal Reports.
(sorry for the point value - I've seen responses from here a lot so I decided to try; I still need to get more points to award though.)