Repeated login

[andrewjor]

I am a relatively new user of Crystal Reports. I have to maintain a report that is used by one of my company's clients. The report was created in CR7. The report accesses 12 different database tables. The report contains 7 sub-reports. My question is simple: Why, when I open the report (either in CR7 or CR8.5) do I have to login to the database 26 times?

I ask this because I think it is causing the problem
"cannot open sql server" when the report is called via Crystal Reports Print Engine. I access an Oracle 8 database via Oracle ODBC driver version 8.01.07.00. Other similar reports work fine. Any help with this would be very much appreciated.

 

[richdb]

go to

http://www.tek-tips.com/gfaqs.cfm/lev2/4/lev3/100/spid/149/sfid/539

 

[andrewjor]

Thanks very much for this, richdb. Unfortunatley, I am not a programmer, so the faq you directed me to doesn't mean much to me. Apologies if the answer to my question is contained in that faq. I maintain reports using only the basic CR Designer Gui.

Is there a simple answer to why I have to login 26 times for this particular report?

Would this cause the problem my clients are experiencing when they try to call the report from a proprietary application using the Crystal Reports "Print Engine"?

As I said previously, all the other (very similar) reports work fine, both in the CR Gui and at my client's site. Many thanks for your patience and for any further assistance.

 

[jdemmi]

I have this problem as well. (I am using Oracle and CR 7 and 8.5) When I open reports which have subreports in the designer I am OK. But once I attempt to execute the report I am promoted to login once for the report and once for each subreport. I have not found a way to overcome this. And I do not think there is a real solution.

 

[SchuhTL]

I have had a similar problem in the past and I have solved it by changing my Oracle ODBC driver to the Microsoft for Oracle ODBC driver. You will also need to make the following change in your registry. regedit>hkey_localMachine>Software>ODBC>ODBC.ini>"your DSN Name">then double click on key named "Password" and enter your password. Reboot and you should be in business. There may be a way to add a key for the Oracle ODBC driver to store your password but I have never tried it. I hope this works for you!

 

[richdb]

Make sure that your subreports used the same ODBC DSN name as your other subreports. If you have the same record filters for every sub-report, make sure that you name your parameters the same way also. Hope this helps.