Hi,
We are running into an interesting dilemma in that we run multiple Lawson environments (20) and multiple LBI servers to service these environments. The dilemma we have run into is that we have the same report, but that it needs to be published using different DSN's many times. Everytime the enviroment changes like right now we are going from LRS to LBI, and later from v8 to v9 of Lawson, we have to change all the DSN's etc.
What I am curious of is if there is a generic driver or something that can be used in CR and then when the report is published to LBI we can use one of the defined datasources there? Currently the DSN's are defined on the Crystal Reports server using the I-series driver (AS/400). We are using ODBC due to the speed issues of using OLEDB. The Crystal and LBI servers are different boxes.
Any suggestions around this would be helpeful.
Thanks.
Thanks for your input so far.
Yes the datasource name is the same across the LBI servers, the problem lies in changing all of the reports to the proper DSN. For instance we have single master report. The problem is that we have to change the DSN and save the report, publish it..20 times. I am trying to find a way to put this into RS so you just choose a dropdown box or something and simplify this. Then a single instance of the report could be published and the end-user could choose their database.