Adding Last Transaction Date on Stock Status Report

Yahoo Archive
1
--- In vantage@yahoogroups.com, "Elizabeth Hahn" <ehahn@...> wrote:
>Hi Liz,

I am using Crystal for this. The report is the original Stock Status
Report out of Vantage that I duplicated to add tables. I tried moving
the PartTran:TranDate field to the Group footer but the report came
up blank in a preview. I'll try it again, maybe I'm doing something
wrong.

Thanks again for your help.

Dave

> Hi Dave,
>
> I'm not sure how you have the report structured, but, if you put the
> transaction date from the PartTran table in the report footer, it
will
> only show the last date. Also if you put it in the report header,
it
> will only show the first transaction date. If you have groups, you
> would need to put it in the group footer. I was assuming you were
using
> Crystal, but now that I re-read your first post, you didn't say
that.
>
> Liz
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Dave Eaton
> Sent: Wednesday, February 04, 2009 12:11 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Adding Last Transaction Date on Stock Status
> Report.
>
>
>
> Liz,
>
> I'm not sure I understand how that would work. Can you explian in a
> little more detail? Thanks for your help.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Elizabeth Hahn" <ehahn@> wrote:
> >
> > You can also put the transaction date in the footer of the
report,
> it
> > should only show the last date.
> >
> > Liz
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ] On
> Behalf
> > Of Jeff Stockard
> > Sent: Wednesday, February 04, 2009 10:03 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] Re: Adding Last Transaction Date on Stock
> Status
> > Report.
> >
> >
> >
> > Have you tried reversing your link? If the Parent table is Part
and
> the
> > Child Table is PartTran, try making it the other way around.
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%
> 40yahoogroups.com> ] On
> > Behalf Of
> > Lynn
> > Sent: Wednesday, February 04, 2009 12:24 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Adding Last Transaction Date on Stock
Status
> > Report.
> >
> > I see what you mean. It doesn't seem to matter if you put First,
> > Each, or Last. The resultant dataset still returns all records
from
> > the PartTran table.
> >
> > I am also at a loss.
> >
> > Lynn
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> , "Dave
> > Eaton" <deaton@> wrote:
> > >
> > > I tried the "last" option in the relationship but it's still
> > showing
> > > all transaction dates instead of just the last transaction
date.
> We
> > > don't use Lot Tracking so that's not an option. Any other
> > > suggestions? I'm really stuck at this point.
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> , "Lynn"
> > <lynn.khalife@> wrote:
> > > >
> > > > Try this:
> > > >
> > > > When you add your Relationships for the PartTran table, go to
> the
> > > > Relationships--List tab (as opposed to the Relationships--
> Detail
> > > tab)
> > > > and find the column titled "Which Item" and type Last.
> > > >
> > > > Refer to the following information pasted here from the
Vantage
> > > Help
> > > > on the "Which Item" column:
> > > >
> > > > Which Item
> > > > The individual table records from which you will pull data.
> There
> > > are
> > > > three options you can enter in this field:
> > > >
> > > > Each - All the table records will be pulled through this
> > > relationship.
> > > >
> > > > First - Only the first table record will be pulled through
this
> > > > relationship.
> > > >
> > > > Last - Only the last table record will be pulled through this
> > > > relationship.
> > > >
> > > > Lynn
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com>
> <mailto:vantage%
> 40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ,
> > "Dave Eaton" <deaton@> wrote:
> > > > >
> > > > > I'm trying to show the last transaction date on the Stock
> > Status
> > > > Report
> > > > > but I can't seem to find the field that displays it. So far
> > I've
> > > > added
> > > > > the PartTrans table to the report and add the TransDate
field
> > in
> > > > the
> > > > > report but it shows all transaction dates for each part
(huge
> > > > report).
> > > > > What can I do to show only the last transaction date for a
> part?
> > > > >
> > > > > Thanks in advance for your help.
> > > > >
> > > > > Dave
> > > > >
> > > >
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
I'm trying to show the last transaction date on the Stock Status Report
but I can't seem to find the field that displays it. So far I've added
the PartTrans table to the report and add the TransDate field in the
report but it shows all transaction dates for each part (huge report).
What can I do to show only the last transaction date for a part?

