To understand what I am asking, suppose I have a table named Orders that has a Create_date field and the database also has a dbo.ssWEEKBEG user-defined function that I want to apply to it. I am creating a Crystal Reports Viewer object that will display the results of Create_date and dbo.ssWEEKBEG(Create_date).

Am I required to create a view that includes the results of  dbo.ssWEEKBEG(Create_date) as one of the views?

Is it possible to call the dbo.ssWEEKBEG function from within the report?

I have verified that I am unable to add dbo.ssWEEKBEG(Create_date) to the data selected for the report.

Also, once I set up the data to use in the report, can I edit the SQL statement that Crystal uses?