The report is grouped and sorted on the Key Field “Request Number” this does not change for each new record
The detail data is correct for each record but the “Request Number” is not
The “Request number” won’t be changed, but sorting for this number is right?
There is an old bug in Report Builder when setting a Force New Page → Before Section for a group.
You will need another group “Request number” as the first group. This should handle pagebreack “Before Section”, the the following group “Request number” will show different content if it is set to Force New Page → None.
Set the first group Visible → No and you won’t see anything of this dummygroup.
Thanks, that worked