Header field data from repetitive area
we have created PLD form from a query, but we need to add some fields in the PLD form page header. The fields must match with the repetitive area1 fields (RA1F). For example, in the RA1F, there is a row delivery date, and in the page header, we need to display the date and in the row, the field will set to be invisible.
We have created formula field in the header and the operation we use is date(). So if the row delivery date field name is Field_123, then the formula we use is date(Field_123), but the report is unable to generate. there is an error message. Pls give advice if it is possible to do this steps or not. TIA
you cant create an header like it will create an error since the data being fetch is no yet evaluated. The header can call only datas from Where of your query.