So I have been assigned to convert a MS Access DB to Oracle, I am doing reporting with oracle apex, all my views and queries are working find and are in a good format.
Where I am running into troubles is creating reports by group and printing each group individually from a single print.
In access when I create a report if the report has 100 pages, i print once and all 100 pages are printed for the individual group.
Lets say I have a query that selects data from multiple tables that have the following columns
item, store, route, ordered, etc, etc, etc
I want to be able to select "item" and get all the entries for that items, amount, store, route, etc etc..
I attached an image of the report in excel, the example has item "Mikes Cranberry Juice" if i hit next on the report I will get "Mikes Lemonade" with the corresponding data.
I am not looking for a step by step tutorial on how to get this done, just someone to point me in the proper direction and some documentation would be nice, all of my queries and everything else is working fine and displaying correctly
using latest version of apex on xe