Using CR7 with SQL Serv 7

[JeffCarlin]

We created a VB6 app into a SQL Server database and designed the CR reports. They all worked fine.

Then, when I ported the app to my client's machine, the reports would not work until I went in and changed each one to reflect the name of his SQL Server. With my Server name in, the report would not work. This sort of makes sense, but is there an easy way to do this? If I sell this app to 20 customers, I'll have to re-edit each report (there are 30 of them) every time.

Thanks,
Jeff

 

[JeffCarlin]

Note from above post: I should have mentioned that the report fails firing the "connect" property.

Jeff