0

Table Builder - Concatenate

Jet Reports Historic Posts

October 17, 2016 17:07

None

Follow

I am trying to Concatenate two Text fields within the Table Builder. Here is my current formula.

=NP("Formula","CONCATENATE([@[No.]]," - ",[@[Name]])")

The result when I run the Table #VALUE!

The result I am looking for is 1000 - Customer ABC

I have tried so many variations of this formula and cannot find the correct one. What am I doing wrong??

• Facebook
• Twitter
• LinkedIn

7 comments

• 0
  
  Jet Reports Historic Posts October 17, 2016 22:58

  Hello A1becker,
  
  Please see a similar Community posting with an answer in the below link:
  https://community.jetreports.com/viewtopic.php?t=4478
  
  Cheers,

• 0
  
  Jet Reports Historic Posts October 18, 2016 13:53

  Thanks for the link. I did "scour" this site for answers before I posted my question. That is why I copied the exact formula I entered into NAV. I am wondering if I am just missing some "," or ")" and do no see it.
  
  Thanks,

• 0
  
  Jet Reports Historic Posts October 25, 2016 15:21

  A1becker,
  
  Did you get this resolved?
  
  When I create this formula in Table Builder, I get the following:
  =NP("Formula","concatenate([@[No.]],"" - "",[@[Name]])")
  
  This produces your desired results. Compared to your formula, mine has double quotes around the dash (-) where yours does not.
  
  Regards

• 0
  
  Jet Reports Historic Posts October 25, 2016 17:13

  krd1996,
  
  thanks for the suggestion but I still get an error message. first I added another set of ("). That did not give me the correct results. Then I copied your formula and popped it into my Table. Still did not get the desired results.
  
  
  
  Thanks for any suggestions you may have for me.
• 0
  
  Jet Reports Historic Posts October 27, 2016 16:54

  The formula, when in Excel should be =NP("Formula","CONCATENATE([@[No.]],"" - "",[@[Name]])") with double quotes surrounding the -.

• 0
  
  Jet Reports Historic Posts June 16, 2017 07:19

  formula is working win 10 but not in win 7 .. I think you should try win 8 or win 10 to work as well.

• 0
  
  Donald Lanthier May 09, 2018 19:05

  I'm having the same issu, I'm trying to concatenate two fields "First Name" and "Last Name" in a report built with Table Builder

  I'm using Jet Report Pro on Windows 10. I went on the community and the support tpoics, nothing.

  Here is the result in Excel./Jet Report

  

  Anyone as a clue, how to solve this case?