0

Sessions Idle Time

Jet Reports Historic Posts

July 29, 2009 20:36

None

Follow

Hello all,

Occasionally we will see a Navision session that has been logged in for several days without any use. I'm trying to pull the "Idle Time" field from the "Session" table, and the result I get for each session is "*******" (7 asterisks). The session that runs the report is the only one that returns a unique result, and that is simply a blank, "", as it would have 0 idle time.

Then NL is
=NL("rows","Session",)
and the NF is
=NF($B3,"Idle Time")

Anybody have any insight here?

Thanks,

Eric

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts August 04, 2009 15:27

  Eric,
  
  I've tested this with Nav 5.01 and Jet Reports 7.1.2.1830 and it seems to work fine for me.
  
  What version of Excel, Jet Reports, and Navision are you using?

• 0
  
  Jet Reports Historic Posts August 04, 2009 20:15

  I had the same issue as above, I'm running:
  
  Excel 2003 (11.8307.8221) SP3
  Jet 7.1.0 Build 1812
  NAV 5.00 (SQL)
  Windows XP SP3

• 0
  
  Jet Reports Historic Posts August 11, 2009 20:05

  I have:
  Navision 4.0
  Excel 2003 (11.8307.8221) SP3
  Jet 7.1.2 Build 1825
  
  It sounds like 1 of those 3 is likely the culprit.

• 0
  
  Jet Reports Historic Posts August 12, 2009 13:27

  I upgraded my Jet to 7.1.2.1830 and still had the problem - I presume its related to the Nav version then?