I replaced the date field with the itemtype field which is the 0 and 3's then I added a formula field which is to the left of the itemtype. I had the formula in the itemtype field so it would exclude the FALSE detail line but it did not do it.

Your stement is correct the FALSE should be excluded from the report. I'm not familiar with SQL I've never worked with this stuff I had this project dumped on me. This does make sense to me as to why it should work. I meant I kept the formula {wrkitem.itemtype} = 0 in the select expert at the time of the screen shot so you knew that the formula should have been excluding the FALSE line. I'm going to continue to tinker around if you think of anything let me know, I appreciate it.

A word of caution. The section expert does not "remove" anything from the report it, just hides it which is a critical difference when it comes to doing calculations s hidden data is still included in that unless you exclude it using variable formulas or running totals.
You can remove groups of data from the report using select expert set to group conditions with statements that refer to a group summary.

Edited by DBlank - 16 May 2012 at 2:09pm