Skip to Content
avatar image
Former Member

Set Datasource Location does not update properly on Crystal Subreports

Greetings -

I have a customer who is having great difficulty switching between Development, Test, and Produstion database environments in Crystal (version FYI, Connecting via ODBC to SQL Server databases.

When using the Set Datasource Location option to switch databases (e.g. from Test to Development), the updates do not always propogate to the subreports. Some subreports will continue to point to the original database (e.g. Test) instead of the new database (e.g. Development).

It's very frustrating for us!  We use the Set Datasource Location for Crystal Reports design and testing.

Anyone see this before?  Any ideas on how to fix or workaround it?

Thank you,

Eric Kenney

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 22, 2012 at 04:29 AM

    Hi Eric,

    When you do a 'set datasource location', make sure you select each table from the original datasource and the new datasource and then hit the update button.

    Trying to change the datasource by clicking on the connection names doesn't really work well.

    In case of subreports too, make sure you update each table as opposed to just updating the connection.

    Hope this helps!


    Add comment
    10|10000 characters needed characters exceeded