Who's On?

	Membership:
	Latest: Brady
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5274

	People Online:
	Visitors: 490
	Members: 0
	Total: 490

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

Oracle OLE DB datasource report to be changed to SQL datasource

1 Replies

1 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

Donna

Veteran Member Send Private Message

Posts: 110

11/30/2015 8: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

Veteran Member Send Private Message

Posts: 110

11/30/2015 8: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.