DME substitute- RW? - LawsonGuru.com - LawsonGuru.com Forums -

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

Nabil

Veteran Member

Posts: 61

New Poster

4/8/2011 6:18 PM

Hello Gurus,

So we know very well that in order to create custom crystal report that use user level security, OleDB is an option. We also know that OleDb is really really sllllowwwww

So, are there any other alternatives to this painful reality? Can there be OleDb reports written with a language other then DME? How about SQLOLEDB?

Thanks much,

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

4/8/2011 6:37 PM

squardius, you can definitely use native providers. See this article for comparison:
https://www.lawsonguru.co...OLE-DB-Provider.aspx

mikeP

Veteran Member

Posts: 151

4/8/2011 6:44 PM

For us, Lawson proper is hosted on an iSeries. We write most of our CRs using the iSeries ODBC driver, which is very fast. We also use the native MS SQL server driver to write CRs to report from LBP, which is on SQL server. That's not as fast, which is more a function of the wimpy SQL server box.

We implement security via LBI custom groups, but it's also possible to grant report access in LBI via security group defined in the Lawson Resource Mgmt. Administrator.