I am working on a report which needs to show the user's name. The user is the person who is generating the report. I think I need to get the user name from windows. How can I do it ? Do I need to call any Windows API?
Thanks for your quick response. The database I am reporting against doesn't support any sql expression. And I want to get the Windows user name not the dababase user name.
According to the FAQ mentioned above and articles in kbase, I created UDF successfully. Everything looks fine until I run the report. The formula contains the UDF show nothing on the report.
I tried your code for he SQL expression, but the version of CR I am using errors out when I execute the report. The SQL expression field itslef had no error when I checked it. I am using CR v8.5 professional, on a MS SQL Server 2000 database.
Any ideas? Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
After all, I created and called the UDF sucessfully. Thank you all for your help. The problem I encountered is caused by an error in the VB source code I copied from another website.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.