I have a report that lists PRODUCTID (which are assigned starting with 1 until the end of the year) and associated PROJECTID (changes throughout the year, in no specific order). I need the report to sort the PRODUCTID in numerical order, but I've grouped the PROJECTID so that only the first occurrence appears rather than continual repeats. Each new PROJECTID invokes a page break.
I'm attempting to get around the sorting feature of using the GROUP BY function, but I want that visual appearance in my report.
The intended output should look something like this:
ProductID ProjectID
1 B
2
<page break>
3 A
4
What I end up with is this:
ProductID ProjectID
3 A
4
<page break>
1 B
2
Possibly sort by PRODUCTID, then coding to show only the first occurence of PROJECID, and page break when that value changes?
Thanks!