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

Datasource not populating on LBI

 6 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Ruma Malhotra
Veteran Member
Posts: 412
Veteran Member
8/2/2009 5:25 PM
    I am running reports that go against the lbp schema and belong to the same database as the other lawson tables using native oracle odbc.

    These reports are created using sql as a command. When I publish the report on LBI I am not able to see a datasource drop down list that I can pick from.

    Does anybody have any ideas as to why this is happenning and what I can go alternatively.

    tia.
    mark.cook
    Veteran Member
    Posts: 444
    Veteran Member
    8/3/2009 11:29 AM
      Is the datasource set up on the LBI box or just your local machine?
      Ruma Malhotra
      Veteran Member
      Posts: 412
      Veteran Member
      8/3/2009 12:24 PM
        All the datsources are setup on the server.
        Char
        Veteran Member
        Posts: 62
        Veteran Member
        8/3/2009 12:47 PM
          I use native Oracle in the report instead of ODBC - it runs tens of times faster and requires no DSN on the server at all. You simply publish it and save the UID and PWD. One of my clients had a report running ODBC the other day and called me complaining of the speed - I kicked the report off and sat for more than two minutes as it slowly returned records. Meanwhile, I opened another copy of Crystal, set the report from ODBC to Native and ran it. It promptly returned the records in seconds - the original ODBC repot didn't finish for more than five minutes after the Native was finished and it had a two minute head start. It's just not well documented how much more efficiently the Native connection works but I find it repeatedly even when not using Lawson that it's THE way to go for Oracle. If you've not done it before, when you go to database, set data source location, under new connection - choose Oracle Server.
          Matthew Nye
          Veteran Member
          Posts: 514
          Veteran Member
          8/3/2009 12:57 PM
            if the drop down box for Over ride Data source is not populating that means there is a miss match between the driver that you set up in youre Crystal Report and the Data Sources you set up in Reporting Services. Make sure youre using the same ones. Post screen shots of the properties of one of youre DB connections in Crystal and of the data source you think should match it in Reporting Services.

            hth
            matt
            If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
            Ruma Malhotra
            Veteran Member
            Posts: 412
            Veteran Member
            8/3/2009 1:33 PM

              Hi Matt. these are the reports that Amy has written. As far as crystal she used crystal XI R2 and we are using crystal 2008 and I checked on business objects website that they are forwrad compatible.

              As far as oracle goes we both are using native oracle she has used oracle 9 and  we are using oracle 10g and according to our dba again it is forward compatible.

              I am actually changing a few properties on the report. it may fix my issue. I still do not believe it could be an issue with LBI. But I am checking.

              Ruma Malhotra
              Veteran Member
              Posts: 412
              Veteran Member
              8/3/2009 7:04 PM
                Issue resolved. I sent Amy a detail explanation of what all I changed to fix this issue. Key points if someone runs into this issue is I added the database.schemaname infornt of the table name to always pointo to the proper datasource location.

                Thanks for all the replies!