I have some reports which I set up on our test database before setting up on live.

 

The test database name and schema are different to the live database name and schema.

 

Each time I set the report up on live I currently have to go and update all the tables datasource locations which is very time consuming.

 

I am sure there is the ability to be able to get the report to automatically pick up whatever database I am logged into (via the software).  Maybe under Options "table name like" and "owner name like".  I have played around with this but cannot get it to work.

 

Can anyone help? 

Thanks