I have created an SSRS report that renders a table from my DB. I have created a multi-value text parameter separate by ','
In My dataset, I use (WHERE col1 IN (@parm)) and the data set parameter, I have the expression : =split(Parameters!Myvalue.Value,",")
All work fine when I run the report and enter in 1 or multiple value.... BUT I'd like when type in the text box * or leave it blank, it will load ALL Data... Please advise how I can do this.