thanks for the info- I understand better. How do you make this work in Crystal Reports. I know how to declare variables and such but not sure how to embed the userid object to link to the employeeid or userid in the LaborHed and LaborDtl tables.
----- Original Message ----
From: Fons van der Beek <fons.vanderbeek@...>
To: vantage@yahoogroups.com
Sent: Wednesday, August 8, 2007 2:49:28 PM
Subject: Re: [Vantage] System Table- User id Logged in Field
The current user is defined in an object depending on what form you are
using
We are on 8.03G
on the laborentry form ther is an object called laborform.session. id
Dim [varName] As String = Labor.Form.Session. UserID
On the receiptEntry this object is:
Dim [varName] As String = ReceiptEntryForm. Session.UserID
dim CurrentUser as string
CurrentUser= Laborform. session.id
The current user is not in a table but it is an object...... ......
RSN schreef:
____________________________________________________________________________________
Need a vacation? Get great deals
to amazing places on Yahoo! Travel.
http://travel.yahoo.com/
[Non-text portions of this message have been removed]
----- Original Message ----
From: Fons van der Beek <fons.vanderbeek@...>
To: vantage@yahoogroups.com
Sent: Wednesday, August 8, 2007 2:49:28 PM
Subject: Re: [Vantage] System Table- User id Logged in Field
The current user is defined in an object depending on what form you are
using
We are on 8.03G
on the laborentry form ther is an object called laborform.session. id
Dim [varName] As String = Labor.Form.Session. UserID
On the receiptEntry this object is:
Dim [varName] As String = ReceiptEntryForm. Session.UserID
dim CurrentUser as string
CurrentUser= Laborform. session.id
The current user is not in a table but it is an object...... ......
RSN schreef:
> Fons[Non-text portions of this message have been removed]
> Could you explain this a bit more- I don't understand- Can you give me the table_name?
> CurrentUser =LaborForm.Session. UserID
> I dont see table LaborForm in another version of Vantage (We are on V800_811B)
> THX
> RSN
>
> ----- Original Message ----
> From: Fons van der Beek <fons.vanderbeek@ 84-it.com>
> To: vantage@yahoogroups .com
> Sent: Tuesday, August 7, 2007 2:55:30 PM
> Subject: Re: [Vantage] System Table- User id Logged in Field
>
> RSN schreef:
>
>> I may have seen this go by in the forum previously and I have forgotten the answer. I'm creating a custom "time-card" report (We don't have the payroll module only the MES module) so that each shop employee can look at their time reported thus far at any given time. I don't know if any other MES users/report wizs on teh forum have done anything like this before.
>> I would like to be able to limit the search to the employee id /user logged in currently.
>>
>>
> userid currently logged in
>
> CurrentUser = LaborForm.Session. UserID
> When using the laborform for creating the report.
>
>
>> Which table do I query in for the userid currently logged in and is there a way to join the Laborhed table to this table.
>> Thanks in advance for any suggestions.
>> RSN
>>
>>
>>
>> ____________ _________ _________ _________ _________ _________ _
>> Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool.
>> http://autos. yahoo.com/ carfinder/
>>
>> [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
>> Yahoo! Groups Links
>>
>>
>>
>>
>>
>
>
>
>
>
>
> ____________ _________ _________ _________ _________ _________ _
> Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool.
> http://autos. yahoo.com/ carfinder/
>
> [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
> Yahoo! Groups Links
>
>
>
>
____________________________________________________________________________________
Need a vacation? Get great deals
to amazing places on Yahoo! Travel.
http://travel.yahoo.com/
[Non-text portions of this message have been removed]