Deploying Reports (Change Data Source/Set)

olivia08

I have created reports that use multiple data sets. All of the data sets use the same Test Data Source. However, I'm deploying the reports to a different server. How can I change the Data Source and its associated Data Sets to point to the production server without re-creating a new poduction data source, data sets, and re-doing the reports?

johnw

There are a couple of ways:

1) Use JNDI
2) In the Data Source, there is a thing called Property Binding. One of the Property Bindings is for JDBC URL. You can set that based on parameter or some other expression (maybe from environment or URL parsing to determine server).