Customization and Integration

[lvance1611]

We just upgraded from MAS 500 7.05 to 7.3.  I have taken the Customer Statement and made a few modifications to it and ported it to our Business Objects Enterprise server.  There are a few formula fields using the Squeez function from the u2lsota.dll library, which does not exist on our BOE server so we get an error regarding that missing file when we run the report.  I read on one thread that those custom Crystal functions were ported to stored procedures in MAS 500 7.x, but this does not seem to be the case.

I've looked through the SDK and searched the forum, but I can't find a solution to this.  Is there a SQL-based user defined function that can replace Squeez?  Can we simply copy u2lsota.dll to the C:\WINNT\System32 on the BOE server?  Is there another option that I'm not aware of?

Thanks!

Lee

[LouDavis · Accepted solution]

All the functions found in U2lSOTA.DLL have been replaced by SQL Functions.  You will need to review your custom reports and determine what formulas are using  old U2LSOTA functions and look for the corresponding SQL function.  From that point, you need to include these functions in the stored procedures that populate the work tables your reports.  A good place  for an example of  how to use these new SQL functions are the stored procedures that create AR Invoices in MAS 500.  

At E2b we have a utility that we built for MAS 500 6.3 upgrades to 7.3 that reviews Crystal Reports for these formula's and provides a list of what formula's are using them to aid in modifying the report which speeds up the process a bit.  I beleive this utility should also work on MAS 500 7.05 reports as well.  I don't know how many reports you have to modify, but if it is a few and you're interested in this utility, contact Tiffany Kirkland at tkirkland@e2btek.com.

[lvance1611]

Awesome!  I found the stored procs that replaced them.  Thanks!

[ghombali]

Hi Ivance6111,

I ran into the same u2lsota.dll problem. It is giving me error - 'UFL u2lsota' that implements this function is missing.'

Would you please tell what functions did the dll has and where did you find the stored procs to replace them ?

I appreciate your help.

Thanks,

Gaurav Hombali

[naresh]

Hi Ivance6111 or anyone,

Can you share the list of stored procs and the functions they are replacing?

Thanks

[LouDavis]

As I explained to Ivance, all the U2lsota.dll functions Crystal Reports use to use have been changed to SQL Server Scalar functions.  You will need to review your reports for what U2lsota.dll functions they use and find the corresponding SQL function (i.e. fnSqueeze is now a SQL server function called fnSqueeze). All these functions are done on the database side now and not within Crystal Reports.

Once you have identified the functions, you will need to modify the underlying stored procedure that populates your work tables to use these new SQL functions.  You will also have to modify your Crystal report and remove all the calls to the old U2lsota.dll functions to avoid any errors and possibly re-saving your report in the current Crystal Reports version used by the version of MAS 500 you are using.  

[JohnHanrahan]

Or maybe they could contact E2B Techn and order the product that will help them (and save them tons of time I imagine).

J

[LouDavis]

Thanks for the plug.