0

Jet Essentials Flow field Nav2013

Jet Reports Historic Posts

February 05, 2015 20:34

None

Follow

Hi,
We are connecting to NAV2013 with SQL Server 2012, using Jet Essentials 2013 Update 1

I have a very basic report , which is querying the Customer table and the flow field balance.
I am however getting a VALUE error, and on clicking DEBUG get the message Invalid Table ".
Please find attached the corresponding file, using the Table builder
If I remove the Flowfield , the report works fine.

I also get the same error when I use the following formula
=NL("Table","Customer",{"Name","FlowField([Balance])"})

Any help would be appreciated
Thanks

• FlowFieldBasics.xlsx

• Facebook
• Twitter
• LinkedIn

5 comments

• 0
  
  Jet Reports Historic Posts February 06, 2015 08:02

  Hello,
  
  i'm trying both codes in my NAV-Database and don't get that error… :!:
  
  :?:
  
  regards
  jetsetter

• 0
  
  Jet Reports Historic Posts February 06, 2015 14:11

  @jetsetter,
  you running the same versions .
  
  So that could point to some kind of setup error ?
  Will try reinstalling jet.
  
  Is there something that would need to be done on the NAV side ?
  
  Thanks

• 0
  
  Jet Reports Historic Posts February 06, 2015 21:19

  If you try =NL("Table","Customer",{"Name","Balance"}) do you get an error?

• 0
  
  Jet Reports Historic Posts February 10, 2015 14:41

  Yes I get the same error Invalid Table
  I have enabled logging as well, please find below the error from within the log file
  
  2015-02-06 16.00.34.776 ErrorManager.Handle: A Jet Reports error has occurred:
  Invalid Table ''.
  Jet.Data.InvalidTableException
  at Jet.Data.Nav.NavTableDictionary.get_Item(String tableId)
  at Jet.Data.Nav.NavSqlDataSource.a(NavTableInfo A_0, IEnumerable`1 A_1, e A_2, IEnumerable`1 A_3)
  at Jet.Data.Nav.NavSqlDataSource.c(b2 query)
  at Jet.Data.Nav.NavSqlDataSource.ExecuteQuery(b2 query)
  at Jet.JetDispatcher.a(fe A_0, IJetDataSource A_1)
  at Jet.JetDispatcher.a(fe A_0, Boolean A_1, Boolean A_2)
  at Jet.JetDispatcher.a(fe A_0, Boolean A_1)
  at Jet.JetDispatcher.b(fe A_0, Boolean A_1)
  at Jet.JetDispatcher.f(fe A_0, Boolean A_1)
  at Jet.JetDispatcher.e(Object[] A_0)

• 0
  
  Jet Reports Historic Posts March 03, 2015 18:22

  Apparently , this problem is caused by our customization within Navision with regards to the Default Dimension, which causes advanced dimensions to be not loaded, should be fixed in the next version of Jet Reports.