Can you pass a NT Login name into a report

[FloridaHawk]

Is there a way I can pass a NT login name into a report. I want the report to run for each specific user so they wont have to enter their loging name into a parameter (this would allow each person to view other people's data) Any ideas would be helpfull

 

[rosemaryl]

Dear FloridaHawk,

What database? If this is SQL Server and you require them to login to run the report you could use a SQL Expression:

{fn USER()}

This returns the name the user logged into the database with.

ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[FloridaHawk]

Thanks Rosemaryl but unfortunately they connect via citrux and then the report is ran. The dabase user is a universal login. Thanks though!! Will keep plugging away.

 

[IdoMillet]

I don't know of any way to do this just with Crystal but have a look at a listing of 3rd-party tools at:

http://www.kenhamady.com/bookmarks.html

My DataLink Viewer:

http://www.milletsoftware.com/DataLink_Viewer.htm

allows you to automatically assign the NT login name to a parameter (the user never gets prompted for it).
This allows you to filter the data based on who's running the report.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com