Solved

Oracle Apex - Grouping and Printing

Posted on 2012-04-03
6
669 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to take different types of Oracle backups using RMAN.

860 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