Hello,
We have a large number of crystal reports designed over a specific database. Now, we use the exactly same database structure for each of our customers. The database tables are exactly the same, only the data changes. Therefore we want to use the reports we have created as templates for all customers. The problem is we have to change the location for each different database in order for the reports to see them. This involves changing the DSN for all the reports for each customer. As I say there are quite a large number of reports and customers. I understand there is a way to pass a DSN into crystal report through ASP. Can you please offer your expertise on how I can go about accomplishing this task. What do I need to change within Crystal Designer and what is need in the ASP. Your help is greatly appreciated.
Bryan
We have a large number of crystal reports designed over a specific database. Now, we use the exactly same database structure for each of our customers. The database tables are exactly the same, only the data changes. Therefore we want to use the reports we have created as templates for all customers. The problem is we have to change the location for each different database in order for the reports to see them. This involves changing the DSN for all the reports for each customer. As I say there are quite a large number of reports and customers. I understand there is a way to pass a DSN into crystal report through ASP. Can you please offer your expertise on how I can go about accomplishing this task. What do I need to change within Crystal Designer and what is need in the ASP. Your help is greatly appreciated.
Bryan