Displaying username at runtime

[jcl5]

Hi

Running Crystal 9 and Oracle 9.

Is it possible to display the name of the user who runs the reports in the page footer.
I know I can prompt the user to enter their name at runtime but just wondered if there was anyway Crystal can do this from the network login.
I understand there is a system function for use within SQL Expression Fields but not sure how to use it - I think this might only give me the database username anyway.

Thanks

jcl5

 

[Turkbear]

Hi,
Oracle does not 'know' who is accessing it except for the database login name...The actual client machine can be determined but you would need some kind of lookup table that joins machine name to User..( Not likely to exist)..





To Paraphrase:"The Help you get is proportional to the Help you give.."