General Discussion

  • 1.  Multi Value List or Multi Selection Button parameters

    Posted 11 days ago
    I am trying to add either a Multi Value List or Multi Selection Button parameter to a report using the Pentaho Report Designer.

    What I have not been able to figure out is how to add that parameter to the query for the report.
    Can anyone help me?

    stanton schmidt
    Database Administrator/EDI
    direct. 920.471.4495

    cell. 920.660.1828

     

    RGL
    GO AHEAD.  ASK WHAT IF.
    www.RGLlogistics.com




  • 2.  RE: Multi Value List or Multi Selection Button parameters

    Posted 6 days ago
    Assuming you're using SQL your parameter should be passed to an IN clause i.e
    SELECT 
      column
    FROM
      table​
    WHERE
      filterColumn IN (${parameterName})

    if you're using MQL  you can pass it as a regular constraint

    <constarints>
      <constraint>
        <operator>AND</operator>
        <condition>EQUALS([BusinessViewID.BusinessColumnID];[param:parameterName])</condition>
      </constraint>
    </constraints>


    ------------------------------
    Ibrahim Bolarinwa
    Data Service Manager
    SS&C Technologies
    ------------------------------



  • 3.  RE: Multi Value List or Multi Selection Button parameters

    Posted 6 days ago
    Hi Stanton

    Like this.  The NameOfYourParameter inside ${} and used as an 'IN' clause.   Should come through as 'val1','val2','val3'

    ...INNER JOIN film ON film.film_id=inventory.film_id
    WHERE film.rating IN (${SelectRating})

    ------------------------------
    Andrew Cave
    Systems Engineer
    BizCubed Pty Ltd
    Australia
    ------------------------------