Excluding list of project statuses 1

[rji1124]

Hi.. we are on CR 9... I have a field named project.status that contains a number of choices, but I want to exclude 4 or 5 of those from appearing on the report. I seem to remember some type of statement to do this with like:
<table>project.status not in ["Scope","Production Pending"] - but I can't find any old examples...

Any help is greatly appreciated...
thanks

 

[Macho123]

goto. report->selectexpert and there you need to select you column and you can exclude what ever you want from that particular field.

Pk.

 

[rji1124]

Hi.. thanks I tried that - listed my 4 entries using "is not one of"... bit I get and invalid rowset message whenever I add more than one to the formula.. it does work in the group selection criteria though.. thanks for the tip

 

[lbass]

You could go to report->selection formula->record and enter:

Not({table.projectstatus} in ["Scope","Production Pending"])

-LB