I am hoping someone can help me with this. I have seen many posts referring to this but nothing referring to Cold Fusion.
I have a set of reports that are being used by 4-5 different DB's. Each one with its own DSN, username, password. But instead of having the reports copied and changed in each directory (which would take up huge space) I was wondering if there is a way to set the DSN on the fly, so I can use one set of reports. I am using Crystal reports 8 and Cold Fusion to access the reports on the web.
Any help at all is greatly appreciated.
I have a set of reports that are being used by 4-5 different DB's. Each one with its own DSN, username, password. But instead of having the reports copied and changed in each directory (which would take up huge space) I was wondering if there is a way to set the DSN on the fly, so I can use one set of reports. I am using Crystal reports 8 and Cold Fusion to access the reports on the web.
Any help at all is greatly appreciated.