Skip to main content
Alan Marsh
Participating Frequently
Oct 2, 2025 2:06 PM UTC

How do I change the data source of reports that where already create in a previous version of CW?

I have just upgraded my Dev site to CW 23.11 and when opening a report I get the following error message: Connection test failed!

These data sources couldn't open connection: (Name of Cityworks DB).

    2 replies

    Alan MarshAuthor
    Participating Frequently
    Oct 2, 2025 4:10 PM UTC

    I found the information and have fixed the information.

     

    Fix Data Source Connection for ActiveReports

    Translate
    Agatha Kung
    Participating Frequently
    Oct 2, 2025 4:12 PM UTC

    For moving reports from sites 23.10 or older, we have found that you can make a small change on the report (ex. bold and un-bold a label) to activate the Save button. Once you click save, the database connection in the back-end will automatically update to point to your current site's database.

     

    That being said, moving reports between 23.11 sites does not require the above step, the report will work automatically.

    Translate
    Terms & ConditionsAccessibility statement