0

New user - filter problem

Jet Reports Historic Posts

October 20, 2011 14:17

None

Follow

Hi,

I am trying to build a sales order report and am having problems with the product description.

I have entered =NL("First","SalesLineItems","Item Description","Item Number",$G107) (column G being the item code) and for the majority the result is coming through, however it seems that where an item code includes an "&" or "/" the query returns nothing.

Is there an issue with characters being included with item codes?

Thanks,
Kerrie

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts October 24, 2011 12:17 Official comment

  Hi Kerry,
  
  It is always tricky when you use special characters in code fields in Navision, but you can get round it with Jet.
  Try this..
  
  =NL("First","SalesLineItems","Item Description","Item Number","@@"&$G107)
  
  the "@@"& in front of the cell reference with a special character in it will treat the cell value as string i believe and not try evaluate the special character that excel is trying to use.

• 0
  
  Jet Reports Historic Posts October 24, 2011 16:23

  Excellent, that has done the trick.
  
  Thanks very much :D