[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 691
  • Last Modified:

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
0
gnivkor
Asked:
gnivkor
  • 4
  • 2
1 Solution
 
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
 
gnivkorAuthor Commented:
what I am trying to achieve is in the attached file, the attached file is on an access report
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
gnivkorAuthor Commented:
anyone else ?
0
 
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:
thank you
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now