Sample Header Ad - 728x90

SSRS - select where parameter and fixed value

0 votes
2 answers
517 views
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.
Asked by Exostrike (183 rep)
Aug 10, 2018, 09:58 AM
Last activity: Jan 6, 2025, 12:00 AM