Re: Oracle Reports: Repeating frame collapses

Hello Alexander,

you can refer to a column in your query. You then have to write "column_a is null' in stead of 'column_a = null'.
Or you can write a 'nvl' in you query ( select nvl(column_a, 'No records found') ).

I think it would be better to put your object B_TEST in the frame R_TEST and not over it. If you then show B_TEST with a format trigger you hide all other objects in R_TEST with a format trigger.

Hope this helps.

--
Joost Bataille
University of Amsterdam ICT centre
www.ic.uva.nl

"a1ik" <a1ik.REMOVE_THIS_at_hotmail.com> wrote in message
news:7Cqo8.11019$RQq.3016_at_news02.bloor.is.net.cable.rogers.com...


> Hello, all!

>

> I hope somebody will help me with the following problem. Lets say we have

> simple single query Q_TEST report with just one group G_TEST. The only

> repeating frame R_TEST is linked to the G_TEST. In this case if G_TEST is

> empty R_TEST collapses and hides any object enclosed by the frame.

>

> The question is: how to make Oracle Reports to display some object, let's

> say text 'No Records Found' on the place of R_TEST every time when G_TEST

is


> empty? I placed text object B_TEST overlapping my R_TEST frame. I need to

> come up with some formatting trigger which will hide or display B_TEST

> object depending on the query result, but I don't know how to refer to it

> from PL/SQL code. I tried both (:Q_TEST = null) and (:G_TEST = null) it

> didn't work.

>

> Thank you for any help,


>

> --Alexander

>

>