USER parameter

Specifies user IDs for logging on to SQL or ODBC databases used by the report.

Method 1

User-<servername>.<databasename>

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

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

Method 2

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

USER#=<userid>

<userid> is a string.

For example:

user0=SmithJ

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

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

USER# is normally used in conjunction with the PASSWORD# 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:

user0@Crosstab=jimmys&password0@Crosstab=jimmyz

Note:    

• If an existing report is inserted as the subreport, then the subreport name includes the file extension (for example, user0@subreportname.rpt). However, if the subreport was created inside the main report (with Insert Subreport and using the Report Expert to create the new report) then the name of the subreport usually does not contain a file extension (for example, user0@subreportname) unless one is added in the "Report Name" text box of the Insert Subreport dialog box.
• User IDs can be specified in the URL in any order; for example, user1 can appear before user0. However, index numbers must match the order that the password-protected databases appear in the report. Additionally, subreport user IDs must appear in the same order that the subreports appear in the report.
• Reports are not shared if there are logon requirements.