Thanks in advance for your help.

Dave
3
Try this:

When you add your Relationships for the PartTran table, go to the
Relationships--List tab (as opposed to the Relationships--Detail tab)
and find the column titled "Which Item" and type Last.

Refer to the following information pasted here from the Vantage Help
on the "Which Item" column:

Which Item
The individual table records from which you will pull data. There are
three options you can enter in this field:

Each - All the table records will be pulled through this relationship.

First - Only the first table record will be pulled through this
relationship.

Last - Only the last table record will be pulled through this
relationship.

Lynn

--- In vantage@yahoogroups.com, "Dave Eaton" <deaton@...> wrote:
>
> I'm trying to show the last transaction date on the Stock Status
Report
> but I can't seem to find the field that displays it. So far I've
added
> the PartTrans table to the report and add the TransDate field in
the
> report but it shows all transaction dates for each part (huge
report).
> What can I do to show only the last transaction date for a part?
>
> Thanks in advance for your help.
>
> Dave
>
4
I tried the "last" option in the relationship but it's still showing
all transaction dates instead of just the last transaction date. We
don't use Lot Tracking so that's not an option. Any other
suggestions? I'm really stuck at this point.

--- In vantage@yahoogroups.com, "Lynn" <lynn.khalife@...> wrote:
>
> Try this:
>
> When you add your Relationships for the PartTran table, go to the
> Relationships--List tab (as opposed to the Relationships--Detail
tab)
> and find the column titled "Which Item" and type Last.
>
> Refer to the following information pasted here from the Vantage
Help
> on the "Which Item" column:
>
> Which Item
> The individual table records from which you will pull data. There
are
> three options you can enter in this field:
>
> Each - All the table records will be pulled through this
relationship.
>
> First - Only the first table record will be pulled through this
> relationship.
>
> Last - Only the last table record will be pulled through this
> relationship.
>
> Lynn
>
> --- In vantage@yahoogroups.com, "Dave Eaton" <deaton@> wrote:
> >
> > I'm trying to show the last transaction date on the Stock Status
> Report
> > but I can't seem to find the field that displays it. So far I've
> added
> > the PartTrans table to the report and add the TransDate field in
> the
> > report but it shows all transaction dates for each part (huge
> report).
> > What can I do to show only the last transaction date for a part?
> >
> > Thanks in advance for your help.
> >
> > Dave
> >
>
5
I see what you mean. It doesn't seem to matter if you put First,
Each, or Last. The resultant dataset still returns all records from
the PartTran table.

I am also at a loss.

Lynn


--- In vantage@yahoogroups.com, "Dave Eaton" <deaton@...> wrote:
>
> I tried the "last" option in the relationship but it's still
showing
> all transaction dates instead of just the last transaction date. We
> don't use Lot Tracking so that's not an option. Any other
> suggestions? I'm really stuck at this point.
>
> --- In vantage@yahoogroups.com, "Lynn" <lynn.khalife@> wrote:
> >
> > Try this:
> >
> > When you add your Relationships for the PartTran table, go to the
> > Relationships--List tab (as opposed to the Relationships--Detail
> tab)
> > and find the column titled "Which Item" and type Last.
> >
> > Refer to the following information pasted here from the Vantage
> Help
> > on the "Which Item" column:
> >
> > Which Item
> > The individual table records from which you will pull data. There
> are
> > three options you can enter in this field:
> >
> > Each - All the table records will be pulled through this
> relationship.
> >
> > First - Only the first table record will be pulled through this
> > relationship.
> >
> > Last - Only the last table record will be pulled through this
> > relationship.
> >
> > Lynn
> >
> > --- In vantage@yahoogroups.com, "Dave Eaton" <deaton@> wrote:
> > >
> > > I'm trying to show the last transaction date on the Stock
Status
> > Report
> > > but I can't seem to find the field that displays it. So far
I've
> > added
> > > the PartTrans table to the report and add the TransDate field
in
> > the
> > > report but it shows all transaction dates for each part (huge
> > report).
> > > What can I do to show only the last transaction date for a part?
> > >
> > > Thanks in advance for your help.
> > >
> > > Dave
> > >
> >
>
6
Have you tried reversing your link? If the Parent table is Part and the
Child Table is PartTran, try making it the other way around.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Lynn
Sent: Wednesday, February 04, 2009 12:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Adding Last Transaction Date on Stock Status Report.



I see what you mean. It doesn't seem to matter if you put First,
Each, or Last. The resultant dataset still returns all records from
the PartTran table.

I am also at a loss.

Lynn

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Dave
Eaton" <deaton@...> wrote:
>
> I tried the "last" option in the relationship but it's still
showing
> all transaction dates instead of just the last transaction date. We
> don't use Lot Tracking so that's not an option. Any other
> suggestions? I'm really stuck at this point.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Lynn"
<lynn.khalife@> wrote:
> >
> > Try this:
> >
> > When you add your Relationships for the PartTran table, go to the
> > Relationships--List tab (as opposed to the Relationships--Detail
> tab)
> > and find the column titled "Which Item" and type Last.
> >
> > Refer to the following information pasted here from the Vantage
> Help
> > on the "Which Item" column:
> >
> > Which Item
> > The individual table records from which you will pull data. There
> are
> > three options you can enter in this field:
> >
> > Each - All the table records will be pulled through this
> relationship.
> >
> > First - Only the first table record will be pulled through this
> > relationship.
> >
> > Last - Only the last table record will be pulled through this
> > relationship.
> >
> > Lynn
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Dave Eaton" <deaton@> wrote:
> > >
> > > I'm trying to show the last transaction date on the Stock
Status
> > Report
> > > but I can't seem to find the field that displays it. So far
I've
> > added
> > > the PartTrans table to the report and add the TransDate field
in
> > the
> > > report but it shows all transaction dates for each part (huge
> > report).
> > > What can I do to show only the last transaction date for a part?
> > >
> > > Thanks in advance for your help.
> > >
> > > Dave
> > >
> >
>





[Non-text portions of this message have been removed]
7
You can also put the transaction date in the footer of the report, it
should only show the last date.

Liz


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jeff Stockard
Sent: Wednesday, February 04, 2009 10:03 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Adding Last Transaction Date on Stock Status
Report.



Have you tried reversing your link? If the Parent table is Part and the
Child Table is PartTran, try making it the other way around.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Lynn
Sent: Wednesday, February 04, 2009 12:24 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Adding Last Transaction Date on Stock Status
Report.

I see what you mean. It doesn't seem to matter if you put First,
Each, or Last. The resultant dataset still returns all records from
the PartTran table.

I am also at a loss.

Lynn

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> , "Dave
Eaton" <deaton@...> wrote:
>
> I tried the "last" option in the relationship but it's still
showing
> all transaction dates instead of just the last transaction date. We
> don't use Lot Tracking so that's not an option. Any other
> suggestions? I'm really stuck at this point.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> , "Lynn"
<lynn.khalife@> wrote:
> >
> > Try this:
> >
> > When you add your Relationships for the PartTran table, go to the
> > Relationships--List tab (as opposed to the Relationships--Detail
> tab)
> > and find the column titled "Which Item" and type Last.
> >
> > Refer to the following information pasted here from the Vantage
> Help
> > on the "Which Item" column:
> >
> > Which Item
> > The individual table records from which you will pull data. There
> are
> > three options you can enter in this field:
> >
> > Each - All the table records will be pulled through this
> relationship.
> >
> > First - Only the first table record will be pulled through this
> > relationship.
> >
> > Last - Only the last table record will be pulled through this
> > relationship.
> >
> > Lynn
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"Dave Eaton" <deaton@> wrote:
> > >
> > > I'm trying to show the last transaction date on the Stock
Status
> > Report
> > > but I can't seem to find the field that displays it. So far
I've
> > added
> > > the PartTrans table to the report and add the TransDate field
in
> > the
> > > report but it shows all transaction dates for each part (huge
> > report).
> > > What can I do to show only the last transaction date for a part?
> > >
> > > Thanks in advance for your help.
> > >
> > > Dave
> > >
> >
>

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
8
The Part table is part of the original report so I can not be made a
child table. I can only make tables that I added child tables.

