You can’t leave it blank. The parent result is a row. You need a column reference to get a value from that row. (And where did you get the idea it could be blank?)
Your right, it can not be blank…I thought the parameter was blank when I started testing WITHOUT the date range checking and there were no error reported…going back to that code I see that it defaulted the parameter to the parent SQL query column name…I could’ve swear it was blank yesterday
My question is related to the nested query but bit different.
I want to use IN clause in query but while passing parameters I am getting issue.
It works for single parameter value but not for a string of multiple parameter values. I tried almost all possible ways to form an expression in parameters but didn't get result. What expression syntax am I missing here? Please suggest.
I am trying hardcoded parameters values here just to check.
In most cases, particularly in named queries and in the report builder, placeholder parameters can only take single values, not lists. Where you wish to use IN, you must generate multiple question marks. Only scripted "Prep" queries can do this.
