Skip to Content
avatar image
Former Member

Unable to run crystal report with two database connections

I am trying to run the crystal report with two database connections. I was able to establish the connection with two different database but the crystal reports was not displaying the report. Its keep on loading.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 07, 2017 at 09:26 AM

    Hi Divya,

    When you report off of Multiple databases, Crystal Reports needs to process Joins 'locally'.

    You should try to federate the two databases in a single database if you want better performance.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 10, 2017 at 01:33 AM

    Hello Abhilash,

    Thank you for your reply Actually the reports are created long back and working fine in VB6.0 project. We are migrated the tool from vb6.0 to asp.net 4.5. , I am not going to pass data via stored procedures...we just calling and binding reports to crystalreport viewer.

    We can not edit the existing report because we have around 200 reports having same issue. But all these are working fine in VB6.0 crystalreports viewer.

    This issue is shore stopper , could you please help us.

    Thanks in advance.

    Divya

    Add comment
    10|10000 characters needed characters exceeded