0

NL Sheets with a Blank Location

Jet Reports Historic Posts

September 26, 2013 12:53

None

Follow

Gooday All,

I need to Generate a worksheet for each location in NAV but the blank location does not show - i assume because a worksheet name cannot be blank.
Any ideas on how i can give it a name during/prior to replication so i can include this "Blank" worksheet location?

Thanks

Tom

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts September 26, 2013 13:40

  Sorry - please note that i am using the Inventory Posting Setup table location codes which has a Blank location there not the actual Location Table itself.
  
  Thanks

• 0
  
  Jet Reports Historic Posts September 27, 2013 14:42

  Generally speaking, blanks do get replicated with NL(Sheets). The sheet itself will get a name like (1) or (2) since Excel does not allow blank sheet names, but the value on the sheet will be blank and can be used for filtering (with an @@ of course). Is this not the case for you?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts October 03, 2013 13:34

  Hi Hughes,
  
  Just did a simple test - you are correct, seems the filter i was using was removing the blank location from the list of sheets to replicate and hence my problem.
  I will try my report again.
  
  Thanks for your help
  
  Tom