So there is a lot of stuff about using SSRS parameters to select multiple values but nothing about using both a parameter and a fixed value using the in select statement.
So what I'm trying to do is this:
select * from table where id in (Parameter_1, 'total')
Yet when I do that it complains its can't find 'Parameter_1'.
I've gotten another report to work when its just:
select * from table where id = Parameter_2
but this this isn't good enough in this use case.