I have a report created with a "Name" parameter. In my query, I have:
Name LIKE '%'+@Name+'%'
If I go to the View tab and click the OK button and leave that field blank, it loads all values. How can I make it load immediately without having to click the OK button? If I put a default value of anything in the name field, it automatically loads - why does it not do it with an empty default? Is there any way around this?
Thanks!
Since it is an input parameter it is requiring input prior to loading the data which is why it's not showing anything prior. You may be able to provide a default value and get it to run that way.
Please, sign in to be able to submit a new answer.