When is the header in a simple table recalculated?
When changes are made in the header field or in the rows.
If the fields in the header take values from the rows part of the same table, will they be updated if a single field change in the rows part occurs?
No, the header is recalculated before the row part. Therefore, if it takes any values from the row part of its own table and needs to have up-to-date data, you will have to recalculate the table with an additional action.
But such an organization of the solution is bad. You should strive to avoid it.
How do I split the header into several lines?
Mark in the field that needs to be transferred that it will be On a new line.
How to display the header field in the footer and vice versa?
For example, the order total is calculated in the footer, but we want to display it in the header — we use display elsewhere.
Will this affect their order of calculation?
No, if we display the field in another place, it does not affect its home placement and sort.
How do I access the header field from the code?
Referencing fields within a single table is done using #field_name. If a field with such a name exists in the header, footer, and pre-filter, it has a single value, and that value will be used.
If this field is in the row section, it has multiple values — as many as there are rows in the table. Therefore, referencing it using # is only possible from another field in the row section — the value from the same row from which it is being requested will be used.
How do I access a header field that is in a different table?
=: @table_name.field_name_in_header_or_footer