user id - user name on reports

george · 2004-12-21

hi

i have to make some reports.
i made a field to some tables 36,112, etc. the name was Contact - table relation ("User".id)

problem i´d like to change the "user".id to "user".name without modify the tables :=)

thanks for your answeres and sorry for my bad english!!!

Tim81 · 2004-12-21

What about a GET in the OnAfterGetRecord-Trigger? For example:

User.GET(Contact);

Then make a text box with SourceExpression = User.Name!

Arhontis · 2004-12-21

Remember that the table user keeps the Database logins. If you use windows authentication then you should query the windows logins table.

search for USERID and you will find alot of info.

Dean_Axon · 2004-12-21

Hi George,

Create a new field called "User Name" and create it as a flowfield.

Then use the lookup to the USER table ( or other sugestions as per Arhontis) based on the userid field.

If you then need to use this field in any reports etc. just call CALCFIELDS("User Name")

Regards,

Dean

Howdy, Stranger!

Quick Links

Categories

user id - user name on reports

Comments