OraFAQ Forum: Reports & Discoverer » Format Trigger making use of variable list generated from Formula Column

Home » Developer & Programmer » Reports & Discoverer » Format Trigger making use of variable list generated from Formula Column

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Format Trigger making use of variable list generated from Formula Column [message #153174]

Thu, 29 December 2005 12:44

Steve Corey
Messages: 336
Registered: February 2005
Location: RI

Senior Member

Hello.

I have written a function that compares two sets of data and assigns an identifier to a string variable if a discrepancy exists between the two data sets. I used cursors to define the two data sets and then LOOPED through the records. When a discrepency is hit, the ID of the person is sent to a string variable. I also have a loop that appends to this string variable, making use of comma delimitors to segregate the ID's. My question is now that I have this listing, how can I use it to suppress a frame in the report?

For example, if my variable holds the values:
1234, 5678, 9012, 3456

How can I reference that in the format trigger of the boilerplate text or repeating frame to suppress those people from being shown? I was thinking maybe something like this for a format trigger:

IF :ID IN :FORMULA_COLUMN_NAME.id_str_variable THEN
 return (FALSE);
ELSE
 return (TRUE);
END IF;

I don't believe this is valid syntax as builder's compiler spews out a invalid reference error. Is there any way I can use my existing logic to achieve my goal?

Thanks!

Regards,
Steve

[Updated on: Thu, 29 December 2005 12:50]

Report message to a moderator