Oracle Reports: Repeating frame collapses

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 Received on Wed Mar 27 2002 - 22:13:39 CET