update data source in Crystal report

[Former Member]

hi there

i have some CR in PROD, now they are needed to do a test in DEV first, when i refresh the report, it will prompt to ask me login, so i choose to login to DEV system, but i found some reports are not updated to the DEV, some do, i also found those reports failed to update to the DEV because they have sub reports

is there way to update data source for those reports with sub-reports when i login to DEV?

thanks

[former_member11696]

Click on Database, Set Location and choose your Database and server. Highlight the connections and click on the OK or Update button. Do this for each table also and for each subreport.

Thank you

Don