Home » Developer & Programmer » Reports & Discoverer » Space Utilisation
Space Utilisation [message #148557] Thu, 24 November 2005 23:43 Go to next message
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
Re: Space Utilisation [message #255039 is a reply to message #148557] Mon, 30 July 2007 08:28 Go to previous messageGo to next message
parvinder.infogen
Messages: 10
Registered: February 2007
Location: New Delhi
Junior Member

select the repeating frame and set vertical elasticity property to variable
Re: Space Utilisation [message #255046 is a reply to message #255039] Mon, 30 July 2007 08:46 Go to previous messageGo to next message
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).
Re: Space Utilisation [message #255100 is a reply to message #255046] Mon, 30 July 2007 11:09 Go to previous messageGo to next message
Littlefoot
Messages: 21813
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!
Re: Space Utilisation [message #255254 is a reply to message #255100] Tue, 31 July 2007 03:51 Go to previous message
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!
Previous Topic: Registration of Discocverer report
Next Topic: Problem with Multi parameter report
Goto Forum:
  


Current Time: Fri Jul 05 07:55:29 CDT 2024