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

DME substitute- RW?

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Nabil
Veteran Member
Posts: 61
Veteran Member
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: 3353
    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
      Thanks for using the LawsonGuru.com forums!
      John
      mikeP
      Veteran Member
      Posts: 151
      Veteran Member
      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.