Wendy,
This is a pretty simple report. Start with the Part Table. Join that to
the PartBin table with a Left Outer Join. This will give you the inventory
for each part, in each bin. If there is a ? for a value, that means that
there
is no record in the Part Bin table (0 Inventory). Good Luck
Tim Care
Electro Chemical Finishing
This is a pretty simple report. Start with the Part Table. Join that to
the PartBin table with a Left Outer Join. This will give you the inventory
for each part, in each bin. If there is a ? for a value, that means that
there
is no record in the Part Bin table (0 Inventory). Good Luck
Tim Care
Electro Chemical Finishing
----- Original Message -----
From: "Wendy Bowen (Pursche)" <wpursche@...>
To: "Vantage egroups list" <vantage@egroups.com>
Sent: Monday, January 08, 2001 1:30 PM
Subject: [Vantage] Inventory w/bins report
> I know this has been asked before, so forgive me for the repetition! But,
does anyone have a Report Builder report that shows inventory status with
bins? I noticed a Crystal Report on the Egroups list, but unfortunately we
don't have a ODBC driver, so it needs to be a Report Builder report.
>
> Wendy Bowen (Pursche)