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

Can't see all tables

 8 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Fernando Labrada
Basic Member
Posts: 14
Basic Member
3/20/2007 7:52 PM
    Crystal XI using Oracle ODBC driver. When I create a new ODBC connection to a Lawson environment and I select a data area within that environment, only the tables that start from AC to MM (including all the L_) show up. Anything past MM does not. If I use the same ODBC connection and use Access instead of Crystal, I can see all the tables beyond those that start with MM. Has anyone else had this issue?
    John Henley
    Posts: 3353
    3/20/2007 8:36 PM
      Are you using Oracle's ODBC driver or Microsoft's?
      Which version ?
      Do you get an error message?

      I'm assuming that in Crystal you're using ODBC (RDO).
      There are a couple of other options:
      - use the Oracle Server (native) connection rather than ODBC.
      - Use OLEDB -> Microsoft OLEDB provider for ODBC
      - Use OLEDB -> Oracle OLEDB Provider
      Thanks for using the LawsonGuru.com forums!
      John
      Phil Simon
      Veteran Member
      Posts: 135
      Veteran Member
      7/18/2007 5:05 PM
        It's strange. SQL Server 2005, CRXI, OLEDB - I can't see all of the fields on some of the tables, particularly PRSAGDTL.
        Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
        Fernando Labrada
        Basic Member
        Posts: 14
        Basic Member
        7/18/2007 5:39 PM
          OLEDB enforces Lawson security. Is it possible field level security is being used?
          Phil Simon
          Veteran Member
          Posts: 135
          Veteran Member
          7/18/2007 5:49 PM
            Possible, but I doubt it. I have carte blanch here.
            Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
            John Henley
            Posts: 3353
            7/18/2007 6:49 PM
              Do you mean you can't see the fields when designing the report, or that you can't see the data?
              Thanks for using the LawsonGuru.com forums!
              John
              Phil Simon
              Veteran Member
              Posts: 135
              Veteran Member
              7/18/2007 6:51 PM
                Can't see all of the fields via OLEDB...

                It might be a LSF9 security thing. We're looking into it.
                Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
                John Henley
                Posts: 3353
                7/18/2007 7:08 PM
                  Try using the Excel Add Ins Query Buiider and see if you have the same issue. If you do, it's LSF9. If not, it's Crystal and/or OLEDB.
                  Thanks for using the LawsonGuru.com forums!
                  John
                  Phil Simon
                  Veteran Member
                  Posts: 135
                  Veteran Member
                  7/19/2007 3:37 PM
                    It appears as if the new OLEDB connector (9.0.3) has resolved this. Thanks all.
                    Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com