Autologon to SQL data

[djieon]

Hi All.
Im using CR11 and connect to data using OLE DB (ADO). However when I open the report and click F5 to refresh the data it comes up with the OLE DB (ADO) connection information in which it wants me to put it username password server and database. Is there anyway to stop that happening and embed that data into the report so that when I press F5 it just runs?

Thanks.

David.

 

[chelseatech]

The user for a data connection is saved inside the rpt file, but the password information isn't.

You could either use a report viewer like our cView product that saves the passwords in the application and uses that when the report is viewed, or have a user with a blank password.



Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm