0

Using the "SQL=" command

Jet Reports Historic Posts

July 03, 2008 08:31

None

Follow

Can anyone give me an example of using the "SQL=" command over the Navision SQL database.

I can't seem to get it to connect as it always comes up as #VALUE

An example of what I have tried is:

=NL("Rows","SQL=SELECT ""Item No."",""Location Code"" FROM ""Stockkeeping Unit"" ",{"Item No.","Location Code"},,,,,,,,,,,,,,,,,,,)

I have used just changed an example Northwind query to try and access the Navision Tables.

Regards,

Lloyd

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts July 03, 2008 19:14

  First question, are you licensed for the SQL command?

• 0
  
  Jet Reports Historic Posts July 04, 2008 00:01

  We are licensed for the Universal Connector.
  
  Does this means we are licensed to use the SQL command?
  
  Regards,
  
  Lloyd

• 0
  
  Jet Reports Historic Posts July 04, 2008 12:40

  I believe it does.

• 0
  
  Jet Reports Historic Posts July 04, 2008 14:05

  Thanks for you input Mark.
  
  I believe then the answer to this thread lies in the answer you gave to my other thread to my other thread.
  
  Let's hope that the Jet Reports team get stuck into Navision 5.0 on SQL Server compatibility and speed.
  
  Regards,
  
  Lloyd