Thank you for the reply. The report closes on me because its to big when I change the drop down.. I try to filter by preferred vendor first then do that but it ...
Thank you everyone that worked.. The fields should just be blank be default in instead of having a zero value.. That would make more sense.. Then it would work ...