Print State


Print state functions control the state of the report when the data is being previewed.

Table C-13: Print state functions

Function

Description

Arguments

Previous (fld)

Returns the value of the specified field in the previous record.

fld is any valid database or formula field in the report.

PreviousValue (fld)

Returns the value of the previous record of the specified field.

fld is the name of a database field.

Next (fld)

Returns the value of the specified field for the next record.

fld is any valid database field or formula field.

NextValue (fld)

Returns the value of the next record of the specified field.

fld is the name of a database field.

IsNull (fld)

Evaluates the field specified in the current record and returns TRUE if the field contains a NULL value.

fld is any valid database, memo, or BLOB field.

PreviousIsNull (fld)

Evaluates the field specified in the previous record and returns TRUE if the field contains a NULL value.

fld is any numeric, formula, memo, or BLOB field in the report.

NextIsNull (fld)

Evaluates the field specified in the next record and returns TRUE if the field contains a NULL value.

fld is any valid database, formula, memo or BLOB field in the report.

PageNumber

Inserts the current page number as a field in a formula.

(no arguments)

TotalPageCount

Passes the report and returns the total number of pages.

(no arguments)

PageNofM

Inserts the "Page [current page number] of [total page count]" as a field in a formula.

(no arguments)

RecordNumber

Returns the current record number.

(no arguments)

GroupNumber

Returns the current group number.

(no arguments)

RecordSelection

Inserts the record selection formula for the report in a formula that you can place on your report.

(no arguments)

GroupSelection

Inserts the group selection formula for the report in a formula that you can place on your report.

(no arguments)

InRepeatedGroupHeader

Returns TRUE when a Group Header section is repeated on a second, third, and so on, page.

(no arguments)

OnFirstRecord

Returns TRUE when the current record being evaluated is the first record in the report.

(no arguments)

OnLastRecord

Returns TRUE when the current record being evaluated is the last record in the report.

(no arguments)

DrillDownGroupLevel

Returns a number that indicates the group level of the current drill-down view, or 0 if it is not a drill-down view.

(no arguments)




Mastering Business Analysis with Crystal Reports 9
Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)
ISBN: 1556222939
EAN: 2147483647
Year: 2004
Pages: 177
Authors: Chris Tull

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net