Liveware Publishing Support Forum

We have a series of SQL reports built in the development environment (server 2). Our production warehouse resides on server 1. The table names and data elements are identical (for most the core reports). I^ve selected the production server through Data Source Connections, but am unable to change my tables. Even the single-table reports does not convert.____As a last resort, I^ve been able to change the data source through rapid runner (allows me to select a different database connection for scheduled reports). ____Is there a way to do this within SQL report writer?____Thanks__

You can select the data source to use for the report by using File Open from the main designer menu. This will allow to select the report and also the data source for the report. But you need to do this when you open the report.____Kathleen__R&R Support