0

Combine two LinkFields in one column?

Jet Reports Historic Posts

February 15, 2016 19:16

None

Follow

I am building a very simple report on the names our Vendors and Customers have for our items. (Basically the Item Cross Reference Table with a few other tables for names and descriptions). I would like to have the name of the company in a single column, regardless of whether they are a Vendor or Customer. Is there a way to combine the columns in Question? In the file, they are columns I and J.

Thanks for any help. Also, if there is a support article on this for relative newbies, I'd appreciate the url(s).

• Item Cross Reference Design.xlsx
• Item Cross Reference Results.xlsx

• Facebook
• Twitter
• LinkedIn

8 comments

• 0
  
  Jet Reports Historic Posts February 16, 2016 08:34

  I'm afraid I'm not very familiar with tables.
  
  But you could do something like hide the source columns and then use and IF statement:
  
  =IF(VendorName="",CustomerName,VendorName)
  
  You could do it straight in jet by doing something like:
  
  =IF(NF(Source,"Vendor Name")="",NF(Source,"Customer Name"),NF(Source,"Vendor Name"))

• 0
  
  Jet Reports Historic Posts February 16, 2016 19:59

  =IF(NL("LinkField","Customer","Name")="",NL("LinkField","Vendor","Name"),NL("LinkField","Customer","Name"))
  
  This does not do anything. When I change the code in H5, the code shown below does not change. I think I am not understanding something fundamental about the table creation process.
  
  
  
  
• 0
  
  Jet Reports Historic Posts February 17, 2016 22:06

  Hi, Reid.
  
  Are you using Table Builder to generate this report? Are you an Express or an Essentials user?

• 0
  
  Jet Reports Historic Posts February 22, 2016 15:24

  I am an Essentials user and Table Builder was used to build it. I'm trying to adapt it.
  
  Thanks,
  
  Reid

• 0
  
  Jet Reports Historic Posts February 24, 2016 20:08

  That's what I thought. I don't know if there's a convenient way to adapt it, but starting over from scratch to write a fresh report using the more advanced methods is probably faster and easier.
  
  I did a quick search through the KB, and this article is probably where you want to start: http://kb.jetreports.com/article/AA-00723/0/
  
  Using this method you could definitely bring names from each table into a single column, and then maybe use a column to the right to draw in the vendor/customer names.

• 0
  
  Jet Reports Historic Posts February 26, 2016 19:45

  Thanks! I know how to link tables and create reports - I don't know how to make them look like the Table builder report. I will try to find a tutorial on how to use the NL("Table"…) function without using table builder.

• 0
  
  Jet Reports Historic Posts March 21, 2016 15:12

  Thanks! I know how to link tables and create reports - I don't know how to make them look like the Table builder report. I will try to find a tutorial on how to use the NL("Table"…) function without using table builder.

  
  I am not familiar with using Excel functions in the Table Builder, but you might want to see if there is a way to use an IF, and LEFT,1 function to pull in the vendor name if the Customer/Vendor No. field = "V" (this is assuming that all of your vendors begin with "V"), if not, then pull in the customer name.
  
  Again, I am not at all familiar with Excel functions in the Table Builder, but I do know that you can add formulas to a field, and that may be something you wish to experiment with.
  
  Does anyone know if what I stated above is possible?
• 0
  
  Jet Reports Historic Posts March 28, 2016 19:47

  Thank you. I just rebuilt it from scratch and got what I needed.