Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: dropdown parameter selection from multiple columns in query

  1. #1

    Default dropdown parameter selection from multiple columns in query

    I have a table of users with columns for first and last names. I'd like to have a parameter that is displayed as a drop down list for selecting a user, and the values displayed should be the user names (first and last, so data from 2 columns separated by a space).


    I'm thinking this may be possible with the "Display Value Formula" but I'm not sure how to implement it, or if its even possible.

  2. #2
    Join Date
    Sep 2011
    Posts
    152

    Default

    just write a query to concatenate the first and last name.
    like if you are using mysql then "select concat(lastname,firstname) as fullname form tablename" and use this as a parameter.


    other way to do at reporting label is:

    retrieve two field lastname and first name from query and then use

    "=CONCATENATE([lastname];[firstname])" in Display value formula while giving parameter.

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

    Default

    Personally, I hate the CONCATENATE function, as it is verbose and hard to read. I prefer the concat-operator & for that sort of job:

    =[firstname] & " " & [lastname]
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  4. #4

    Default

    excellent, thanks.

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.