Excluding Records From Report

[maulanday]

What if I want to exclude multiple records from a report? I know I have to attach it to a button. I want to exclude records that have the project status as finished. However, I have a container field that corresponds with the project status field. For example, when the field says "finished" the container field becomes gray. So, how can I exclude the container field color gray and the project status "finished" from my report?

Sorry, it was a long question.

[Breezer]

don't worry about the container field, simply add an OMIT script step to your script to omit records where status is "finished"

[maulanday]

Thank you Breezer, I got it. Do you know how I can omit records from a portal.

[Søren Dyhr]

Do you know how I can omit records from a portal.

I can't help feeling you're doublepositing here, but in general are there two methods either a multicriteria relationship or straining ID's from a multilinekey.

The later can neatly be done by this custom function:

http://www.briandunning.com/cf/39

--sd