Static Filter

[gatorfe]

We have a report that has filter setup to only show record types of a certain kind.  The syntax is [Record Type] in ('1','2','5'). Attached is a pic.  The user is asking that it only show the Record Type  of '5' when the company is 100.  We have several companies in the data, 100, 200, and 300.  So for Record Type '1' and '2' any company is ok but for Record Type '5' it should show the records for only company 100.  How do we do this?  Thank you in advance for your suggestions!

[Lynn]

Maybe something like this:

Code Select Expand


(
  [Company Code] = 100
  and
  [Record Type] in ( '1','2','5' )
)
or
(
  [Company Code] <> 100
  and
  [Record Type] in ( '1','2' )
)


[gatorfe]

Thank you Lynn!  That worked perfectly!