RB ? number 2

Good Morning,

Yesterday I asked the question how to grab certain part numbers (my 60" wide
rolls) on a report builder report. I got some good suggestions and got past
that hurdle. Now I am faced with a new challenge; I am using the Part table
and the PartBin table to show me how much of each of these products I have
in stock. I am grouping and sorting by Part Number and everything is cool
except I cannot get the report to show parts with zero on hand. I think
because I am looking at the partbin table for on hand quantity and the data
dictionary states that when a partbin record hits zero it gets deleted. How
can I get zero on hand items on the report?

Thanks Again
Todd Hofert
Spartan Graphics, Inc.