StoredProcParam

StoredProcParam specifies the stored procedure parameters when using a report based on SQL stored procedures.

Syntax

[form.]Report.StoredProcParam(Parameter Array Index%)[= newParameter$]

For example:

CrystalReport1.StoredProcParam(0)="06/14/1989"

«Sets the first stored procedure parameter to the date June 14, 1989.»

Remarks

StoredProcParam sets the value of the specified parameter in an SQL database table that is based on a stored procedure. Pass the value you wish to set the parameter to as a string. If the parameter expects a different data type, you still must pass the value as a string. For example, to pass the integer value 396, use the string "396". The Crystal Report Engine will handle converting the value into integer format.

Note:    

Data Type

Arrays of strings

Availability

Runtime

Related Report Engine Functions

PESetNthParameterDefaultValue



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com