<div>
Without looking at your report, couple of options:<br />
(1) &nbsp;Create a new report that has as it's recordsource the same SQL but without the parameter, so it returns all rows<br />
(2) &nbsp;Create a 'dummy' parameter that menas return all rows (-1, 0 are typical), then change the report's RecordSource so that it does something like this:<br />
<br />
&nbsp; &nbsp; SELECT Everyone<br />
&nbsp; &nbsp; FROM Vendors<br />
&nbsp; &nbsp; WHERE (VendorID = @VendorID OR @VendorID = -1)
</div>


Without looking at your report, couple of options:
(1)  Create a new report that has as it's recordsource the same SQL but without the parameter, so it returns all rows
(2)  Create a 'dummy' parameter that menas return all rows (-1, 0 are typical), then change the report's RecordSource so that it does something like this:

    SELECT Everyone
    FROM Vendors
    WHERE (VendorID = @VendorID OR @VendorID = -1)

<div>
I don't want to have 2 different reports - The users should have the option to choose a vendor or not.<br />
<br />
What do you mean create a dummy parameter? &nbsp;do I do that in the query?
</div>


I don't want to have 2 different reports - The users should have the option to choose a vendor or not.

What do you mean create a dummy parameter?  do I do that in the query?

<div>
<div class="content wysiwyg-content">
I have created a report that has a parameter for Vendor ID - but how do I let the user choose a vendor or display all the vendors. &nbsp;I've tried using * in the query filter but no luck. &nbsp;The parameter is requiring me to enter a vendor number and returns an error if I leave it blank.
</div>
</div>


I have created a report that has a parameter for Vendor ID - but how do I let the user choose a vendor or display all the vendors.  I've tried using * in the query filter but no luck.  The parameter is requiring me to enter a vendor number and returns an error if I leave it blank.

Adding a Parameter choice or everything

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.