I have a monthly burst report that last month took 7½ hours to create ~4,100 PDF files. Volume is projected to keep growing and it's estimated there will be 10,000+ PDFs at the end of 2022 and over 30,000 by the end of 2023. Any thoughts on how I might run the report 2,500 PDFs at a time and run several bursts concurrently? Customer ID is what makes each PDF unique so I can use that field but I'm not sure how (or if it's possible) to feed only 2,500 CUST_IDs at a time into a prompt and keep doing that until I go through them all.
Thank you all for any suggestions. :)