Thanks for the suggestion.


--- In vantage@yahoogroups.com, "Jeff Stockard" <jeff.stockard@...>
wrote:
>
> Have you tried reversing your link? If the Parent table is Part
and the
> Child Table is PartTran, try making it the other way around.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Lynn
> Sent: Wednesday, February 04, 2009 12:24 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Adding Last Transaction Date on Stock Status
Report.
>
>
>
> I see what you mean. It doesn't seem to matter if you put First,
> Each, or Last. The resultant dataset still returns all records from
> the PartTran table.
>
> I am also at a loss.
>
> Lynn
>
> --- In vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> , "Dave
> Eaton" <deaton@> wrote:
> >
> > I tried the "last" option in the relationship but it's still
> showing
> > all transaction dates instead of just the last transaction date.
We
> > don't use Lot Tracking so that's not an option. Any other
> > suggestions? I'm really stuck at this point.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> , "Lynn"
> <lynn.khalife@> wrote:
> > >
> > > Try this:
> > >
> > > When you add your Relationships for the PartTran table, go to
the
> > > Relationships--List tab (as opposed to the Relationships--
Detail
> > tab)
> > > and find the column titled "Which Item" and type Last.
> > >
> > > Refer to the following information pasted here from the Vantage
> > Help
> > > on the "Which Item" column:
> > >
> > > Which Item
> > > The individual table records from which you will pull data.
There
> > are
> > > three options you can enter in this field:
> > >
> > > Each - All the table records will be pulled through this
> > relationship.
> > >
> > > First - Only the first table record will be pulled through this
> > > relationship.
> > >
> > > Last - Only the last table record will be pulled through this
> > > relationship.
> > >
> > > Lynn
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ,
> "Dave Eaton" <deaton@> wrote:
> > > >
> > > > I'm trying to show the last transaction date on the Stock
> Status
> > > Report
> > > > but I can't seem to find the field that displays it. So far
> I've
> > > added
> > > > the PartTrans table to the report and add the TransDate field
> in
> > > the
> > > > report but it shows all transaction dates for each part (huge
> > > report).
> > > > What can I do to show only the last transaction date for a
part?
> > > >
> > > > Thanks in advance for your help.
> > > >
> > > > Dave
> > > >
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
9
Liz,

I'm not sure I understand how that would work. Can you explian in a
little more detail? Thanks for your help.

--- In vantage@yahoogroups.com, "Elizabeth Hahn" <ehahn@...> wrote:
>
> You can also put the transaction date in the footer of the report,
it
> should only show the last date.
>
> Liz
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Jeff Stockard
> Sent: Wednesday, February 04, 2009 10:03 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Adding Last Transaction Date on Stock
Status
> Report.
>
>
>
> Have you tried reversing your link? If the Parent table is Part and
the
> Child Table is PartTran, try making it the other way around.
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ] On
> Behalf Of
> Lynn
> Sent: Wednesday, February 04, 2009 12:24 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Adding Last Transaction Date on Stock Status
> Report.
>
> I see what you mean. It doesn't seem to matter if you put First,
> Each, or Last. The resultant dataset still returns all records from
> the PartTran table.
>
> I am also at a loss.
>
> Lynn
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> , "Dave
> Eaton" <deaton@> wrote:
> >
> > I tried the "last" option in the relationship but it's still
> showing
> > all transaction dates instead of just the last transaction date.
We
> > don't use Lot Tracking so that's not an option. Any other
> > suggestions? I'm really stuck at this point.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> , "Lynn"
> <lynn.khalife@> wrote:
> > >
> > > Try this:
> > >
> > > When you add your Relationships for the PartTran table, go to
the
> > > Relationships--List tab (as opposed to the Relationships--
Detail
> > tab)
> > > and find the column titled "Which Item" and type Last.
> > >
> > > Refer to the following information pasted here from the Vantage
> > Help
> > > on the "Which Item" column:
> > >
> > > Which Item
> > > The individual table records from which you will pull data.
There
> > are
> > > three options you can enter in this field:
> > >
> > > Each - All the table records will be pulled through this
> > relationship.
> > >
> > > First - Only the first table record will be pulled through this
> > > relationship.
> > >
> > > Last - Only the last table record will be pulled through this
> > > relationship.
> > >
> > > Lynn
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> "Dave Eaton" <deaton@> wrote:
> > > >
> > > > I'm trying to show the last transaction date on the Stock
> Status
> > > Report
> > > > but I can't seem to find the field that displays it. So far
> I've
> > > added
> > > > the PartTrans table to the report and add the TransDate field
> in
> > > the
> > > > report but it shows all transaction dates for each part (huge
> > > report).
> > > > What can I do to show only the last transaction date for a
part?
> > > >
> > > > Thanks in advance for your help.
> > > >
> > > > Dave
> > > >
> > >
> >
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
10
Hi Dave,

