Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Label Concatenation

  1. #1
    Join Date
    Jun 2008
    Posts
    14

    Default Label Concatenation

    Hi all,

    I am just designing a report wit the report designer and have the problem, that I want to write out the name and and the family name concatenated in a text field.

    I saw that it works with two text fields, but it does not work if the text of the first text field is longer.

    How could this be done? I tried with +, but it did not work.

    Please give me a hint.

    Lg,

    Frank

  2. #2
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    Use a string-field with a value formula that does the string-concatenation for you:

    Code:
    =[field1] & " " & [field2]
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  3. #3
    Join Date
    Jun 2008
    Posts
    14

    Default String concatenation

    Hi Taqua,

    thanks for your reply.

    I found another solution in concatenating the name and the surname directly via the database select.

    But your way would have worked too.

    Lg,

    Frank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.