0

SQL connection and system tables

Jet Reports Historic Posts

January 14, 2015 11:30

None

Follow

OK.
Makes sense.

Thanks!

rmw

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts January 14, 2015 11:30

  NL("Rows";"2000000001 Object")generates the error: Invalid table '2000000001'
  
  I used it with the NAV2009 connector and switched to a NAV2013 SQL connector.
  
  Why isn't this working anymore?
  Did I miss something?
  The table still exists…
  
  rmw
• 0
  
  Jet Reports Historic Posts January 14, 2015 17:29

  Hi RMW,
  
  The object table is one of those tables that is only accessible via the Web Services connector. One way around this is to use the DataSource= for those specific functions that need to access that table.
  
  They will run a little slower because it is using the Web Services connector, but it will grant you access to that table.