PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 11/30/2015 3:39 PM by  Donna
Oracle OLE DB datasource report to be changed to SQL datasource
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Donna
Private
Private
Veteran Member
(256 points)
Veteran Member
Posts:106


Send Message:

--
11/30/2015 3:02 PM
    We were able to change the LBI Crystal reports that use the Lawson tables from the version 9 Oracle database source ODBC connection to the new version 10 SQL database source connection but we still have some SQL reports, OLE DB reports and some Lawson Standard reports.

    Has anyone else dealt with these reporting issues?
    Donna
    Private
    Private
    Veteran Member
    (256 points)
    Veteran Member
    Posts:106


    Send Message:

    --
    11/30/2015 3:39 PM
    OK.
    We were able to convert one OLE command by changing the version 9 report from an Oracle SQL query to SQL in the version 9 report and then changing the data source from the version 9 database connection to the version 10 data source connection. It was cumbersome but still required less time than recreating the report. If anyone has a more elegant solution please advise us.
    You are not authorized to post a reply.