Skip to Content
0

Unable to run crystal report with two database connections

Aug 06, 2017 at 09:44 PM

46

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Abhilash Kumar
Aug 07, 2017 at 09:26 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 10, 2017 at 01:33 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded