Print boilerplate text when rows returned > 3

[Chris E]

Hi,
I need boiler plate text to print when the rows returned from either
one of my 2 repeating groups is > 3. Both repeating groups are
filtered to return only the first three rows. When either repeating
group row count is > than 3 my boilerplate should print. How is this
best done?

Both repeating groups are using the same table, looking for different
data.
I'm using reports 6i. Maybe I'm doing this all wrong?

[Frans H.]

chrischaisson@hotmail.com (Chris E) wrote in message news:<b1c2e7fa.0309081219.10923fac@posting.google.com>... Hi, I need boiler plate text to print when the rows returned from either one of my 2 repeating groups is > 3. Both repeating groups are filtered to return only the first three rows. When either repeating group row count is > than 3 my boilerplate should print. How is this best done? Both repeating groups are using the same table, looking for different data. I'm using reports 6i. Maybe I'm doing this all wrong?

Chris,
you will probably need a format-trigger. Create the boilerplate text
en attach a format trigger to it. In the format trigger you can
perform the queries and see how many records they return. Depending on
the number of records you can let the trigger return TRUE (show the
text) or FALSE (don't show the text).

hth,
Frans H.