Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Repoint Crystal(Using Lawson OLE-DB)

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
ridjayc
Veteran Member
Posts: 191
Veteran Member
10/6/2008 11:03 AM
    Is there a way to repoint a Lawson OLE-DB link in Crystal from one Lawson server to another without have to redo the fields in the report?  We are using Crystal 10.
    John Henley
    Posts: 3353
    10/6/2008 12:10 PM
      Yes, it's a two-step process. Use Database|Set Datasource Location to point at the new server, then Database|Database Expert|Edit Command to open the Query Builder and change the (PROD=) product line location in the DME string
      Thanks for using the LawsonGuru.com forums!
      John
      dibharga
      New Member
      Posts: 1
      New Member
      12/3/2008 10:03 AM
        When I try to run a DME query in Lawson Query Builder 9, am getting this error message
        "An error message was returned from lawson ios data service, the message is invalid date format. use mm/dd/yyyy or yyyymmdd". I am using Crystal enterprise 9 and lsf9. The same query is working in Laswon 8 environment, please help.