Re: Oracle Reports Question (w/ Nested Matrix Reports)

Dylan Cooper <dylan_at_desert.ocm> wrote:

>I am using Oracle Reports 2.0 and have created a nested matrix
>report with two variables repeating down and one variable repeating
>across. I would like to suppress the display of rows that have all
>null cells.
>
>.....
>
>How can I do this?
>

This is covered in the class that Oracle gives for Reports 2.5. If you have the book from that class, look near the end of chapter 13. If not, here's the list of steps they provide to do it.

1. Create a a parent query, two 'label' queries, one for the rows and one for the columns, and the cell query.
2. Create the cross product group to surround only the label groups. Do not enclose the parent group in the c/p group.
3. Link the parent group to one of the lable queries to achieve a matrix of all combinations for each break record.
4. Link the relevant label columns to the child columns.

This is a little difficult to understand just from htese steps but it does work. Play around with it and you should get it. Received on Fri Nov 15 1996 - 00:00:00 CET