I'm not sure how you have the report structured, but, if you put the
transaction date from the PartTran table in the report footer, it will
only show the last date. Also if you put it in the report header, it
will only show the first transaction date. If you have groups, you
would need to put it in the group footer. I was assuming you were using
Crystal, but now that I re-read your first post, you didn't say that.

Liz


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dave Eaton
Sent: Wednesday, February 04, 2009 12:11 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Adding Last Transaction Date on Stock Status
Report.



Liz,

I'm not sure I understand how that would work. Can you explian in a
little more detail? Thanks for your help.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Elizabeth Hahn" <ehahn@...> wrote:
>
> You can also put the transaction date in the footer of the report,
it
> should only show the last date.
>
> Liz
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Jeff Stockard
> Sent: Wednesday, February 04, 2009 10:03 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Re: Adding Last Transaction Date on Stock
Status
> Report.
>
>
>
> Have you tried reversing your link? If the Parent table is Part and
the
> Child Table is PartTran, try making it the other way around.
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%
40yahoogroups.com> ] On
> Behalf Of
> Lynn
> Sent: Wednesday, February 04, 2009 12:24 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Adding Last Transaction Date on Stock Status
> Report.
>
> I see what you mean. It doesn't seem to matter if you put First,
> Each, or Last. The resultant dataset still returns all records from
> the PartTran table.
>
> I am also at a loss.
>
> Lynn
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> , "Dave
> Eaton" <deaton@> wrote:
> >
> > I tried the "last" option in the relationship but it's still
> showing
> > all transaction dates instead of just the last transaction date.
We
> > don't use Lot Tracking so that's not an option. Any other
> > suggestions? I'm really stuck at this point.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> , "Lynn"
> <lynn.khalife@> wrote:
> > >
> > > Try this:
> > >
> > > When you add your Relationships for the PartTran table, go to
the
> > > Relationships--List tab (as opposed to the Relationships--
Detail
> > tab)
> > > and find the column titled "Which Item" and type Last.
> > >
> > > Refer to the following information pasted here from the Vantage
> > Help
> > > on the "Which Item" column:
> > >
> > > Which Item
> > > The individual table records from which you will pull data.
There
> > are
> > > three options you can enter in this field:
> > >
> > > Each - All the table records will be pulled through this
> > relationship.
> > >
> > > First - Only the first table record will be pulled through this
> > > relationship.
> > >
> > > Last - Only the last table record will be pulled through this
> > > relationship.
> > >
> > > Lynn
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%
40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> "Dave Eaton" <deaton@> wrote:
> > > >
> > > > I'm trying to show the last transaction date on the Stock
> Status
> > > Report
> > > > but I can't seem to find the field that displays it. So far
> I've
> > > added
> > > > the PartTrans table to the report and add the TransDate field
> in
> > > the
> > > > report but it shows all transaction dates for each part (huge
> > > report).
> > > > What can I do to show only the last transaction date for a
part?
> > > >
> > > > Thanks in advance for your help.
> > > >
> > > > Dave
> > > >
> > >
> >
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>






[Non-text portions of this message have been removed]