Re: Reports Builder 9i change boilerplate text dynamically?

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Fri, 4 Jun 2004 14:19:53 +0200
Message-ID: <2ib7u8Fkja2aU1_at_uni-berlin.de>


"Ladislav Ligart" <ligart_at_yahoo.com> schrieb im Newsbeitrag news:ed51c2ec.0405280732.4ab0864e_at_posting.google.com...
> Can the text of a boilerplate (text) object be changed dynamically at
> runtime? Say, in the Format Trigger?

A Format trigger only says "show it" or "hide it" due to some conditions.

Dynamic Texts in Boilerplates are AFAIK only possible using something like this:

BP text:
"The candidate &name won 100 points"

And &name is replaced at runtime with :name from the report query

SELECT
 ...
 name,
 ...
FROM winners;

Or it can also be a column placeholder :CP_Name or a column formula :CF_name.

"The candidate &CP_name won 100 points"
"The candidate &CF_name won 100 points"

One problem remains in the layout, when the text formattings change with the length of the :name.

hth,
Jan Received on Fri Jun 04 2004 - 14:19:53 CEST

Original text of this message