1

Jet Express report with NAV 2015 want to remove BLANK from country/region code

Ahsanm M

August 23, 2017 07:07

None

Follow

Hi

Is there any way to remove the BLANK or empty records for Country/Region Code ? In Jet

In Jet express, I am using | (or) operator to filter the country code. But nothing found to remove the BLANK records.

Thanks

• Facebook
• Twitter
• LinkedIn

9 comments

• 0
  
  Sarah Kloser August 23, 2017 13:28

  Hi Ahsanm,

  In Jet, the syntax for blanks is '' (2 single tics) or @@. If you are trying to filter out blanks, use <>'' or <>@@.

   

• 0
  
  Ahsanm M August 23, 2017 16:32

  Hi Sarah

  Thanks for your feedback, I am using this way but it won't work.

  Customer Table>

  Country/Region Code : ES|SE|GB&<>''

  I would like to show only those country and remove the blank code.

  Can you please suggest if I missed anything?

  Kind Regards

  Ahsan

   

  Edited by Ahsanm M August 23, 2017 16:33
• 0
  
  Sarah Kloser August 23, 2017 16:35

  If you are filtering based on ES|SE|GB, you should never get the blank country codes - so there is no need to say <>''.

• 0
  
  Ahsanm M August 23, 2017 16:42

  Don't know but it returns the blank item. I have also other filters as well. Is there any possibility to return the blank item? Please see the below image following are my criteria.

  
   In excel sheet

  

  Edited by Ahsanm M August 23, 2017 16:44
• 0
  
  Sarah Kloser August 23, 2017 17:07

  Thank you for the screenshot!

  Since you are pulling in information from multiple tables, that adds more options... Your base table is the Value Entry table. This is what is driving the results in the report. You will always get the full list of records from that table based on the filters you set on that table.

  To limit the records based on the country code you would need to use the radio button saying to include only results where the customer record is found. Please see the screenshot below. The problem is that you are using Jet Express and you cannot click on the radio button to make this change. Only Jet Professional users can.

• 0
  
  Ahsanm M August 23, 2017 17:32

  Hi Sarah,

  You are great !! Thanks for your suggestions. 

  But bad luck no option without Jet express, without using this feature, can I have any other option to remove the blank code?

  Kind Regards

  Ahsan

• 0
  
  Sarah Kloser August 23, 2017 17:35

  Since the Table Builder creates a table in Excel, you can always use the field filter at the top of the table - like you did in your screenshot. It will just have to be after you run the report...

• 0
  
  Ahsanm M August 23, 2017 17:40

  you can always use the field filter at the top of the table...... It will just have to be after you run the report... 

  Sorry, can't get it. Any example would be helpful to understand. 

  Thanks

• 0
  
  Sarah Kloser August 23, 2017 18:21

  Sorry for any confusion! I was just saying you can filter out the blank country codes after you run the report (just like you showed in your screenshot). Once you run the report, click the down arrow at the top of the country/region code field and deselect the (Blank) checkbox. You will be left with only the records you care about.