How to keep from having to log into database once for EACH subreport?

[benamorton]

I have a report in Crystal 8.5 that works great, but has 4 or 5 subreports. When the end users run it, they are complaining that they must enter their login information too many times (once for each subreport). Is there any way to only make them log in once, since its the same database for all reports?

 

[Wallie12]

I would add the log in information into a stored procedure or sql

Wallie12

 

[IdoMillet]

Is this in Crystal or within your own viewer application?

In my viewer application I take care of this by looping through all subreports and atempting to apply the login info from the main report to the subreports. Only if this fails, do I prompt the user for subreport login info.

hth,
- Ido


CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com