Switch grid connection from test to prod in Reporting web studio

Content

Hi All,

Im creating a financial report in the planning test instance using its reporting web studio. However in the test instance no data is available and no values are coming for the report. but in production instance we have required data and i need to switch the grid connection from test to prod. (should shift only the connection,report is physically resides in the test server as i dont have access to prod and create a report in prod)

I dont see any way of doing this. Is it possible to do this?

Regards,

Ayeshan.