Oracle Apex - Grouping and Printing

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
cdc.png
gnivkorAsked:
Who is Participating?
 
gatorvipCommented:
>>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

I gave you 3 different suggestions. The official Oracle docs are here: http://www.oracle.com/technetwork/developer-tools/apex/documentation/index.html

From what I can see in the screenshot, you have basically two sections:
a) the top part, where there are characteristics related to your item ("Mikes Cranberry Juice) - however, is the Ship Date unique as well, or can you have Mikes Cranberry Juice that shipped on 3/2 instead of 3/1? Can you have another vendor for the same item?
b) the report, with store#, route, etc.

I think a master/detail form would be your best approach in this case. The master page contains a brief listing of items and then links to the detail form. The detail form, in turn, shows the two sections that you are looking for.

Check out this link:
http://docs.oracle.com/cd/E14373_01/appdev.32/e13363/pdf_report.htm#BABFAJII 
in particular, how to create a master/detail form:
http://docs.oracle.com/cd/E14373_01/appdev.32/e13363/pdf_report.htm#insertedID3
and
http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21674/bldapp_frm.htm#autoId7
0
 
gnivkorAuthor Commented:
if i am not being clear, please let me know and i will try to rephrase
0
 
gatorvipCommented:
I'm not actually sure what your requirements are. However, if you have the query that gives you all the elements you need, then you have several options:
1. A master/detail form linked to a view (which contains your query)
2. An Interactive Report that uses your query and provides a link to the individual item
3. A regular SQL Report with group breakdowns
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
gnivkorAuthor Commented:
what I am trying to achieve is in the attached file, the attached file is on an access report
0
 
gnivkorAuthor Commented:
anyone else ?
0
 
gnivkorAuthor Commented:
thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.