Override datasource doesn't appear to work

Welcome to LawsonTalk. We hope you enjoy your visit.

You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are some features you can't use. If you join our community, you'll be able to access member-only sections, and use many member-only features such as customizing your profile, sending personal messages, and voting in polls. Registration is simple, fast, and completely free. After registration, please check your e-mail within 24 hours for an message from us, read it, and reply to it.

Join our community!

If you're already a member please log in to your account to access all of our features:

Override datasource doesn't appear to work
Topic Started: Jun 16 2009, 03:20 PM (116 Views)
mike	Jun 16 2009, 03:20 PM Post #1
Member Posts: 14 Group: Members Member #321 Joined: January 18, 2006	Hi all, I have a number of CR2008 reports published to LBI 9.0.3, and I am testing the possibility of using the Override Datasource feature to change the report to run against different data areas in DB2. These are ODBC reports that use the client access ODBC driver. I created datasources in LBI as generic ODBC connections, just playing cause I really don't know what it wants for the database and schema settings, as we normally just specify a server and data area in a connection string or DSN, e.g. DBQ=dataarea;system=server.domain.com I know the data sources I created won't work, in one case I used a bogus name and password. However, when I select one of these bogus data sources, in the override datasources list in the report's data settings, the report still runs properly, pulling data from the datasource that was saved in the report. (Data is not saved with the report, I must enter a parameter when the report is refreshed, and it pulls appropriate data.) I would think that when I override the saved data source with a bogus source, I should at least get prompted for user id and password. So it appears that LBI is not using the override datasource. Can anyone explain this, and point me in the right direction to create working data sources? Thanks,



arvin	Jun 18 2009, 03:41 PM Post #2
arvinojales Posts: 37 Group: Members Member #704 Joined: August 22, 2006	Mike, There is a 'When viewing report' field in the override datasource definition screen in LBI, there is an option there to prompt for user id and password, or you can enter a generic user id/password to login to the database. Also, for the Override Datasource to work, you need to define the Datasource inside your LBI server, this can be done by logging in to the server and go to Control Panel -> Administrative Tools ->. Datasources, Add a datasource there and the Datasource Name should match the DSN field in the Override Datasource screen in LBI. Arvin Ojales Edited by arvin, Jun 18 2009, 03:42 PM.



mike	Jun 19 2009, 12:22 PM Post #3
Member Posts: 14 Group: Members Member #321 Joined: January 18, 2006	Arvin, thanks for getting me pointed in the right direction. I finally determined that the DSN names I was using when configuring the datasources were incorrect. I hadn't noticed this before, since I've always used a connection string as a datasource in CR, and I hadn't actually tested those names as the original report data source just to see if they worked. I did find that the name I gave the datasource didn't matter, as long as I used the correct DSN name in the datasource's DSN field.


« Previous Topic · Reporting (NEW!!) · Next Topic »