PASSWORD parameter

Specifies passwords for logging on to SQL, ODBC, or password-protected databases used by the report.

Method 1

Password-<servername>.<databasename>

To pass a password to a subreport database, use the following syntax:

Password-<servername>.<databasename>@<subreportname>

Method 2

This method of specifying a password is used in older versions of Crystal Reports (for example, Crystal Reports 7). While it is not recommended, it can still be used.

PASSWORD#=<password>

<password> is a string.

For example:

password0=secret

If the report accesses more than one password-protected database, multiple passwords can be passed by incrementing the index number. For example:

password0=secret&password1=mystery&password2=unknown

PASSWORD# is normally used in conjunction with the USER# parameter. For example:

user0=SmithJ&password0=secret&user1=JohnS&password1=mystery

If the report contains subreports that require user IDs and passwords for logging on to SQL or ODBC data sources, use the following syntax in the URL:

user#@subname=<userid>&password#@subname=<password>

Subname is the name of the subreport.

For example:

http://myServer/myVirtualDirectory/viewrpt.cwr?id=152&apstoken=A1B2&user0@Crosstab=jimmys&password0@Crosstab=jimmyz

Note:    Passwords can be specified in the URL in any order; for example, password1 can appear before password0. However, the index numbers must match the order that the password-protected databases appear in the report.