I have read articles on making a parameter in SQL Reporting Services (SSRS) be optional. But, no matter what I do, the attached report will not run unless I fill in information for both of the parameters.
Long story short, I want the second ContractNo parameter to be optional. Some of the vendors in the other parameter (Vendor) do not have contract numbers.
So, I want to be able to either have the parameter be null or simply not have to make a selection in that field.
Please let me know how I can accomplish this.