RE: oracle digest: April 05, 2003
"Eric Raskin" <[email protected]> Sun, 6 Apr 2003 17:07:38 -0400
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Organization | Professional Advertising Systems Inc. |
| Message-ID | <LYRIS-1796914-941352-2003.04.06-22.03.58--gcdod-oracle#[email protected]> |
>I tried to solve this by changing the narration property i.e vertical
and
>horizontal to compress but still it showed blank/empty line in
previewer
>or taking hard copy.
I believe the proper way to do this is to:
1) Enclose the field with a frame -- the frame does not have to be
visible.
2) Make sure that the Elasticity properties on the frame are
"variable".
3) Put a Format Trigger on the frame -- this is a piece of code that
returns TRUE if the frame should be printed and false if it should not.
The code would look something like this:
BEGIN
IF :narration is null THEN
Return (FALSE);
ELSE
Return (TRUE);
END IF;
END;
This assumes that your data field is actually called "narration".
You might even be able to do this without the frame, by just putting the
format trigger on the narration field and setting the elasticity
properties to "variable".
Good luck!
------------------------------------------------------------------------
----
Eric H. Raskin Voice:
914-741-1100
President Fax:
914-741-2788
Professional Advertising Systems Inc.
[email protected]
70 Memorial Plaza
Pleasantville, NY 10570
---
---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to [email protected].