Passing NT username as a parameter for report

• Ralph L. Wahlert

  SSC-Addicted

  Points: 430

  More actions

  September 9, 2009 at 7:37 am

  #209758

  I am writing a report so that only the logged in user will see his or her own data. I have a table that maps the userid to a specific value, a general ledger account number, and I want to pass the username to a report parameter.

  Does anyone have an idea how I can do this?

  Thanks.

  Ralph

• jmessersmith-1145599

  Say Hey Kid

  Points: 681

  More actions

  September 9, 2009 at 1:12 pm

  #1051385

  use SYSTEM_USER in the where statement of the query, make sure you use NT auth.