OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Space Utilisation

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Space Utilisation [message #148557]

Thu, 24 November 2005 23:43

sasidhar242
Messages: 1
Registered: November 2005
Location: hyd

Junior Member

Hi All

I Have Created A report On Default Emp Table
Here I dont want to display the details of job=president
so i have written in the format trigger of all the fields

if :job ='PRESIDENT'
THEN RETURN(FALSE);
ELSE
RETURN(TRUE);
END IF;

this is working fine but what i require is ,
it is leaving a blank space for that particular record.
i want to save that space i mean when ever i have a blank record
the next record should occupy its place.

any suggestions are welcome

Regards
Sasidhar.P

Report message to a moderator

Re: Space Utilisation [message #255039 is a reply to message #148557]

Mon, 30 July 2007 08:28

parvinder.infogen
Messages: 10
Registered: February 2007
Location: New Delhi

Junior Member

select the repeating frame and set vertical elasticity property to variable

Report message to a moderator

Re: Space Utilisation [message #255046 is a reply to message #255039]

Mon, 30 July 2007 08:46

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Eeeh, why don't you add a where clause to your query so that that person never shows up in the results??
(probably I misunderstand your question).

Report message to a moderator

Re: Space Utilisation [message #255100 is a reply to message #255046]

Mon, 30 July 2007 11:09

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Sabine, you (and I) were young and beautiful when this topic was started. Now we are only beautiful /forum/fa/1704/0/

. It it 2 years old!

Report message to a moderator

Re: Space Utilisation [message #255254 is a reply to message #255100]

Tue, 31 July 2007 03:51

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Fooled again by someone answering an old topic... I hate it when that happens Mad

At least someone else feels worse now: parvinder was getting old & ugly while searching for a solution for two whole years!

Report message to a moderator

Previous Topic:	Registration of Discocverer report
Next Topic:	Problem with Multi parameter report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 20 07:01:28 CDT 2026