CRPEJob::SetFormula

Syntax

SetFormula (formulaName CHAR(*), formulaText CHAR(*)) RETURNING BOOLEAN

Parameters

formulaName	The name of the formula for which you want to assign new formula text.
formulaText	The actual formula text that replaces the existing formula string.

Remarks

This method sets the formula text for the specified formula. CRPEJob::SetFormula is often used with CRPEJob::GetFormula, Page 413, to identify and then change an existing formula at print time in response to a user selection.

Returns

●TRUE if the call is successful.

●FALSE there is an error in the formula, or if the call fails.

Related Topics

PESetFormula, Volume 2, Chapter 1

CRPEJob::SetGraphData

Use SetGraphData to change the data that is used from your report to create a specified chart. This information includes the groups used to create the rows and columns of the chart and the summary field used to set the values of the risers in the chart.

Syntax

SetGraphData (sectionCode SMALLINT, graphN SMALLINT, graphDataInfo CRPEGraphDataInfo) RETURNING BOOLEAN

Parameters

sectionCode	Specifies the Section Codes (page 480), for the section of the report containing the
	chart for which you want to set data information.

Crystal Class Library for NewEra Reference

442

graphN	Specifies from which chart within the section you want to set chart data information.
	This value is 0-based. Within a section, charts are numbered from top to bottom first
	and from left to right if they have the same top.
graphDataInfo	Specifies a pointer to class CRPEGraphDataInfo (page 465).

Returns

●TRUE if the call is successful.

●FALSE if the call fails.

Related Topics

PESetGraphData, Volume 2, Chapter 1

CRPEJob::SetGraphOptions

Use SetGraphOptions to change any of several chart options. These options include the minimum and maximum values that can appear on the chart, whether grid lines appear, whether risers are labeled, whether bar charts have horizontal or vertical bars, and whether a legend appears on the chart.

Syntax

SetGraphOptions (sectionCode SMALLINT, graphN SMALLINT, graphOptions CRPEGraphOptions) RETURNING BOOLEAN

Parameters

sectionCode	Specifies the Section Codes (page 480), for the section of the report containing the
	chart for which you want to set options information.
graphN	Specifies from which chart within the section you want to set chart options
	information. This value is 0-based. Within a section, charts are numbered from top to
	bottom first and from left to right if they have the same top.
graphOptions	Specifies a pointer to class CRPEGraphOptions (page 466).

Returns

●TRUE if the call is successful.

●FALSE if the call fails.

Related Topics

PESetGraphOptions, Volume 2, Chapter 1

Crystal Class Library for NewEra Reference

443

CRPEJob::SetGraphText

Use SetGraphText to set or change the text that appears with a chart. A chart can have a title, subtitle, footnote, title for groups, title for series, title for the X axis, title for the Y axis, and title for the Z axis (in 3D chart).

Syntax

SetGraphText (sectionCode SMALLINT, graphN SMALLINT, graphTextInfo CRPEGraphTextInfo) RETURNING BOOLEAN

Parameters

sectionCode	Specifies the Section Codes (page 480), for the section of the report containing the
	chart for which you want to set text information.
graphN	Specifies from which chart within the section you want to set chart text information.
	This value is 0-based. Within a section, charts are numbered from top to bottom first
	and from left to right if they have the same top.
graphTextInfo	Specifies a pointer to class CRPEGraphTextInfo (page 468).

Returns

●TRUE if the call is successful.

●FALSE if the call fails.

Related Topics

PESetGraphText, Volume 2, Chapter 1

CRPEJob::SetGraphType

Use SetGraphType to set the type of chart displayed for the specified chart in the specified section based on one of the available types. Use this method to change the type of chart that is displayed in a report.

Syntax

SetGraphType (sectionCode SMALLINT, graphN SMALLINT, graphType SMALLINT) RETURNING BOOLEAN

Crystal Class Library for NewEra Reference

444

Parameters

sectionCode	Specifies the Section Codes (page 480), for the section of the report containing the chart
	for which you want to set type information.
graphN	Specifies from which chart within the section you want to set chart type information.
	This value is 0-based. Within a section, charts are numbered from top to bottom first and
	from left to right if they have the same top.
graphType	Specifies one of the Chart Type Constants (page 477), indicating the style of the chart that
	you want to set.

Returns

●TRUE if the call is successful.

●FALSE if the call fails.

Related Topics

PESetGraphType, Volume 2, Chapter 1

CRPEJob::SetGroupCondition

Syntax

SetGroupCondition (sectionCode SMALLINT,conditionField CHAR(*), condition SMALLINT, sortDirection SMALLINT) RETURNING BOOLEAN

Parameters

sectionCode	Specifies the Section Codes (page 480), for the section of the report for which you
	want to set group condition information.
conditionField	Specifies the field that triggers a summary whenever its value changes. Use the name
	of the field as indicated in the report file.
condition	Specifies the condition that needs to be met for Date and Boolean fields. For all field
	types except Date and Boolean, use PEP_GC_ANYCHANGE as the condition
	parameter.
	Value (Date Fields)	Meaning
	PEP_GC_DAILY	Triggers a grouping every time the date changes.
	PEP_GC_WEEKLY	Triggers a grouping every time the date changes
		from one week to the next (a week runs from
		Sunday through Saturday).

Crystal Class Library for NewEra Reference

445

Value (Date Fields)	Meaning
PEP_GC_BIWEEKLY	Triggers a grouping every time the date changes
	from one two-week period to the next.
PEP_GC_SEMIMONTHLY	Triggers a grouping every time the date changes
	from one half-month period to the next.
PEP_GC_MONTHLY	Triggers a grouping every time the date changes
	from one month to the next.
PEP_GC_QUARTERLY	Triggers a grouping every time the date changes
	from one calendar quarter to the next.
PEP_GC_SEMIANNUALLY	Triggers a grouping every time the date changes
	from one half-year period to the next.
PEP_GC_ANNUALLY	Triggers a grouping every time the date changes
	from one year to the next.

	Value (Boolean Fields)	Meaning
	PEP_GC_TOYES	Triggers a grouping every time the sort and
		group by field changes from No to Yes.
	PEP_GC_TONO	Triggers a grouping every time the sort and
		group by field changes from Yes to No.
	PEP_GC_EVERYYES	Triggers a grouping every time the group and
		sort by field value is Yes.
	PEP_GC_EVERYNO	Triggers a grouping every time the group and
		sort by field value is No.
	PEP_GC_NEXTISYES	Triggers a grouping every time the next value in
		the sort and group by field is Yes.
	PEP_GC_NEXTISNO	Triggers a grouping every time the next value in
		the sort and group by field is No.
sortDirection	Specifies one of Sort Order Constants (page 480).

Remarks

This method sets the condition of the grouping for the specified group section. This method can only replace the group condition for an existing group. It can not create a new group. Use this function whenever you want to change the grouping at print time, for example, to print one report grouped in several different ways.

Returns

●TRUE if the call is successful.

●FALSE if the call fails.

Crystal Class Library for NewEra Reference

446