Is there a way for calling .Net code from Crystal Report? 1

[maulae]

In my database some of the fields store data in array sting values with a field separator comma i.e for name of a item is stored in field Itemname as ‘Milk,sugar,Tea’ and their respective prices are stored in an other field ItemPrice as ‘3.00, 1.50, 2.50’.
Now I have written the code in crystal with array variable to display each Item name and price on independent line in the report, these reports are published on web through .Net, I am dealing with crystal report only and there is an other .NET developer who also writes code to evaluate these string array field, now my question is - Is there a way for calling .Net code from Crystal Report?

Because in the future if field separator is changed from comma to semicolon then I can call that code in my report.
Thanks

 

[synapsevampire]

Post your software version.

It's conceivable that you might build a UFL in Crystal which useas external code, but it's probably a bad idea.

It's more likely that you might reuse or alter a Crystal formula using .NET, or better still, use either a View or Stored Procedure to correct the novice approach to storing data.

-k

 

[maulae]

Iam using Crystal ver 10, would you please expalin little more about UFL.
Thanks

 

[synapsevampire]

I don't think that .net can be used to create it, you'll need VB or Delphi:

http://support.businessobjects.com/communityCS/TechnicalPapers/scr_user_defined_functions.pdf.asp

-k