0

CONCATENATE (really a Excel-question)

Jet Reports Historic Posts

November 09, 2011 07:43

None

Follow

Hi!

This is really a Excel-question, but I'll try here anyways =)

AB48 =CONCATENATE(AF48;" ";AG48;" ";AH48;" ";AI48)
AF48: =NL(-1;"Comment Line";"Date";"Table Name";"JOB";"No.";4851) (This gives a date)
AG48: =NL(-1;"Comment Line";"Code";"Table Name";"JOB";"No.";4851) (This gives "REV06")
AH48: =NL(-1;"Comment Line";"Comment";"Table Name";"JOB";"No.";4851)
AI48: =NL(-1;"Comment Line";"Comment2";"Table Name";"JOB";"No.";4851)

AB48 shows: 40846 REV06 Dette er en test 123

The problem is that I want to show the date, not 40846.

Any ideas on how to to this?

• Facebook
• Twitter
• LinkedIn

8 comments

• 0
  
  Jet Reports Historic Posts November 09, 2011 09:55

  AB48 =CONCATENATE(text(AF48,"DD/MM/YYYY");" ";AG48;" ";AH48;" ";AI48)
  
  some read up on text() in Excel
  
  http://www.google.com.sg/#sclient=psy-ab&hl=en&source=hp&q=text()+in+excel&pbx=1&oq=text()+in+excel&aq=f&aqi=g4&aql=&gs_sm=e&gs_upl=2927l4360l1l4602l9l7l0l0l0l1l398l1625l2.1.2.2l7l0&bav=on.2,or.r_gc.r_pw.r_cp.,cf.osb&fp=4755da3e8d93f9c3&biw=1600&bih=799

• 0
  
  Jet Reports Historic Posts November 09, 2011 12:43

  Maybe a reason for NP("Format",AF48) being there…

• 0
  
  Jet Reports Historic Posts November 09, 2011 16:56

  Sebastiaan,
  
  There already is an NP(Format) function but it doesn't really work much differently than the Excel Text function so why would you want it? Basically the only difference is that NP(Format) accepts a Visual Basic style format string. There's not really a reason to use something like this instead of just using the Excel text function (and it involves more typing).
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts November 10, 2011 08:29

  Thanks!! :D

• 0
  
  Jet Reports Historic Posts November 10, 2011 08:32

  There already is an NP(Format) function

  I know that is why I pointed it out
  
  

  but it doesn't really work much differently than the Excel Text function so why would you want it? Basically the only difference is that NP(Format) accepts a Visual Basic style format string.

  Because it does not need a format string it makes it more usefull for internationally used reports.
  
  

  There's not really a reason to use something like this instead of just using the Excel text function (and it involves more typing).

  I think it should be used more often especially by you guys in the sample reports installed with JetReports, because almost none of them work "out-of-the-box" because of US-formatted dates.
• 0
  
  Jet Reports Historic Posts November 10, 2011 18:20

  Sebastiaan,
  
  Hmmm, it's interesting that NP(Format) is working without a format specified. This is actually working completely by accident I believe (we must be passing in an empty string to the function and for some reason it is formatting the date in a local date format). I wouldn't depend on NP(Format) going forward too much. It depends on an API call which Microsoft has deprecated and which may disappear or stop working in a future version of Windows or the .NET Framework. This is the reason we don't really advertise this functionality. It is provided solely for backwards compatibility with older versions of Jet.
  
  I'm not sure what sample reports "installed with JetReports" you're talking about. We haven't bundled any sample reports with the Jet Reports installer for years now.
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts November 11, 2011 12:21

  Sorry, I was pointing to the reports bundled with the "Jet Reports Player".

• 0
  
  Jet Reports Historic Posts November 11, 2011 16:20

  Hi Sebastiaan-
  
  Good suggestion - will tweak the published reports to address this issue.
  
  Thanks,
  Steve