Lossing database connection after refreshing 1

[CJSilver]

I have Crystal Reports version 8.5.

I have one report that accesses 2 different SQL servers. When I open the report and refresh it, I get a log in prompt for both SQL servers. I log in to both servers and the report works fine. But if I refresh the report(you don't get the log in prompts again) the information from one SQL server still comes in fine. But the information from the other server is no longer there. These are number fields and I get all zeros.
The only way for me to get the report to work again is to close Crystal completely down and open it again so that I get the SQL log in prompts again, and then it works once then will not work after refreshing.

There are 2 things about this that I don't understand. The first is if I browse the data fields that are showing all zeros I see the data is there, I don't get a message that it can't connect. I also have a different report that accesses just one SQL server it uses the exact same tables and fields that I am getting zeros on in the first report. But in this second report I don't have this problem, I can refresh all day long and the report works fine.

Does anyone have any idea what could cause this? Are there any issues that anyone is aware of when accessing two different SQL servers in one report?


C. Johnson

http://www.SilveradoCable.com

 

[synapsevampire]

I'd apply the service pack:

http://support.businessobjects.com/fix/hot/si75/default.asp

I assume that you have these 2 different servers tables joined? Are there subreports?

Consider building a Stored Procedure and link the servers, this sort of thing should be done on the database anyway, not in the client:

http://lists.isb.sdnpk.org/pipermail/comp-list/2002-September/001279.html

-k

 

[CJSilver]

Hello Synapsevampire,

Thank you for responding! Yes, the tables are joined and there is a subreport. I will try what you suggested. I am not all that familiar with SQL yet, I didn't know I could link the servers.

I appreciate your help!

By the way, I love your name. I wish I had thought of it.

C. Johnson

http://www.SilveradoCable.com