Solved

Oracle Apex - Grouping and Printing

Posted on 2012-04-03
6
666 Views
Last Modified: 2012-06-21
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
0
Comment
Question by:gnivkor
  • 4
  • 2
6 Comments
 

Author Comment

by:gnivkor
ID: 37806147
if i am not being clear, please let me know and i will try to rephrase
0
 
LVL 20

Expert Comment

by:gatorvip
ID: 37806895
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
 

Author Comment

by:gnivkor
ID: 37807266
what I am trying to achieve is in the attached file, the attached file is on an access report
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:gnivkor
ID: 37811546
anyone else ?
0
 
LVL 20

Accepted Solution

by:
gatorvip earned 500 total points
ID: 37811715
>>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
 

Author Closing Comment

by:gnivkor
ID: 37816460
thank you
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now