• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Crystal Reports and OLEDB

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Layne
Basic Member Send Private Message
Posts: 24
Basic Member
8/22/2014 4:50 PM
We have had numerous occasions when Crystal Reports inside LRS have all of a sudden started prompting for an OLEDB username and password. We can input the porper username and password into the report and it will work just fine for that one time, but will keeep asking for the username and password each and every time that it's run. We even had some report instances that were run overnight in our history today that would prompt for the OLEDB username and pasword. Does anyone know how LRS uses the OLEDB username and password once the report is loaded into LRS. Does LRS cache this information somewhere? Does anyone have any idea why this may be happening?
Randy
Veteran Member Send Private Message
Posts: 50
Veteran Member
8/22/2014 6:20 PM
I've seen this happen when a report is refreshed/reloaded and you forget to re-enter the data settings.
mikeP
Veteran Member Send Private Message
Posts: 151
Veteran Member
8/22/2014 7:09 PM
I've seen the same. We use ODBC rather than OLEDB, but every time I republish a report, I must specify the override data source.