Try an outer join to the partbin.
Patrick J. Winter
Information Services Manager
sSc Specialty Screw Corporation
Vantage 3.00.614, Progress 8.3A
From: Todd Hofert [mailto:thofert@...
Sent: Friday, August 11, 2000 06:18 AM
To: Vantage List (E-mail)
Subject: [Vantage] RB ? number 2
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?
Spartan Graphics, Inc.
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)