• Search Forums
    Advanced Search
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

RW100/Crystal Reports - Upgrading to LSF 9

 7 Replies
 0 Subscribed to this topic
 23 Subscribed to this forum
Sort:
Author
Messages
Chris Martin
Veteran Member
Posts: 277
Veteran Member
New Poster
New Poster
Congrats on posting!
1/31/2008 5:00 PM
I have a new client who's current environment is 8.x and are 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.
k-rock
Veteran Member
Posts: 142
Veteran Member
1/31/2008 5:05 PM
I don't know of a way to convert the reports. I would try to explain how LBI can point directly to the database and get the client to rewrite the reports without using RW100 as the source. What data are they pulling from the RW100 that is not available directly from tables? If it is just totals, then those can easily be rewritten.
Chris Martin
Veteran Member
Posts: 277
Veteran Member
New Poster
New Poster
Congrats on posting!
1/31/2008 5:12 PM
I don't disagree that querying the database directly has many benefits to it, but what I'm trying to accomplish is to limit the effort (and $) it will take to convert their existing Financial reports for LSF 9. Rewriting these against the tables isn't going to help in that regard.
Chris Martin
Veteran Member
Posts: 277
Veteran Member
New Poster
New Poster
Congrats on posting!
1/31/2008 5:22 PM
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.
John Henley
Posts: 3364
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
1/31/2008 7:26 PM
Are you referring to an LBI 'Back Office' report, or a Crystal report which reads RW100 XML output?
Thanks for using the LawsonGuru.com forums!
John
Chris Martin
Veteran Member
Posts: 277
Veteran Member
New Poster
New Poster
Congrats on posting!
1/31/2008 7:36 PM
Crystal report which reads RW100 XML output
Chris Martin
Veteran Member
Posts: 277
Veteran Member
New Poster
New Poster
Congrats on posting!
1/31/2008 8:48 PM
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...
Chris Martin
Veteran Member
Posts: 277
Veteran Member
New Poster
New Poster
Congrats on posting!
4/18/2008 12:08 PM

Good news.   Lawson agreed to document this as a workaround (KB 559132).