|
|
|||
Home Products Downloads Registered users Support Prices Order Primary Subscription |
|
||
XLRParams classZero-based list of all the parameters for the current report. XLRParams PropertiesCount (read only)Returns the number of parameters in the list of report parameters.
Property Count As Long
Name (read/write)Returns the name of a parameter from the list of report parameters either by position (starting from zero) or by name.
Property Name(Index) As String
The following construction change the parameter's name from "StartDate" to "StartDateNew":
ocxXLReport.Params.Name("StartDate") = "StartDateNew"
See also: XLRParams.Value property, XLRParams.Add method. Value (read/write)Returns the value of a parameter from the list of report parameters either by position (starting from zero) or by name.
Property Value(Index)
The following construction set the value of the "StartDate" parameter to the current date:
ocxXLReport.Params.Value("StartDate") = Date
See also: XLRParams.Name property, XLRParams.Add method. XLRParams MethodsAddAdds a new parameter to the list of report parameters.
Sub Add(Name As String, Value)
The first parameter of the method is the name of the report parameter and the second one is its value. The following construction adds the "StartDate" parameter to the list of report parameters and sets its value to the current date:
Me.ocxXLReport.Params.Add "StartDate", Date
See also: XLRParams.Delete method. DeleteDeletes a specified parameter from the list of report parameters.
Sub Delete(Index)
The parameter can be specified either by position (starting from zero) or by name. The following construction deletes the "StartDate" parameter from the list of report parameters:
Me.ocxXLReport.Params.Delete("StartDate")
See also: XLRParams.Add method. |
Components
Data Access methods
Excel version supportedMS Excel 97 (SR2)
[ Download it ] |