I have a report that uses a set of 4 queries joined by unions. The 4 queries are simply selects for 4 different groups - for example, group A, group B, group C, and group D. The report works fine but now the user has a new request.
Obviously, the returned result from the query just displays as one long report. Is it possible to seperate the results from groups A, B, C, and D in the report? For example, when group A finishes, create a page break and go to a new page to start group B.
Can this be done without simply creating seperate reports for the different groups? Thanks in advance!