Hi everyone,
I have a report with 2 parameters - Account Manager and Company.
They are both populated from SQL Queries.
The Company query uses the value of the Account Manager parameter in the Where clause so that if an Account Manager is slected only the companies they are in charge of are displayed in the Company parameter.
My Select statement for the Company parameter list is as follows:
SELECT C.Company_Name
FROM Company C INNER JOIN
Employee E ON C.Account_Manager_Id = E.Employee_Id
WHERE (C.Type LIKE ('Customer%') OR C.Type = ('Partner - Customer'))
AND (E._Full_Name = @.Account_Manager)
How can I get this to work if I change the Account Manager parameter to be a Multi-value parameter?
I have tried replacing the "E._Full_Name = @.Account_Manager" with "E._Full_Name IN @.Account_Manager" but this does not work - is there another way to get this working?
Thanks,
Paul.
The IN clause requires the use of brackets.
Try E._Full_Name IN (@.Account_Manager)
|||That did the trick, thanks!