Hi all,
I am quite new to JetReports, so I give it a try.
Is it possible to use a named range (with multiple columns) as datasource in a NL-function?
Thanks in advance for any help.
Erik
Date
Votes
6 comments
-
Jet Reports Historic Posts Can you provide an example?
Maybe a workbook with some data?
Are you looking to have the data in another workbook, or the same workbook as your report? -
Jet Reports Historic Posts I've made some attempts at this in the past, without much success - I'd be very interested to know if somebody else has.
What I've been doing is creating my table in Excel (un-named) and doing a NL("Rows") on the first column, excluding the header. I then use VLOOKUP to bring in the other values for that line. It seems to work nicely for me so far. Only catch is to use absolute cell references in the NL and the vlookup. -
Jet Reports Historic Posts Hereby an example of what I mean. In the Excel sheet I made a table and named the range to "table".
I would like to read "table" with a NL-function.
[size=85]namedrange.xls -
Jet Reports Historic Posts What really matters is what you want to do with the data.
See the attached as a very simple example. You could replace "Rows" with "Sheets" or "Columns" if needed. Note I did this on a computer without Jet so it might need tweaking. -
Jet Reports Historic Posts Revised the attachment
-
Jet Reports Historic Posts Thanks for your help!
Erik
Please sign in to leave a comment.