Page wise grouping [message #632124] |
Sun, 25 January 2015 22:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/c70e51380f6e8af6765f6e8fede51587?s=64&d=mm&r=g) |
m.abdulhaq
Messages: 254 Registered: April 2013 Location: Ajman
|
Senior Member |
|
|
I have two queries in one report with one column similar in both the data queries, first query runs the detail and the other runs the summary , now i want the summary query to lookup for one column in detail as reference parameter so that for each page one employee details are printed.
--first query displays details
select emp_code , emp_name,emp_dob, emp_join_dt
from emp_mast;
--second query summation -- i know we can do this using join condition but this is just an example of requirement.
select emp_allw_code,sum(salary) from emp_pay
where emp_code = :emp_code ( from the detail query per page for each employee)
|
|
|
|
|
|
Re: Page wise grouping [message #632136 is a reply to message #632134] |
Mon, 26 January 2015 06:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/c70e51380f6e8af6765f6e8fede51587?s=64&d=mm&r=g) |
m.abdulhaq
Messages: 254 Registered: April 2013 Location: Ajman
|
Senior Member |
|
|
thanks littlefoot, it worked , actually i had to use two queries in the report problem was if the summary query has subqueries data link will not work properly and hence i modified it to work properly.
|
|
|