0

NL (Table) - headers

Jet Reports Historic Posts

February 16, 2015 18:05

None

Follow

I don't believe you can do this with an NL Table because (I could be wrong) but in Excel, I believe a table requires some sort of header. If there aren't headers, Excel will make the first value a header which isn't what you want either.

Can you not just use another NL Rows to get the data you need instead of a table?

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts February 16, 2015 18:05

  Hi,
  
  I'm building a report that first replicates all datasources and companies as NL(rows) and then expands on each line a NL(Table).All the data retrieved is correct, but the issue is that each time the NL(Table) expands I get the headers. I would like that the headers would only show once at the top.
  
  I've tried a couple of different approaches, but none were successful:
  1. To point the NL(Table) parameter ("Headers=") to a fixed Excel range;
  2. To exclude the "headers=" parameter from the NL Table formula.
  
  Could you please let me know if what I'm trying to accomplish is possible?
  
  Thanks

• 0
  
  Jet Reports Historic Posts February 19, 2015 18:59

  Thanks for the suggestion, but unfortunately NL("Rows") is just too slow to retrieve what I'm after, so would really need to use the NL(Table).
  I suspected this was not possible, but just wanted the opinion of all you jet gurus out there :)
  Thanks

• 0
  
  Jet Reports Historic Posts February 20, 2015 15:39

  You could put a hide on the header row - but that will only work if you don't delete hidden rows and columns - because as JET-br mentioned, you have to have the header in the table (but there's no reason the header can't be hidden).