This is not difficult, but 6i makes it so
426799Aug 26 2004 — edited Aug 27 2004Hi guys -
I am producing a pseudo-matrix report (meaning that it has the look and feel of a matrix, but is actually a simple group left report) in 6i. The report is a statistical summary of certain kinds of employees based on job category and gender. In the report footer, I want to add a breakdown of Males and Females and the percentages they make up of the job categories. I was able to count everything correctly in one query utilizing 3 inline views and subsequently dragging the values up one level per subquery. However, when I try to implement the values into the report, I cannot because they are not in the correct "group". This is highly frustrating because they don't even need to be in a group at all, but nothing I have done seems to be working. I tried adding a second query, popping out the inline views and building a new query and this did not work. I tried making the values their own group and that didn't work either. I tried enlarging the group frame to encapsulate the footer and that destroyed my report. So, are there any suggestions out there that can help me get around this absolutely assanine problem? Thanks in advance.