There seem like there has got to be a better way to do this.

I have to create #7 reports, one for each type of business (New, replacement, service, ewo, prototype, requote, market test) and there is a query for each one, (if new = yes)

Any idea's?