less than 1 minute to read

The ReportEngine.AfterAddField script is called after a field is added to a report in a report wizard. This can be used, for example, to modify the default settings for the field or give a warning if the field shouldn't be used under some circumstances.

Parameters
A reference to the Stonefield Query Application object, a reference to a Report object for the report, and a reference to the newly added ReportField object.

Return Value
Any value (Stonefield Query ignores the return value).

Example
Here's an example that gives a warning if fields from the OEINVD table are included in a report with fields from the OEINVDCRDD table.

Visual FoxPro

foxpro
lparameters toApplication as SQApplication, ; toReport as Report, toField as ReportField local lnI, loField as ReportField, lcAlias, ; llHaveCombined, llHaveDetail for lnI = 1 to toReport.Fields.Count loField = toReport.Fields.Item(lnI) lcAlias = loField.Alias do case case lcAlias = 'OEINVDCRDD' llHaveCombined = .T. case lcAlias = 'OEINVD' llHaveDetail = .T. endif next if llHaveCombined and include fields from toApplication.ShowErrorMessage('You should not ' + ; 'include fields from Invoice Details on the ' + ; 'same report as Combined Invoice & Credit Note Details.') endif

See also

Scripts

© Stonefield Software Inc., 2024 • Updated: 01/13/17
Comment or report problem with topic