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
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., 2023 • Updated: 01/13/17
Comment or report problem with topic