Hide Non repeated Frame

[mrkamran]

Hi,
I have a repeted frame in a non repeted frame. when the value of repeated frame is null then the repeated frame do not show but outer non repeting frame show. i want hide this frame when inner repeted frame is null. I have used conditional formating on outer frame but no effect and also is format trigger. On format trigger of non repeating frame i use that codeing

function M_3FormatTrigger return boolean is
begin
if :SrNo2 is NULL then
return (False);
else
return (True);
end if;
end;

here srno 2 is the field of my query
but it also not work, error mesege of "wrong frequency" come.
what should i do?

 

[BJCooperIT]

When you say that the non-repeating frame shows, do you mean that you have a large blank space where it should be? If that is the case, try setting the non-repeating frame's VERTICAL property to VARIABLE.

If you mean that it, and its contents, still print then it may have to do with your heirarchy structure in your data model.

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: Emu Products Plus

 

[TISIBS]

- In "data model" create a summary column "CS_print" with "Column Type = Summary" and "Function = First" and "Source = SrNo2". Place it outside any query.
- Change your Trigger:

function M_3FormatTrigger return boolean is
begin
return CS_print IS NOT NULL);
end;


Timo