Re: Print boilerplate text when rows returned > 3

chrischaisson_at_hotmail.com (Chris E) wrote in message news:<b1c2e7fa.0309081219.10923fac_at_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. Received on Tue Sep 09 2003 - 11:03:51 CEST