The Report URL Parameter settings allows you to enable or disable the usage of parameters in the report URL. Due to security reasons, some of the properties are disabled by default.
Allows or disallows the setting of the data source configuration as a report url parameter.
Set the name of the data source configuration that will be used to create connection to the database. It overwrite the value saved in the rpt file.
A Data Source Configuration contains all information needed to create a database connection.
You need to set a value for this parameter only if you like to use another data source configuration as saved in the *.rpt file.
For more information see Report URL Parameters.
Default value: false
Allows or disallows the setting of the database driver DLL name as a report url parameter.
As of i-net Crystal-Clear 8.0, replaced by datasource. Specifies the database driver DLL name. The default value is read from the rpt template. The driver DLL name will be mapped into a JDBC driver in the data source configuration.
For more information see Report URL Parameters.
Default value: false
Allows or disallows the setting of the host of a datasource as a report url parameter.
As of i-net Crystal-Clear 8.0, replaced by datasource. Specifies the Name or the IP address of the database server if a JDBC driver is used for the database connection. If the connection to the database is created via the JDBC-ODBC bridge then this parameter specifies the ODBC DSN.
For more information see Report URL Parameters.
Default value: false
Allows or disallows the setting of the database catalog as a report url parameter.
As of i-net Crystal-Clear 8.0, replaced by datasource. Specifies the Database name that will be used at runtime instead of the database name that was specified at report creation. If the used database does not support catalogs (e.g. ORACLE) then this parameter will be ignored. This parameter has an effect only if a catalog was specified at design time. It is not possible to change the catalog if it was not specified at design time.
For more information see Report URL Parameters.
Default value: false
Allows or disallows the setting of the database name as a report url parameter.
As of i-net Crystal-Clear 8.0, replaced by datasource. Specifies the Database name that will be used at runtime instead of the database name that was specified at report creation.
For more information see Report URL Parameters.
Default value: false
Allows or disallows the setting of the database schema as a report url parameter.
As of i-net Crystal-Clear 8.0, replaced by datasource. Specifies the Schema that will be used with this report at runtime instead of the schema that was specified at report creation. If the used database does not support schema then this parameter will be ignored.
For more information see Report URL Parameters.
Default value: false
Allows or disallows the setting of the database user as a report url parameter.
As of i-net Crystal-Clear 8.0, replaced by datasource. Specifies the User ID for logging on to SQL, ODBC, or password protected databases used by the report and all of his sub reports (see password). Use this parameter instead of the parameter user# if you use the same username for the main report and all sub reports.
For more information see Report URL Parameters.
Default value: false
Allows or disallows the setting of the database password as a report url parameter.
Specifies the password for logging on to password protected databases used by the report and all of his sub reports. Use this parameter instead of password# if you use the same password for the main report and all sub reports.
The password parameter for the users you only need to set if the password is not empty. You don't need to set an empty password like ...&password0=.
For more information see Report URL Parameters.
Default value: false
Allows or disallows the usage of prompts as a report url parameter.
Specifies the value for the parameter field (prompt) with the specified name.
Parameter field values are assigned by name to the parameter fields.
For more information see Report URL Parameters.
Default value: true
Allows or disallows the setting of an output format as a report url parameter.
Specifies the output format in which the executed report will be returned to the client and how the report should be displayed in the browser, e.g.: init=pdf. If the Plug-In is not installed or not available then it is possible to save the exported report on the disk.
For more information see Report URL Parameters.
Default value: true
Allows or disallows the setting of a stored procedure as a report url parameter.
Crystal Reports 6.0 rpt files only.
Specifies the values for stored procedure parameters accessed by the report. Values are assigned to stored procedure parameters in the order the stored procedures are accessed by the report. For example: sproc0=12&sproc1=summer.
For more information see Report URL Parameters.
Default value: true
Allows or disallows the setting of a Record selection formula as a report url parameter.
Specifies the Record selection formula.
For more information see Report URL Parameters.
Default value: false
Allows or disallows the setting of a Group selection formula as a report url parameter.
Specifies the Group selection formula.
For more information see Report URL Parameters.
Default value: false
Allows or disallows the setting of the JDBC URL as a report url parameter.
As of i-net Crystal-Clear 8.0, replaced by datasource. Specifies the JDBC URL. This parameter overrides the value in the data source configuration. If you use the URL property then you need to guarantee that the driver is loaded on the server site. Otherwise you could receive the error "No suitable driver". If you do not have server site programming then it is recommended to use the datasource parameter.
For more information see Report URL Parameters.
Default value: false
Allows or disallows the setting of the query file as a report url parameter.
Specifies the Name and the path of the query file that should be used for this report.
For more information see Report URL Parameters.
Default value: false
Allows or disallows the setting of the upper bound for the number of pages to be rendered as a report url parameter.
Specifies the upper bound for the number of pages to be rendered. If your report has n pages and you set stopAfter=100 then only MIN(100, n) pages will be rendered.
For more information see Report URL Parameters.
Default value: true
Allows or disallows the replacement of tables and joins by a SQL statement.
This will cause a query to the database for the meta data of the supplied SQL statement. If not all required columns have been specified in the supplied SQL statement this will throw a ReportException with error code 1212.
Note: This can cause a loss of performance or fail for complex SQL statements.
Default value: false
i‑net software strives to provide accurate product documentation. Please give us your feedback using the form below.
NOTE: This form is for documentation feedback only. For technical assistance, please send an email to crystalclear@inetsoftware.de.
