T
thrice2
I think I have a new one.
I created a report which contains all unpaid invoices from all clients.
There are 100+ clients - each with a unique ID in the "Client ID" field of my
report. There are multiple unpaid invoices for each Client ID.
I wish to print the report in a manner that each client has their own page
of unpaid invoices. In other words, I wish to insert a page break for every
new Client ID. I can sort the report by the Client ID field, but not insert a
page break for each change in that field. I do not want to create 100+
reports for each unique Client ID.
If possible, I would then like to sort by another field and insert similar
page breaks for each account manager (my associates). This would allow me to
print all unpaid invoices for that account manager. I could create separate
reports for that function, as there are fewer account managers. Can someone
please advise me?
Thank you in advance
I created a report which contains all unpaid invoices from all clients.
There are 100+ clients - each with a unique ID in the "Client ID" field of my
report. There are multiple unpaid invoices for each Client ID.
I wish to print the report in a manner that each client has their own page
of unpaid invoices. In other words, I wish to insert a page break for every
new Client ID. I can sort the report by the Client ID field, but not insert a
page break for each change in that field. I do not want to create 100+
reports for each unique Client ID.
If possible, I would then like to sort by another field and insert similar
page breaks for each account manager (my associates). This would allow me to
print all unpaid invoices for that account manager. I could create separate
reports for that function, as there are fewer account managers. Can someone
please advise me?
Thank you in advance