Is it possible to call a function in Sql Server from Crystal XI >

[Former Member]

Is it possible to call a stored function in Sql Server from Crystal XI ?

[Former Member · Accepted solution]

I figured this out.  You can call Sql Server functions within a Crystal SQL Expression as follows.  This SQL Server function is expecting 3 parameters.  1st being a string of paper codes, 2nd being a string of flutes, and the 3rd the square feet.

dbo.get_paper_cost('42K 23M 42K 23M 42K', 'CC', 7.1312) 

or with report field values like this:

dbo.get_paper_cost("EstimatePapers"."Liner1PaperCode"+' '+"EstimatePapers"."Medium1PaperCode"+' '+"EstimatePapers"."Liner2PaperCode"+' '+"EstimatePapers"."Medium2PaperCode"+' '+"EstimatePapers"."Liner3PaperCode",

"PlantEst"."Flute" ,"inv_summary_view"."sqft")