Can someone please help me out. I am trying to create a Microsoft SQL query for a report that gets its parameter through a subquery. I keep getting the following error however 'Parameters not allowed in queries that can't be displayed graphically.'
Below is my SQL query that has been simplified. Can someone please show me what I am doing wrong.
select * from report where column_A is in
(select column_A from
where (column_B = ?) and (column_C = 1))