Interface

Dataset

Description

A component of the Reports Module module that provides the data access for the report.

Methods

Name	Parameters	Returns
EOF		Boolean
Field	idx As Integer	Variant
	name As String	Variant
NextRecord		Boolean
Run
Type	fieldName As String	Integer

Method descriptions

Dataset.EOF

EOF As Boolean

Specifies whether the end of file has been reached.

Dataset.Field

Field(idx As Integer) As Variant

Gets the field by name.

Dataset.Field

Field(name As String) As Variant

Gets the field by name.

Dataset.NextRecord

NextRecord As Boolean

Advances to the next record.

Dataset.Run

Run

Run is the first method to be called when the report is run.

Dataset.Type

Type(fieldName As String) As Integer

Declares the field types for the data in the Dataset. Returns an Integer that indicates the data type.

The field types are the SQL field types listed in the Database.TableColumns entry. The reporting engine uses this to determine whether the column is numeric and whether the Format function should be applied.

Notes

The Dataset interface enables you to use any Dataset as the data source for the report. See the example for notes on how to set up the Dataset interface to use a text file as the data source.

To return Pictures for display in a report, you should return the Picture data rather than a Picture object. For example, if you have a Picture in variable p, then your would return the Picture data in the Field method like this:

Return p.GetData(Picture.FormatPNG)

Use a type of 14 to identify the Picture as data.

Compatibility

All project types on all supported operating systems.