Re: Matrix Layout Using Oracle Reports

You can create a function in the parent group with the same query that you want to fill the missing rows and then you already have control

ex.. the function may return a '1' if the query returns something or an '0' if it does not.

BoogieDoo wrote:

> Dear All,
>
> I am developing a matrix report using Developer version 3 and I need to
> display a value for the cross product values that do not exist. I can boiler
> plate a value under the repeating frame and change the fill colour of the
> field of the fetched value to white, which display correctly in the live
> previewer. The problem is that the printer I am using does recognise
> overprinting and what is actually printed is the boiler plated value
> overstruck by the actual value.
>
> I can't figure out how to force a value to be printed in the matrix when a
> row does not exist for that cross product position !
>
> Does anyone have any ideas ?
>
> Boogie
Received on Tue Jan 05 1999 - 13:20:25 CET