Default Empty Report Parameters

Delford Chaffin asked on February 23, 2017 23:20

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!

Recent Answers


Brenden Kehren answered on February 24, 2017 00:26

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.

2 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.