Transaction history

Yahoo Archive
1
THANKS, WORKED GREAT!

Jasper

-----Original Message-----
From: ehahn@... [mailto:ehahn@...]
Sent: Friday, November 14, 2003 2:22 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Transaction history


Jasper,

You can filter for the person's user ID in the "EntryPerson" field of the
Transaction table. You shouldn't have to link to another table.

-Liz

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Friday, November 14, 2003 11:12 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Transaction history


I have been asked to create a report that tracks the activity of a user.
This user works in the Tool Crib and all they do is Issue and Return tools
and such. All they use is the issue/return module. All I would need to see
is the part transaction history BUT only ones that this person did. Is
there a way to link the Parttran table to another table that can give me
this information?

Thanks,

Jasper





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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12c87d2ou/M=243273.4156324.5364586.1261774/D=egroup
web/S=1705007183:HM/EXP=1068923499/A=1750744/R=0/*http://servedby.advertisin
g.com/click/site=552006/bnum=1068837099023242> Click to learn more...

<http://us.adserver.yahoo.com/l?M=243273.4156324.5364586.1261774/D=egroupmai
l/S=:HM/A=1750744/rand=193456688>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




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



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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
I have been asked to create a report that tracks the activity of a user. This user works in the Tool Crib and all they do is Issue and Return tools and such. All they use is the issue/return module. All I would need to see is the part transaction history BUT only ones that this person did. Is there a way to link the Parttran table to another table that can give me this information?

Thanks,

Jasper





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

You can filter for the person's user ID in the "EntryPerson" field of the
Transaction table. You shouldn't have to link to another table.

-Liz

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Friday, November 14, 2003 11:12 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Transaction history


I have been asked to create a report that tracks the activity of a user.
This user works in the Tool Crib and all they do is Issue and Return tools
and such. All they use is the issue/return module. All I would need to see
is the part transaction history BUT only ones that this person did. Is
there a way to link the Parttran table to another table that can give me
this information?

Thanks,

Jasper





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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12c87d2ou/M=243273.4156324.5364586.1261774/D=egroup
web/S=1705007183:HM/EXP=1068923499/A=1750744/R=0/*http://servedby.advertisin
g.com/click/site=552006/bnum=1068837099023242> Click to learn more...

<http://us.adserver.yahoo.com/l?M=243273.4156324.5364586.1261774/D=egroupmai
l/S=:HM/A=1750744/rand=193456688>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




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