Object-Oriented Interface

Property

Description

BlankPageToFollow

(Report Header Only)

Follow the Report Header with a blank page (for duplex printing).

CenterContents

(Report Header/Trailer Only)

Centre contents in the page.

Columns$

Comma-separated list of column widths in points.

CountPage

(Report Header Only)

Include the Header page(s) in the page count.

DataSource$

Reference for the data source that is associated with this calculated field. Format is Source, SourceType.

Examples:

   LogicalFileName,L 
   Path,P
   ViewName,V 
   SourceClass;SourceName,O

This property is only used in report libraries. Read only. Set using SetDataSource( ) method.

FillToBottom

Boolean value (0/1) to indicate if the filler line is to be used to fill the space between the current section and the page footer (or page bottom) when the current section is the last section to be output to a page.

IncludePageFooter

(Report Header/Trailer Only)

Output the page footer with the Report Header or Trailer.

IncludePageHeader

(Report Header/Trailer Only)

Output the page header with the Report Header or Trailer.

Level$

Two-character code indicating the section level:

When PG and L1 levels are set, the Name$ property is set to null, and the NewPage and RepeatHeader properties are set to 0. When the 00 and RP levels are set, the Name$ property is set to null. Level$ is set to null if the code is invalid.

Name$

Name of the sort element on which a control break group is based following rules of element names; i.e. starts with an alpha character, followed optionally by alphanumeric, period and underscore characters. Name$ is null for page, detail and report summary section levels.

NewPage

Boolean value (0/1) to indicate if a new page is to be started when a control break or report summary occurs. Not applicable to page and detail line levels.

NewReport

(Control Break Level Only)

Boolean value (0/1) to indicate whether a new report file is to be created whenever the group changes.

The MultipleReports property of the parent pvxreport object is automatically adjusted based on this setting. Only one control break level can have this property turned On.

(The NewReport property was added in PxPlus 2022.)

OutputOddPageCount

(Report Trailer Only)

Output Report Trailer only if true page count is odd (for duplex printing).

RepeatHeader

Boolean value (0/1) to indicate if the control break group header lines are to be repeated at the top of each page.

ResetPage

(Control Break Level Only)

Boolean value (0/1) to indicate whether to reset the current page number to one when the group changes.

Type$

Single-character code indicating the type of report section:

   H - Header
   D - Detail line
   F - Footer
   L - Library

Set to null if code is invalid.

Method

Description

AddCell(Lnidx)

Creates a new rptcell object using the next available sequence number. Only cells with data or formatting need to have an rptcell object created for them.

Lnidx - Sequence number of the line where the cell is located.

CellCount for the specified line is incremented. Returns the object handle if successful, 0 if not.

AddFilter(Setidx)

Creates a new rptfilter object within the rptfilterset object specified by Setidx using the next available sequence number. One object is created for each filter set. The sequence number can be used as the index number to identify the object when using the RemoveFilter( ) and GetFilter( ) methods.

FilterCount for the rptfilterset object is incremented. Returns the object handle if successful, 0 if not.

AddFilterSet( )

Creates a new rptfilterset object using the next available sequence number. One object is created for each filter set. The sequence number can be used as the index number to identify the object when using the RemoveFilterSet( ) and GetFilterSet( ) methods.

FilterSetCount is incremented. Returns the object handle if successful, 0 if not.

AddLine( )

Creates a new rptline object using the next available sequence number. It is important to add the lines in the correct sequence, as this is the sequence in which the lines in the group will be displayed in the report.

LineCount for the group is incremented. Returns the object handle if successful, 0 if not.

CellCount(Lnidx)

Returns the number of data bearing cells in a line.

Lnidx - Sequence number of the line where the cell is located. Returns 0 if the argument is invalid.

Note:
A cell contains data or formatting information. Empty cells do not have an assigned object.

ClearFilters( )

Removes all rptfilterset objects in the set and resets FilterSetCount to 0.

ClearLines( )

Removes all rptline objects from the group and resets LineCount to 0.

FilterCount(Setidx)

Returns the number of rptfilter objects in the rptfilterset object specified by Setidx. If Setidx is omitted, returns the number of rptfilter objects in the first filter set.

FilterSetCount( )

Returns number of rptfilterset objects in the set.

GetCell(Lnidx,Cellidx)

Returns the handle for an rptcell object.

Lnidx - Sequence number of the line where the cell is located.

Cellidx - Sequence number of the rptcell object.

This allows access to all rptcell properties. Returns 0 if the arguments are invalid.

GetCondition$(Setidx,Filteridx)

Returns a string containing the PxPlus expression associated with a filter.

Setidx - Index indicating which rptfilterset object.

Filteridx - Index of the rptfilter object.

GetFilter(Setidx,Filteridx)

Returns the handle for an rptfilter object.

Setidx - Index indicating which rptfilterset object.

Filteridx - Index of the rptfilter object.t

GetFilterSet(idx)

Returns the handle for an rptfilterset object.

idx - Sequence number of the rptfilterset object. This allows access to all rptfilterset properties and methods. Returns 0 if not successful.

GetGroupDefinition$( )

Returns a formatted string based on section information. The format of the string is that used to define a BREAK= entry in the report definition file. Returns null if the information in the rptgroup object is invalid.

GetLine(idx)

Returns the handle for an rptline object.

idx - Sequence number of line within the group.

This allows access to all rptline properties and methods. Returns 0 if the arguments are invalid.

LineCount( )

Returns the number of lines in the section.

RemoveCell(Lnidx,Cellidx)

Removes an rptcell object from the section.

Lnidx - Sequence number of the line in which the cell is located.

Cellidx - Sequence number of the cell to be removed.

If an rptcell object is removed, the sequence number of the rptcell objects with higher sequence numbers is adjusted down. CellCount is decremented for the line. Returns the object handle if successful, 0 if not.

RemoveFilter(Setidx,Filteridx)

Removes an rptfilter object.

Setidx - Index indicating which rptfilterset object.

Filteridx - Index of the rptfilter object.

RemoveFilterSet(idx)

Removes an rptfilterset object.

idx - Sequence number of the object to be removed.

If an rptfilterset object is removed, the sequence number of the rptfilterset objects with higher sequence numbers is adjusted down. FilterSetCount is decremented. Returns the object handle if successful, 0 if not.

RemoveLine(idx)

Removes an rptline object from the section.

idx - Sequence number of line to be removed.

If an rptline object is removed, the sequence number of the rptline objects with higher sequence numbers is adjusted down. Removes all rptcell objects associated with the line. LineCount is decremented for the section. Returns the object handle if successful, 0 if not.

SetDataSource( )

SetDataSource(Source$,Type$)

Format and set the value in the DataSource$ property.

Source$ - Name of the data source. This can be a logical table name, a file path, a view or a class name;source name. (Custom source objects consist of the both the class name and source name separated by a semi-colon.)

Type$ - Single letter code denoting type of data source:

   L - Logical table
   P - File path
   V - View
   O - Custom source class

Returns 1 if successful, 0 if not. If no arguments, resets the DataSource$ property to null.

SetGroupDefinition(Def$)

Assigns rptgroup properties based on a formatted string. Returns 1. The format of the string is that used to define a BREAK= entry in the report definition file.

Def$ - Formatted string containing the section information: