Report Viewer parameters

You can append several Report Viewer parameters to a Crystal Web Request (CWR). These parameters allow you to control the way reports are generated and displayed. For example, instead of the user being prompted for information, you can automatically assign values for database logon or parameter fields, or provide optional selection formula criteria.

Report Viewer parameters can be passed in any order and in any combination. All parameters are optional—except for the ones that are needed to launch the Report Viewer. If you do not specify any optional parameters, the DHTML frame viewer displays the report and prompts the user for any required information.

Keep in mind that there are a number of factors that determine whether or not the user will be prompted for information. The user will be prompted under the following circumstances:

• the report requires the user to enter parameter values or logon information
• the report does not contain saved data, so it needs to access a database, or the user refreshes the report
• the values for the prompts have not already been set or the prompts have been enabled through the SDK or Crystal Management Console.

The following is a list of available Report Viewer parameters:

Parameter	Description
ID parameter	Specifies the ID of the current report.
APSTOKEN parameter	Specifies the logon token for the current APS session.
APSUSER, APSPASSWORD, APSAUTHTYPE parameters	Specifies the APS user name, password, and authentication type.
INIT parameter	Specifies the Report Viewer.
CONNECT parameter	Re-establishes a connection to the Page Server.
PASSWORD parameter	Specifies the passwords for logging on to SQL, ODBC, or password-protected databases used by the report.
USER parameter	Specifies the user IDs for logging on to SQL or ODBC databases used by the report.
PROMPTEX parameter	Specifies values for parameter fields in a report.
PROMPT# parameter	Specifies values for parameter fields in a report. This method of specifying parameter values is used in older versions of Crystal Reports (for example, Crystal Reports 7).
PromptOnRefresh parameter	Specifies whether report should prompt for parameter field values when refreshed.
SF (Selection Formula) parameter	Specifies a selection formula.
GF (Group Selection Formula) parameter	Specifies a group selection formula.
CMD# and EXPORT_FMT parameters	Specifies that the report should be exported to the indicated format.