Multiple filters can be used for the same report parameter by listing the filters seperated with a "," (comma).

For example to see only 'Bathroom Tiles' and "Door'  items in a Sales By Item Detail Report you do:

sp_report SalesByItemDetail show
Text, Blank, TxnType, Date, RefNumber, Memo, Name,
Quantity, UnitPrice, Amount, RunningBalance, Item
parameters DateMacro = 'All', itemfilterfullnames='Bathroom Tiles','Door'

or to see only 'Sales Income' and 'Construction Parts' accounts you do:

sp_report SalesByItemDetail show 
Text, Blank, TxnType, Date, RefNumber, Memo, Name,
Quantity, UnitPrice, Amount, RunningBalance, Account
parameters DateMacro = 'All', AccountFilterFullNames='Sales Income','Construction Parts'

Hi

I am trying to use the this method to filter on 2 different items in the same query.

It works fine with only item:

sp_report TxnDetailByAccount show TxnType, Date, RefNumber, AccountFullName, AccountName, AccountType, Account, Memo, Name, Amount parameters AccountFilterType = 'OrdinaryIncomeAndCOGS', DateMacro = 'LastMonth', ItemFilterFullNameWithChildren = 'SERVICES:Employed:BJ' where rowtype = 'DataRow'

But as soon as I add the second filter item, I get an error "Failed to open rowset.  Details: 42000:[QODBC] Expected lexical element not found: HARDWARE:Camera Systems".   If I reverse the order of the 2 items in the query, then the error is always on the second item.

sp_report TxnDetailByAccount show TxnType, Date, RefNumber, AccountFullName, AccountName, AccountType, Account, Memo, Name, Amount parameters AccountFilterType = 'OrdinaryIncomeAndCOGS', DateMacro = 'LastMonth', ItemFilterFullNameWithChildren = 'SERVICES:Employed:BJ' ,'HARDWARE:Camera Systems' where rowtype = 'DataRow'

What am I missing?

Thanks!

Not all parameters are multi-lookup. If you run the stored procedure for the report you are using:

sp_parameters TxnDetailByAccount

you will see what values can be used to filter reports.