SQL & PL/SQL :: Mix Records From Overview And Detail Table In One Report

in substance I need to mix results from overview table and records from details table in same report.

For creating the scenario:

CREATE TABLE ALPHA
(
ALPHA_IDNUMBER,

[Code]....

Second report should display the overview per time period (year), but the records from e.g. year 2009 start counting in year 2010. At the end of each year again a summary for the actual status.

"YEAR";"ALPHA_NR";"ALPHA_TOTCT";"ALPHA_FUND"
;;;
2009;7;0;0
;11;0;0
;15;0;0
;17;0;0
"Total 2009";4;0;0
2010;7;2;20
;11;1;10
;15;2;20
;17;0;0
"Total 2010";4;5;50
2011;7;5;50
;11;-1;-10
;15;7;70
;17;0;0
"Total 2011";4;11;110
2012;7;5;50
;11;0;0
;15;3;30
;17;1;10
"Total 2012";4;9;90