Separate queries in one report with page filter [message #656031] |
Wed, 21 September 2016 02:15 |
|
OraFerro
Messages: 433 Registered: July 2011
|
Senior Member |
|
|
Hi All,
I have a legacy report on Oracle Report 6 which I have very limited experience in.
Report Scope
- I have a report that takes one parameter (customer ID)
- The report should show all customer withdrawals for this year, all customer payments for this year, and all customer charges for this year each in a separate table. So three tables one for payment, second for withdrawal, and a third for charges.
- The report should display each month in one page. So Jan should show Jan Withdrawals in a table, Jan Payments in a Table, and Jan Charges...etc.
Preparation:
- I have three SQL statements (for Withdrawal, Payments, and Charges) all prepared to take one parameter (Customer ID) and will return transactions for this customer ID during current year showing the month number as a separate field.
Problem Definition/Needed support:
- As I have the queries ready and prepared as three separate queries with no link between them:
1- I need to know which feature (in the layout/or in general) I can use so that I can place the output of each SQL in the areas/tables and make the report filter the data by month and display the relevant data in each table which writing the month as the report header.
2- Is there any better way to do it?
Many Thanks,
Ferro
[Updated on: Wed, 21 September 2016 02:17] Report message to a moderator
|
|
|
Re: Separate queries in one report with page filter [message #656068 is a reply to message #656031] |
Wed, 21 September 2016 14:31 |
|
Littlefoot
Messages: 21811 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Here's an idea - try it and see whether it works or not.
- create another query which will select all months for that customer (either by UNION of all three tables, or using a row generator)
- use a data link tool and link months from current three queries to the newly created "Months" query
- let the wizard create a paper layout (that would probably be a "Group Above", month being the group
- set the "Break after" property to Yes for the group (month) frame
- run the report
|
|
|