This topic was covered before but nothing has changed. I have several reports that must print groups on separate pages. These include my checks that pay multiple invoices and my mandatory monthly Pesticide Use Report to name a few. Pan 6 did this fine but Pan X won’t. There may be a work around but I can’t use Pan X for my business until this is resolved. I am a 40 year ProVUE database user and I can’t run my business without the capabilities of Pan 6. Have I wasted 40 years of my life?
Not difficult. Arraybuild on the field you want to use as the groups’ names, then deduplicate the variable you’ve saved the groups into. Loop through the groups array, selecting all records that match each entry and then print that group with whatever form you need to use. The loop will rinse and repeat, printing each group in turn.
1 Like
If your arraybuild includes a query parameter, it can test for info(“summary”)=1, so that only the summary records are included. In that case, you won’t need to deduplicate.
1 Like
Good point–if you only want summaries.
No, Dave’s suggestion works even if he wants all records. By adding the test for summaries, he will only get one array entry per group, so deduplicate won’t be needed.
Gotcha. I was already on past the arraybuild statement and was on to the selection in my head. My bad.