The report would show a page for each location. For example, my dataset is:
Location Date Order Num
Atlanta 1/10/25 123
Atlanta 1/10/25 124
Atlanta 1/11/25 125
Atlanta 1/11/25 126
Atlanta 1/11/25 127
Atlanta 1/12/25 128
Dallas 1/10/25 120
Dallas 1/11/25 121
Dallas 1/12/25 129
Page 1 would show all of the Atlanta data. Page 2 would show the Dallas data. I have 15 locations so if every location had an order, I would have 15 pages (at least). If a location had a significant number of orders, ideally it should span into a second page.
Also, I would like to deliver this with PDF output via a scheduled job that sends email.
I spoke too soon on my reply above. See my existing output and my desired output in the following image:
