# RB ? number 2

**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2000-08-11 07:21 UTC
**Views:** 467
**Replies:** 0
**URL:** https://www.epiusers.help/t/rb-number-2/744

---

## Post #1 by @system

<div id="ygrps-yiv-1617891139">Good Morning,<br/>
<br/>
Yesterday I asked the question how to grab certain part numbers (my 60&quot; wide<br/>
rolls) on a report builder report. I got some good suggestions and got past<br/>
that hurdle. Now I am faced with a new challenge; I am using the Part table<br/>
and the PartBin table to show me how much of each of these products I have<br/>
in stock. I am grouping and sorting by Part Number and everything is cool<br/>
except I cannot get the report to show parts with zero on hand. I think<br/>
because I am looking at the partbin table for on hand quantity and the data<br/>
dictionary states that when a partbin record hits zero it gets deleted. How<br/>
can I get zero on hand items on the report?<br/>
<br/>
Thanks Again<br/>
Todd Hofert<br/>
Spartan Graphics, Inc.<br/>
(616)887-8243</div>

---


**Canonical:** https://www.epiusers.help/t/rb-number-2/744
**Original content:** https://www.epiusers.help/t/rb-number-2/744