I'm trying to build a report that has something similar to this
Depart Category Staff Age Years Hidden(Yrs/Age*)
12 Baby Boom 12 20 1 240 12
12 Seniors 6 40 3 120 18
18 27.5 1.66
33 Seniors 1 35 4
TOTAL
19 ?? ??
I can do the avg age/years and staff count using a seperate data query, but would like to find if there is a way to do it all off the first. I've got hidden columns in the query for Staff & Avg Age multiple by the count at each row. What I'd like to do is divide two summaries, but have it reset at the dept level. As well as use the summaries to put in a total formula for the organization. If we used Crystal, this is a no-brainer, but I'm not high enough in Oracle Reports yet to know if this is feasible.
Thanks
Depart Category Staff Age Years Hidden(Yrs/Age*)
12 Baby Boom 12 20 1 240 12
12 Seniors 6 40 3 120 18
18 27.5 1.66
33 Seniors 1 35 4
TOTAL
19 ?? ??
I can do the avg age/years and staff count using a seperate data query, but would like to find if there is a way to do it all off the first. I've got hidden columns in the query for Staff & Avg Age multiple by the count at each row. What I'd like to do is divide two summaries, but have it reset at the dept level. As well as use the summaries to put in a total formula for the organization. If we used Crystal, this is a no-brainer, but I'm not high enough in Oracle Reports yet to know if this is feasible.
Thanks