0

named range as datasource

Jet Reports Historic Posts

May 26, 2009 07:18

None

Follow

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

• Facebook
• Twitter
• LinkedIn

6 comments

• 0
  
  Jet Reports Historic Posts May 26, 2009 15:17

  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?

• 0
  
  Jet Reports Historic Posts May 26, 2009 15:49

  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.

• 0
  
  Jet Reports Historic Posts May 27, 2009 07:40

  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
• 0
  
  Jet Reports Historic Posts May 27, 2009 10:30

  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.

  • namedrange2.xls
• 0
  
  Jet Reports Historic Posts May 27, 2009 13:29

  Revised the attachment

  • namedrange2_revised.xls
• 0
  
  Jet Reports Historic Posts May 28, 2009 15:51

  Thanks for your help!
  
  Erik