Skip to Content
avatar image
Former Member

Crystal Reports 2016 - Long time to update data source

We receive Crystal Reports from a vendor that we update for use in our system. When we get the reports we need to update the data source as it initially is pointing to one of their databases. When I try tot update the data source to our database it can take over 20 minutes to finish. Is it because it is looking for the original data soure (which is not available)? What can i do speed this up? I does eventually update but it impacts some other workflows.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 23, 2017 at 04:29 PM

    If the destination is Oracle 12 c database then it is known problem. What is your database, connection?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I am experiencing a similar issue. My destination is Oracle 12 c database. Is this a known problem with Crystal Reports 2016 and Oracle 12c database?

      Thanks.
      Marc

  • Nov 24, 2017 at 03:18 PM

    Have you tried the following:

    1. Open the report in CR Designer

    2. Open Set datasource Location dialog

    3. Create a new connection for you datasource

    4. Do Table to Table Update instead of Connection to Connection.

    Does it take long as well?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 06, 2017 at 11:18 AM

    Individually selecting the tables does go faster. Is this an CR2016 issue? We haven't had this problem with CR2013.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 25 at 03:32 PM

    I am experiencing a similar issue. My destination is Oracle 12 c database. Is this a known problem with Crystal Reports 2016 and Oracle 12c database?

    Thanks.
    Marc

    Add comment
    10|10000 characters needed characters exceeded

    • With Oracle 12 C the time to query system tables like

      SYS.ALL_SYNONYMS increased comparing to Oracle 11 and it caused performance issues for Set Datasource process in Crystal Reports. When we do Datasource to datasource changes it looks like it sent queries too many times. Table to table works better.