0

Link 2 tables from different data sources?

Jet Reports Historic Posts

August 07, 2013 18:51

None

Follow

Hi,

Just updated my JET from version 9 to 14 and am rather impressed by the new features I have found. Can anyone tell me, does the new JET allow me to link tables from 2 different datasources?? Any info appreciated. Just wondering if it is possible??

• Facebook
• Twitter
• LinkedIn

6 comments

• 
  Jet Reports Historic Posts August 08, 2013 14:03 Official comment

  Hi,
  
  Okay I'll take a shot at it. It sounds like you need something like this:
  
  C2: =NL("Filter","shpShipment","Snipno","Code","X","DataSource=","Data Source B") C3: =NL("Rows","Shipment Ledger Entry",,"No.",$C$2,"DataSource=","Data Source A")
  Does that help?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts August 07, 2013 19:19

  Hi,
  
  Nope, that is not possible. You could use NL(Filter) to link tables from different data sources, but not Link= (I assume that is what you are asking).
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts August 07, 2013 21:12

  Thanks for the info. Do you have a sample of NL(Filter)?? I am not familiar with how to use that function.

• 0
  
  Jet Reports Historic Posts August 07, 2013 22:31

  So basically NL(Filter) has the same arguments as any other NL function, but it returns a string which gets turned into an array of values for the function which is using it. So you might do something like this:
  
  C2: =NL("Filter","Customer","No.",…..,"DataSource=","My First DataSource") C3: =NL("Rows","Customer",,"No.",$C$2,"DataSource=","My Second DataSource")
  So in this example, I'm using NL(Rows) to return customers from one data source where the customers matches some criteria from customers in another data source. Does that make sense?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts August 08, 2013 13:27

  Thanks for the info but I am still a little unclear to how this works. I have two tables in different datasources, table-A is "Shipment Ledger Entry" and table-B is "shpShipment" both have a field containing a "shipment number" in table-A it is called "No." and in table-B it is called "Shipno". In table-B there is another fields called "Code" that needs to be used to filter to show only code "X" which would return results from table-A if the had a "Code" "X" in table-B. Clear as mud?? ANy help appreciated, thanks!

• 0
  
  Jet Reports Historic Posts August 08, 2013 14:58

  yep, I believe that does the trick, verifying data now but all looks good. Thanks for your assistance!