Sharepoint 2010 Current User

• Olalekan Adewale

  Right there with Babe

  Points: 767

  More actions

  December 6, 2011 at 4:40 am

  #264177

  Hi guys,

  I work with Sharepoint 2010 and reporting services 2008 R2 integrated mode.

  I need to filter the report base on current Sharepoint user.

  Select field1,field2,field3,field4 from table where user = @SPCurrentUser

  I have checked everywhere for the solution.

  Kindly help or suggestion on how to arrive at a solution.

  Many thanks

  Abacusdotcom

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  December 8, 2011 at 2:59 am

  #1418548

  Can't you use User!UserID?

  http://blogs.msdn.com/b/tudortr/archive/2004/07/20/189398.aspx?wa=wsignin1.0

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• Olalekan Adewale

  Right there with Babe

  Points: 767

  More actions

  December 8, 2011 at 3:22 am

  #1418559

  Thanks Koen for your help.

  By my understanding, User!UserId returns windows user (i.e one who logged in to machine) .

  I want to return sharepoint user (One who sharepoint FBA authenticates).

  Many thanks.

• rnbergren

  Grasshopper

  Points: 11

  More actions

  December 28, 2011 at 10:55 am

  #1426190

  actually no. &userID returns the userid of the person logged into the sp page. while used on a SP site.

• Olalekan Adewale

  Right there with Babe

  Points: 767

  More actions

  December 29, 2011 at 4:37 am

  #1426380

  Thanks Boss. Forgive my laziness I will try that ASAP. Many thanks.