0

Reporting on NAV hidden/system tables

Jet Reports Historic Posts

March 18, 2015 14:06

None

Follow

Hi
Is there a way of reporting on hidden tables in the NAV database such as 2000000009 (Session) and 2000000044 (Permission Range).
If I create a simple NL table formula e.g. =NL("Table", "Session"), I get an invalid table error.

Thanks

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts March 18, 2015 16:24

  Hi mmccabe,
  
  What kind of Data Source do you have set up to your NAV DB? If you are using the NAV SQL data source type, you do not have access to the system tables. Try setting up a Web Services data source. You should be able to see all the system tables with it.
  
  Since you will get better performance with the NAV SQL direct data source, I would recommend pulling most of the information in the report with that data source. Then use datasource= to the Web Services data source for the info from the system tables. The best of both worlds!

• 0
  
  Jet Reports Historic Posts March 24, 2015 11:46

  That's a really useful piece of advice - thank you.