Body Rules

Body rules allow you to determine what data to include inside form bodies and cross tabs, and when form body printing or cross tab creation is completed.

All Rules That Must Be True

Press the Add button to add this rule and enter a report expression that must evaluate to "true". For example, the following rule specifies that only the stock group types that match the word "CAMERA" will be included on the report.

Stock->Type = "CAMERA"

All rules specified in this section must evaluate to "true", otherwise the record will not be included on the report. This is useful for specifying ranges. Consider these two rules:

Invoice->Date >= ForDate("01/01/98")

Invoice->Date < ForDate("01/01/99")

For a record to be included on the body of the report, the invoice date must be greater than or equal to the 1st of January 1998, and less than the 1st of January 1999.

For more information on reporting expressions see: CAPITAL Business Script.

At Least One Of These Rules Must Be True

Press the Add button to add this rule and enter a report expression that must evaluate to "true". At least one of the rules in this section must be "true" for the record to be included on the body of the report. If you have "either/or" conditions for including a record on a report put them here. Consider these rules:

Invoice->Itype = '1'

Invoice->Itype = '2'

In the above case if the invoice Itype (invoice transaction type) equals 1 or 2 then the record will be included on the report.

When One Of These Rules Is True, Reporting Is Finished

Specify rules here that tell the body to print no more records. This can be useful for speeding up the generation of a report. If you have a report sorted by customer account code but only want to include codes beginning with a A-L on the report, then the following rule could be used to determine whether processing should continue:

Invoice->Acccode > 'A'

This rule would only be correct if the report body was sorted by account code in the first place. If the report was unsorted or sorted on another field, account codes would not appear in alphabetical sequence and report printing could stop at the wrong time. In these cases use a All Rules Must Be True condition instead.