Microsoft Excel reporting and 
 data analyzing with practically no coding. 
 .Net, ActiveX, and VCL versions. 
 www.AfalinaSoft.com  

Home    Products    Downloads    Registered users    Support    Prices    Order    Primary Subscription

 

MS Office COM Add-ins. Microsoft Excel reporting 
 and data analyzing


XLRParams class - AfalinaSoft Active XL Report Programmer's Reference

<< Previous

Table of contents

Next >>


XLRParams class

Zero-based list of all the parameters for the current report.


XLRParams Properties


Count (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 Methods


Add

Adds 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.

Delete

Deletes 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.

<< Previous

Table of contents

Next >>



Components

axlr axlr.ocx

Data Access methods

  • ADO
  • DAO
  • RDO
  • custom data

Excel version supported

MS Excel 97 (SR2)
MS Excel 2000
MS Excel 2002 (XP)
MS Excel 2003



[ Download it ]
[ Order now ]

Copyright © 1999-2006
All right reserved.
Privacy Policy

Write to WebMaster

Page Top
Add-in Express - Visual tool for Office customization