Thanks all the left outer join did it.
In a report I am working on I have discovered that if an Item has no
detail info, all the group headers get supressed. Is there a work
around for this? In our pick list report, if there is no material in
stock, then there is no detail, and the whole record gets suppressed,
so a partnumber doesn't even print. Any ideas how to get around
this?
detail info, all the group headers get supressed. Is there a work
around for this? In our pick list report, if there is no material in
stock, then there is no detail, and the whole record gets suppressed,
so a partnumber doesn't even print. Any ideas how to get around
this?
On Mon, 2004-03-15 at 12:06, brentferland wrote:
either *force* something to be in that detail section and just suppress
it out or use subreports as your detail sections. The first option
might work well for you. I assume you are filtering the stock quantity
in the select expert? Remove this criteria and instead use conditional
suppression on the detail lines.
HTH,
--
Adam Ellis <aellis@...>
SaberLogic
> In a report I am working on I have discovered that if an Item has noNo easy workaround. AFAIK, the only way you can work around this is to
> detail info, all the group headers get supressed. Is there a work
> around for this? In our pick list report, if there is no material in
> stock, then there is no detail, and the whole record gets suppressed,
> so a partnumber doesn't even print. Any ideas how to get around
> this?
either *force* something to be in that detail section and just suppress
it out or use subreports as your detail sections. The first option
might work well for you. I assume you are filtering the stock quantity
in the select expert? Remove this criteria and instead use conditional
suppression on the detail lines.
HTH,
--
Adam Ellis <aellis@...>
SaberLogic
>is to
> No easy workaround. AFAIK, the only way you can work around this
> either *force* something to be in that detail section and justsuppress
> it out or use subreports as your detail sections. The first optionquantity
> might work well for you. I assume you are filtering the stock
> in the select expert? Remove this criteria and instead useconditional
> suppression on the detail lines.The detail in question is part of a subreport, so I can't put another
>
> HTH,
> --
> Adam Ellis <aellis@s...>
> SaberLogi
subreport in, and I thought about trying to force info to apear in
the detail, but the problem I have found, is that the table PARTBIN
deletes the part record when it has a zero on hand quantity. So I
gues my next question is if there is no crystal work around, is there
a table in vantage that has most of the same info as the PARTBIN
table?
Look at the PartWhse.OnHandQty field. Should be the summary for all the bins
in the warehouse, a step above reading all bin records for inventory totals.
You may have multiple warehouses though.
Patrick Winter
-----Original Message-----
From: Adam Ellis [mailto:aellis@...]
Sent: Monday, March 15, 2004 8:59 PM
To: Vantage Mailing List
Subject: Re: [Vantage] Crystal No Detail, No Header
in the warehouse, a step above reading all bin records for inventory totals.
You may have multiple warehouses though.
Patrick Winter
-----Original Message-----
From: Adam Ellis [mailto:aellis@...]
Sent: Monday, March 15, 2004 8:59 PM
To: Vantage Mailing List
Subject: Re: [Vantage] Crystal No Detail, No Header
On Mon, 2004-03-15 at 12:06, brentferland wrote:
> In a report I am working on I have discovered that if an Item has no
> detail info, all the group headers get supressed. Is there a work
> around for this? In our pick list report, if there is no material in
> stock, then there is no detail, and the whole record gets suppressed,
> so a partnumber doesn't even print. Any ideas how to get around this?
No easy workaround. AFAIK, the only way you can work around this is to
either *force* something to be in that detail section and just suppress it
out or use subreports as your detail sections. The first option might work
well for you. I assume you are filtering the stock quantity in the select
expert? Remove this criteria and instead use conditional suppression on the
detail lines.
HTH,
--
Adam Ellis <aellis@...>
SaberLogic
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
If I use the PARTWHSE I can get half the info I need but I can not
find a table that will print bin and lot numbers that doesn't delete
zero quantity records. So when I add fields from those tables to my
detail it wipes out the whole subreport if onhand quantity is zero,
regardless of the table I pull onhand quantity from. I have the BFH
ready as I am getting frustrated with this report. Any Ideas are
helpful.
find a table that will print bin and lot numbers that doesn't delete
zero quantity records. So when I add fields from those tables to my
detail it wipes out the whole subreport if onhand quantity is zero,
regardless of the table I pull onhand quantity from. I have the BFH
ready as I am getting frustrated with this report. Any Ideas are
helpful.
--- In vantage@yahoogroups.com, pjw@s... wrote:
> Look at the PartWhse.OnHandQty field. Should be the summary for all
the bins
> in the warehouse, a step above reading all bin records for
inventory totals.
> You may have multiple warehouses though.
>
>
> Patrick Winter
>
>
> -----Original Message-----
> From: Adam Ellis [mailto:aellis@s...]
> Sent: Monday, March 15, 2004 8:59 PM
> To: Vantage Mailing List
> Subject: Re: [Vantage] Crystal No Detail, No Header
>
> On Mon, 2004-03-15 at 12:06, brentferland wrote:
> > In a report I am working on I have discovered that if an Item has
no
> > detail info, all the group headers get supressed. Is there a
work
> > around for this? In our pick list report, if there is no
material in
> > stock, then there is no detail, and the whole record gets
suppressed,
> > so a partnumber doesn't even print. Any ideas how to get around
this?
>
> No easy workaround. AFAIK, the only way you can work around this
is to
> either *force* something to be in that detail section and just
suppress it
> out or use subreports as your detail sections. The first option
might work
> well for you. I assume you are filtering the stock quantity in the
select
> expert? Remove this criteria and instead use conditional
suppression on the
> detail lines.
>
> HTH,
> --
> Adam Ellis <aellis@s...>
> SaberLogic
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
In the Visual Linking Expert, try changing your join between
Part and Partbin to be a Left Outer Join. This will include
all the rows in the Part table on the report regardless if
they have a match in the Partbin Table. If you only want
purchased parts you'll also need to do a select on TypeCode
and limit it to "P".
Rebecca
-----Original Message-----
From: brentferland [mailto:brentferland@...]
Sent: Tuesday, March 16, 2004 1:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal No Detail, No Header
If I use the PARTWHSE I can get half the info I need but I can not
find a table that will print bin and lot numbers that doesn't delete
zero quantity records. So when I add fields from those tables to my
detail it wipes out the whole subreport if onhand quantity is zero,
regardless of the table I pull onhand quantity from. I have the BFH
ready as I am getting frustrated with this report. Any Ideas are
helpful.
Part and Partbin to be a Left Outer Join. This will include
all the rows in the Part table on the report regardless if
they have a match in the Partbin Table. If you only want
purchased parts you'll also need to do a select on TypeCode
and limit it to "P".
Rebecca
-----Original Message-----
From: brentferland [mailto:brentferland@...]
Sent: Tuesday, March 16, 2004 1:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal No Detail, No Header
If I use the PARTWHSE I can get half the info I need but I can not
find a table that will print bin and lot numbers that doesn't delete
zero quantity records. So when I add fields from those tables to my
detail it wipes out the whole subreport if onhand quantity is zero,
regardless of the table I pull onhand quantity from. I have the BFH
ready as I am getting frustrated with this report. Any Ideas are
helpful.
--- In vantage@yahoogroups.com, pjw@s... wrote:
> Look at the PartWhse.OnHandQty field. Should be the summary for all
the bins
> in the warehouse, a step above reading all bin records for
inventory totals.
> You may have multiple warehouses though.
>
>
> Patrick Winter
>
>
> -----Original Message-----
> From: Adam Ellis [mailto:aellis@s...]
> Sent: Monday, March 15, 2004 8:59 PM
> To: Vantage Mailing List
> Subject: Re: [Vantage] Crystal No Detail, No Header
>
> On Mon, 2004-03-15 at 12:06, brentferland wrote:
> > In a report I am working on I have discovered that if an Item has
no
> > detail info, all the group headers get supressed. Is there a
work
> > around for this? In our pick list report, if there is no
material in
> > stock, then there is no detail, and the whole record gets
suppressed,
> > so a partnumber doesn't even print. Any ideas how to get around
this?
>
> No easy workaround. AFAIK, the only way you can work around this
is to
> either *force* something to be in that detail section and just
suppress it
> out or use subreports as your detail sections. The first option
might work
> well for you. I assume you are filtering the stock quantity in the
select
> expert? Remove this criteria and instead use conditional
suppression on the
> detail lines.
>
> HTH,
> --
> Adam Ellis <aellis@s...>
> SaberLogic
Have you tried an outerjoin to also allow for missing records.
Patrick Winter
-----Original Message-----
From: brentferland [mailto:brentferland@...]
Sent: Tuesday, March 16, 2004 12:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal No Detail, No Header
If I use the PARTWHSE I can get half the info I need but I can not find a
table that will print bin and lot numbers that doesn't delete zero quantity
records. So when I add fields from those tables to my detail it wipes out
the whole subreport if onhand quantity is zero, regardless of the table I
pull onhand quantity from. I have the BFH ready as I am getting frustrated
with this report. Any Ideas are helpful.
Patrick Winter
-----Original Message-----
From: brentferland [mailto:brentferland@...]
Sent: Tuesday, March 16, 2004 12:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal No Detail, No Header
If I use the PARTWHSE I can get half the info I need but I can not find a
table that will print bin and lot numbers that doesn't delete zero quantity
records. So when I add fields from those tables to my detail it wipes out
the whole subreport if onhand quantity is zero, regardless of the table I
pull onhand quantity from. I have the BFH ready as I am getting frustrated
with this report. Any Ideas are helpful.
--- In vantage@yahoogroups.com, pjw@s... wrote:
> Look at the PartWhse.OnHandQty field. Should be the summary for all
the bins
> in the warehouse, a step above reading all bin records for
inventory totals.
> You may have multiple warehouses though.
>
>
> Patrick Winter
>
>
> -----Original Message-----
> From: Adam Ellis [mailto:aellis@s...]
> Sent: Monday, March 15, 2004 8:59 PM
> To: Vantage Mailing List
> Subject: Re: [Vantage] Crystal No Detail, No Header
>
> On Mon, 2004-03-15 at 12:06, brentferland wrote:
> > In a report I am working on I have discovered that if an Item has
no
> > detail info, all the group headers get supressed. Is there a
work
> > around for this? In our pick list report, if there is no
material in
> > stock, then there is no detail, and the whole record gets
suppressed,
> > so a partnumber doesn't even print. Any ideas how to get around
this?
>
> No easy workaround. AFAIK, the only way you can work around this
is to
> either *force* something to be in that detail section and just
suppress it
> out or use subreports as your detail sections. The first option
might work
> well for you. I assume you are filtering the stock quantity in the
select
> expert? Remove this criteria and instead use conditional
suppression on the
> detail lines.
>
> HTH,
> --
> Adam Ellis <aellis@s...>
> SaberLogic
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links