Help with selection record formula

[QuietRiot]

Right now I have this and it works fine:

if isdate({?TradeDate})=true then datevalue({FundTransactionLines.TradeDate}) >= DateValue({?TradeDate}) and
{FundTransactionLines.FundTransactionSource} = 10 and {FundTransactionTypes.TransactionTypeName} <> "Transfer Purchase" and
{FundTransactionTypes.TransactionTypeName} <> "Transfer Redemption" and
{FundTransactionLines.FundTransactionStatus} < 3

but now i need it so FundTransactionSource is either 10, 1, 2, or 8
and TransactionTypeName is equal to either Dealer Redemption, Dealer purchase, Purchase, Redemption

when I attempt to add OR's it messes my report up and the trade date is anything and not my paramater

any help Thanks,

 

[Kempes]

Try this.

if isdate({?TradeDate})=true then datevalue({FundTransactionLines.TradeDate}) >= DateValue({?TradeDate}) and
not ({FundTransactionLines.FundTransactionSource} in [10,1,2,8]) and
{FundTransactionTypes.TransactionTypeName} in ["Dealer Redemption", "Dealer purchase", "Purchase", "Redemption"] and
{FundTransactionLines.FundTransactionStatus} < 3

 

[QuietRiot]

Thanks kempes

it wasn't actually my selection formula afterall. it was the fact that I had inner joins and needed lefts