title: Adding optional filter in SSRS 2008
body: <p>I am trying to add an <em>optional</em> filter on a text field in a report. I have tried setting it up in the dataset but it treats it as a required filter so if it is not populated, no results are returned. It needs to use the Like operator. Any advice?</p>