/* ----------------------------------------------------------------------------
List of Insurance Companies for ESP
---------------------------------------------------------------------------- */
SELECT DISTINCT
plan_name
, plan_id
FROM benefits_assignments_clients_view bacl
ORDER BY 1
SELECT plan_id
FROM benefits_assignments_clients_view bacl
WHERE 1 = 1
-- condition line bellow
AND plan_id IN ('plan_id_1', 'plan_id_2')
-- use the first query to list the [plan_id]s
-- add the ones you want to see to the [IN] clause (between single quotes and comma separated) and copy that "condition" to the [SQL] field of the SubReport
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.