I want to create a report that shows proposed payments to suppliers in this form
Account, Amount to pay, Invoices
ABC001, 1000.00, KFabc01 KFabc02 etc
The difficult bit is creating the list of invoices to pay.
My thoughts are that the detail level would be each invoice
On the Account Header you initialise a variable to blank
On each detail line you append the current reference to the variable
On the Account Footer you have the final list displayed
Repeat for each account
I do not see if it is possible to assign values to a variable in this way with report designer