?
Solved

Oracle Apex - Grouping and Printing

Posted on 2012-04-03
6
Medium Priority
?
673 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 

Author Comment

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

Accepted Solution

by:
gatorvip earned 2000 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

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 post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

762 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