Zero Value In Reports

Yahoo Archive
1
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/
>
>
>
2
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
3
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/
>
>
>
4
For report builder.

Thanks,

Gary