I am currently using Workday Studio (BIRT) where I am extracting sample data Workday as xml to build a report and deploy it back to Workday. My requirement is to print details of individual employee for several locations and after each location, I need to add a page separator which displays detail of the location which it printed and how many employees (more like a counter) before I jumps to employee of next location and then another page separator with location and how many employees were printed.
I am partially successful. Couple of issues are that I am not able to get the last page separator.
I've created a field that identifies the previous row value for location and I am comparing that value with the current row location and I've inserted a row that I display for page separator with a page break. As it hits the last row and I do not have any more value to compare it against, the last page separator never displays.