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
------------------------------
Original Message:
Sent: 11-24-2021 09:30
From: Stanton Schmidt
Subject: Multi Value List or Multi Selection Button parameters
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