Skip to Content
Former Member
Sep 22, 2017 at 05:00 PM

Crystal Reports formating changes get whacked when datasource is updated


I have numerous financial reports built against a production instance financial database (SQL 2012 R2). We've recently had occasion to adjust some figures in a test instance of this same database and I want to run those Crystal Report against the test database. I go through the Set Datasource Location dialogue successfully, but when I refresh my report against the test data, ALL of my numeric fields now display with currency symbols! Where NONE of them show $$ when I run the original reports against the prod data. The SQL servers are identical (test is cloned from prod) and the test database is actually restored from a Prod backup, so the databases too are identical, as are the ODBC data sources (SQL Native Client) I'm using locally with Crystal. If I reset the Datasource back to Prod after this occurs, the Currency Symbol display persists. How do I solve this?