Database Logon

[lynchg]

I have a Crystal Reports 9.2 report that is to be kicked off from a Lotus application. The data sources for the report and it's 4 subreports are Crystal SQL commands that retrieve data from a DB2 database on a mainframe. The report works fine, and when opened manually from within Crystal I am prompted to log on to the database 5 times, once for the main report and once for each subreport. That works fine.

When this is called from Lotus as part of an automated process, is the logon information supplied from within code in the Lotus script, or can the log on information be stored somewhere within Crystal itself?

 

[synapsevampire]

Logins won't be saved in the report as it would expose a security flaw.

From the BO KB:

Notes Client Integration
Sometimes there is a need to invoke reports from the Lotus Notes application.
Crystal Reports provides several ways of doing this. The RDC/Automation
Server is the preferred method because it provides more features compared to
the other two methods and is newer technology. The RDC, Automation Server,
and CRPE API are excellent for integrating reports into your applications when
you have fewer than 10 users to which to deploy.
•RDC (Notes version 5.0.5 and greater)
Samples and text files demonstrating how to use the RDC can be found at:

http://support.crystaldecisions.com/samples/lotus_lst.asp

-k