Hi All,

Getting a little lost with the format of the logic I need for a gridview.

I want it to show items if:

{Optional Amount 2} =1

And is in one of these report Groups:
{Report Group}="RPL"
{Report Group}="ERR"
{Report Group}="EXC"

Then also show items that still have an {Optional Amount 2} =1 and
{Qty On Hand} =0
And is in one of these report Groups:
{Report Group}="NLA"
{Report Group}="EOL"
{Report Group}="CLR"

I have been able to do one or the other, but I don't know how to combine both into one filter.

If you have Filter #1 working, and Filter # 2 working to your satisfaction, then use alt-F6 to open up the Filter Toolbox and combine the two working Filters using "OR" by clicking on the Filters until the "+" appears and selecting "New".

That worked perfect. Thank you.