# Zero Value In Reports **Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9) **Created:** 2001-03-15 09:29 UTC **Views:** 328 **Replies:** 3 **URL:** https://www.epiusers.help/t/zero-value-in-reports/2449 --- ## Post #1 by @system
Gary,
When you join the part table to the part bin table it needs to be a left
outer join not an inner join. This way the parts without any on hand will
still print but the quantity will be a ? for unknown value.

Jim Frice

> -----Original Message-----
> From: KRGENT@... [mailto:KRGENT@...]
> Sent: Thursday, March 15, 2001 5:39 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Zero Value In Reports
>
>
> For report builder.
>
> Thanks,
>
> Gary
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
--- ## Post #2 by @system
Good Afternoon Users,

What format or property needs to be changed in order to see a zero value for
quantity on hand ? The basic question is I want to see all items regardless
of quantity on hand.

Thanks,

Gary Waldman
KRG Enterprises
--- ## Post #3 by @system
For a canned vantage report or for a report builder report.

> -----Original Message-----
> From: KRGENT@... [mailto:KRGENT@...]
> Sent: Wednesday, March 14, 2001 12:38 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Zero Value In Reports
>
>
> Good Afternoon Users,
>
> What format or property needs to be changed in order to see a
> zero value for
> quantity on hand ? The basic question is I want to see all items
> regardless
> of quantity on hand.
>
> Thanks,
>
> Gary Waldman
> KRG Enterprises
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
--- ## Post #4 by @system
For report builder.

Thanks,

Gary
--- **Canonical:** https://www.epiusers.help/t/zero-value-in-reports/2449 **Original content:** https://www.epiusers.help/t/zero-value-in-reports/2449