0

Retrieving the Nav USERID

Jet Reports Historic Posts

July 14, 2008 07:15

None

Follow

Hi all,

Just a simple question: can we retrieve the USERID that's set up and used in the data source ?

cheers,

Denis

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts July 15, 2008 16:21

  I think I've used tihs before.
  
  =NL("First","Sessions","UserID","My Session","True")
  
  I'm not exactly sure of the table and field names, but they are close. Also, I'm not sure this works on the SQL version of Navision.

• 0
  
  Jet Reports Historic Posts July 15, 2008 17:20

  I was able to take Chuck's solution and get it to work on SQL:
  
  =nl("First","Session","User ID","My Session","true")
  You could use "Rows" instead of first as technically it should only ever return one row.
  
  Nice work Chuck.

• 0
  
  Jet Reports Historic Posts July 16, 2008 06:58

  I was able to take Chuck's solution and get it to work on SQL:
  
  =nl("First","Session","User ID","My Session","true")
  You could use "Rows" instead of first as technically it should only ever return one row.
  
  Nice work Chuck.

  
  Intresting, I know it would return only one row but why would you use "Rows" if you know you would only get one?
  As an SQL statement, I recon "First" is a faster statement (obviously performance isn't an issue on 10-record-tabled). If I know I'm only gonna have one record, I usually leave it blank
  =NL(,"Session","User ID")
  Can anyone help on the most effective of the three (knowing that you would only have one record):
  
  =NL(,"Session","User ID")=NL("First","Session","User ID")=NL("Rows","Session","User ID")