I have a new client who's current environment is 8.x and planning to upgrade to LSF 9 in the near future. They have quite a few Crystal Reports that utilize RW100 as a data source. I'm being told by Lawson Support that for any Crystal Reports that use RW100 as a data source must be completely rewritten from scratch for LSF 9. Does anybody know of a less painful way? I don't have access to their LSF 9 environment yet so I haven't been able to try and find a better way myself.

I would think it's just a matter of repointing it from the existing call (xtra) to the new/LSF 9 call (report), ie by using "Set Datasource Location" or by editing the Command object via the Database Expert. I'm itching to try this out...there has to be a better way than starting from scratch.

Update - This particular support rep (who is ALWAYS diligent about trying to help solve any problems rather than just trying to make you go away) tested modifying the Database Expert call and said it threw errors but did appear to work. The caveat, of course, is that this is unsupported. If this method were used and there were issues, you will be asked to recreate the report from scratch.

I haven't been able to verify these results but plan to asap...