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?
Date
Votes
3 comments
-
Jet Reports Historic Posts 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 -
Jet Reports Historic Posts 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 -
Jet Reports Historic Posts 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).
Please sign in to leave a comment.