i-net Clear Reports

Report URL Parameter of Customization

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.

Report URL Parameter of Customization

Allow Parameter 'datasource'

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

Allow Parameter 'password'

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

Allow Parameter 'prompt'

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

Allow Parameter 'init'

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

Allow Parameter 'sproc'

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

Allow Parameter 'sf'

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

Allow Parameter 'gf'

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

Allow Parameter 'queryfile'

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

Allow Parameter 'stopAfterPage'

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

Allow Parameter 'sql'

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

See Also:


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 clearreports@inetsoftware.de.

 

© Copyright 1996 - 2012, i-net software; All Rights Reserved.