Datasource not populating on LBI

Is the datasource set up on the LBI box or just your local machine?

All the datsources are setup on the server.

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.

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

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.

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!