Report Builder Help: 0 on hand qty records

Yahoo Archive
1
If you are using report builder, join the part bin table
to the part table with a left outer join. If the onhand
qty is 0, you will get a question mark in the onhand field.
You can also format the field to show unknown values
as 0, instead of ? Hope this helps, if you have any other
questions, let me know.

Tim Care
Electro Chemical Finishing
----- Original Message -----
From: "Juliet Martin" <jmartin@...>
To: <vantage@egroups.com>
Sent: Wednesday, November 15, 2000 3:55 PM
Subject: [Vantage] Report Builder Help: 0 on hand qty records


> I am trying to work with a Usage report using the Part table joined to
> the PartBin Table. I can't get any 0 on hand qty records. I found the
> following in my Onelist archives (SEE BELLOW). This is from 9/22/00.
> Has anyone found an answer to this?
>
> Juliet Martin
> Rosenboom Machine & Tool, Inc.
> www.rosenboom.com
> ************************************************************************
> ******************
> We just worked with Vantage support concerning the issue of receiving 0
> onhand qty for another report and this was the response:
> Unfortunately, a part number has to have a least 1 in its quantity to be
> able to pull info for a report. Report cannot be run. Best way to
> simulate

...<snip....>.....
2
I am trying to work with a Usage report using the Part table joined to
the PartBin Table. I can't get any 0 on hand qty records. I found the
following in my Onelist archives (SEE BELLOW). This is from 9/22/00.
Has anyone found an answer to this?

Juliet Martin
Rosenboom Machine & Tool, Inc.
www.rosenboom.com
************************************************************************
******************
We just worked with Vantage support concerning the issue of receiving 0
onhand qty for another report and this was the response:
Unfortunately, a part number has to have a least 1 in its quantity to be
able to pull info for a report. Report cannot be run. Best way to
simulate
is to run a report of all inventory, also run a report of inventory with
qtys on hand and compare the two.
Hope this helps! We thought we were over looking something simple also!
If
anyone knows some way to get that answer, please pass it on.

Kimberly Maxwell
Westwood Precision, Inc.
PH: 425-347-1303 Ext. 41
Fax: 425-353-8945
email: kimberly.maxwell@...
3
Are you working in Report Builder, Crystal or Progress 4gl?

Juliet Martin wrote:

> I am trying to work with a Usage report using the Part table joined to
> the PartBin Table. I can't get any 0 on hand qty records. I found the
> following in my Onelist archives (SEE BELLOW). This is from 9/22/00.
> Has anyone found an answer to this?
>
> Juliet Martin
> Rosenboom Machine & Tool, Inc.
> www.rosenboom.com
> ************************************************************************
> ******************
> We just worked with Vantage support concerning the issue of receiving 0
> onhand qty for another report and this was the response:
> Unfortunately, a part number has to have a least 1 in its quantity to be
> able to pull info for a report. Report cannot be run. Best way to
> simulate
> is to run a report of all inventory, also run a report of inventory with
> qtys on hand and compare the two.
> Hope this helps! We thought we were over looking something simple also!
> If
> anyone knows some way to get that answer, please pass it on.
>
> Kimberly Maxwell
> Westwood Precision, Inc.
> PH: 425-347-1303 Ext. 41
> Fax: 425-353-8945
> email: kimberly.maxwell@...
>
>
> 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.)

--
/* ============================================================== */

William E. Colls Tel 613 591 0079
PROComputer Systems Fax 613 591 3924
67 Willow Glen Dr www.procomsys.com
Kanata Ontario Canada PEG Member 1998051404

Specialists in Progress Software development since 1985
4
Not sure exactly what you are looking for. But if you use a left
outer join you will see all part records even if a partbin does not
exist. You can display the unknowns as a zero.

Juliet Martin wrote:
>
> I am trying to work with a Usage report using the Part table joined to
> the PartBin Table. I can't get any 0 on hand qty records. I found the
> following in my Onelist archives (SEE BELLOW). This is from 9/22/00.
> Has anyone found an answer to this?
>
> Juliet Martin
> Rosenboom Machine & Tool, Inc.
> www.rosenboom.com
> ************************************************************************
> ******************
> We just worked with Vantage support concerning the issue of receiving 0
> onhand qty for another report and this was the response:
> Unfortunately, a part number has to have a least 1 in its quantity to be
> able to pull info for a report. Report cannot be run. Best way to
> simulate
> is to run a report of all inventory, also run a report of inventory with
> qtys on hand and compare the two.
> Hope this helps! We thought we were over looking something simple also!
> If
> anyone knows some way to get that answer, please pass it on.
>
> Kimberly Maxwell
> Westwood Precision, Inc.
> PH: 425-347-1303 Ext. 41
> Fax: 425-353-8945
> email: kimberly.maxwell@...